22/09/2017 11:47
Again...I'm rusty, and have no documentation around...probably a stupidquestion.
I'm trying to join on a field that has some null values using (+), but,oracle doesn't seem to recognize this anymore. I'm on Oracle 9.2.0.6.
I've been looking up, an seeing that there is a new way to do an outterjoin, but, most examples I see only are using 2 tables and a couple offields, I can't figure how to use this on a large multi-table joinwhere lots of fields are being selected. Can .... read more

3 answersclick here to view

21/09/2017 11:47
Hi NG,Oracle decided to desupport Oracle Names in 10g. Willing or not, we're required to move to LDAP.
We're running here 100s of oracle instances named by the following scheme: INSTANCE.LOCATION.COMPANY.COUNTRY (e.g. db1.mch.oracle.de).
My problem moving to ldap comes with the domain names, of which we have dozens. I'd like to know, how the ldap tree looks like, exspecially how about the dc=OracleContext (required only on top-of-tree or in each domain?).
Could anyone provide a (ano.... read more

2 answersclick here to view

20/09/2017 11:47
Greetings, We are using Oracle 9i. Are regexp functions available in Oracle 9i, or was that introduced with 10? Given the following two strings: str_a='5838 MISSION CENTER RD #C'str_b='5838 MISSION CENTER RD C' orstr_a='7576 PARKWAY DR APT #2A'str_b='7576 PARKWAY DR APT 2A' is it possible to write an expression in Oracle 9i that will return true if the only difference between the two strings is the presence of the '#' symbol?

2 answersclick here to view

18/09/2017 11:47
Hi,I am pretty newbie to OCI layer. I was trying to make a connection tooracle, and was trying to fetch timestamp datatype by bindingtimpstamp datatype.
This datatype shows different behavior for different sub secondprecisions.
For my program(in c++) I was able to fetch data successfully fordirect execution for both Timestamp(6) and Timestamp(9). I am able tosee data value's.
On the other hand when I was trying to bind timestamp data,1) if my datatype is timestamp(6), it is unable to fetc.... read more

8 answersclick here to view

17/09/2017 11:47
Hi, Please let me know how to connect with the remote server in oracle asOS User.
ex:- sqlplus /@remote_database RegardsMahesh S

1 answersclick here to view

16/09/2017 11:47
Dear list members, now I have my first Oracle database running.
I can access it using sqlplus on command-line mode.
After creating the database I also could use theEnterprise Manager webtool using port 1158.
But after a reboot it wasn't started again (unlikethe rest of my database).
Could anyone tell me which service I have to start toprovide the EM manager web-tool (and how to configure itto start on mashine-boot) ? Best regards, Daniel Wetzler

4 answersclick here to view

15/09/2017 11:47
Hi, how can I set up an 9i Application Server only with Forms and Reports service? We don't need the other things LDAP, single sign on, Oracle Internet Directory, ...
But I'm only able to install the Forms and Report services after installing single sign on, ...
thanks Frank

2 answersclick here to view

14/09/2017 11:47
Folks,I am reading the Oracle 9i Database Performance Tuning Guide andReference, chapter 10 (Using SQL Trace and TKPROF). When I triedtracing my own SQL query (I am using Oracle 9.2.0.4 on SUN [sparc]Solaris 9), the output was slightly different than what appears inthe documentation. My output contained some extra details regardingthe query execution plan, for example: Rows Row Source Operation------- --------------------------------------------------- 1 SORT AGGREGATE (cr=2 r=0 w=0.... read more

2 answersclick here to view

13/09/2017 11:47
Hi everybody,I have a mysql db where i call a user defined function named exception when a constraint fail occurs. The function exception executes a fetch on an empty cursor to generate the SQL exception. I would like to know if there is a way to pass a parameter to the function exception, so I can get the type of occuring error from the function and print a significative message on the screen.
Thanks for the help.
Dymios

4 answersclick here to view

11/09/2017 11:47
Hello, I am looking for a Crystal Reports writer (version 10 a plus). I amfinding however, that not all Crystal aficionados post themselves onstandard job boards like Monster or Careerbuilder. Do you, or someoneyou know have Crystal Reports (in an Oracle 9i database) and need aposition in Massachusetts? Please give me a call at the number below,any info you may have, even on how to track down Crystal users, wouldbe much appreciated!Thanks! Emily McElfreshRecruiterGeneration Technologies, Inc..... read more

1 answersclick here to view

10/09/2017 11:47
So far I had been mostly satisfied with Pro*C/C++. It is a hugeimprovement from by previous programming environment (OCI. I can'tbelieve I ever programmed in that assembly language). All my programshave been written written in C so far. However, since I have beenknown to get myself into trouble :-) I decided to try the C++ side ofPro*C/C++, to take it for a spin.
Long story short: It was a bad decision, and I decided to go back togood ole' C.
Reasoning: (1) That is not real C++. I us.... read more

3 answersclick here to view

09/09/2017 11:47
Hi there.
My system is Oracle 9.2.0.5 on Windows.
I have 3 tables tblProbe, tblProbeType, tblProbe_HTTP (see at the end of this message) withSELECT pt.Name INTO v_Name FROM netprobe.tblProbe p INNER JOIN netprobe.tblProbeType pt ON p.PROBETYPE = pt.ProbeTypeID WHERE p.ProbeID = intProbeID;I get the Name, which I use for the Table.
Then I need to do: SELECT * FROM tblProbe_HTTP I tried to create a function which I can call from java laterI tried: CREATE OR REPLACE FUNCTION sp_getProbe.... read more

2 answersclick here to view

08/09/2017 11:47
Hello out there,I tried to configure alerts for full tablespaces usingdbms_server_alert.set_threshold. Since we do not have licenseddiagnostics pack I cannot do this with dbconsole. I have to resort tothe command line.
Anyway, I want to get a warning when the tablespace has less than 1GBfree space.
So I issued the following command: begin dbms_server_alert.set_threshold(metrics_id =>dbms_server_alert.tablespace_byt_free, warning_operator =>dbms_server_a.... read more

2 answersclick here to view

07/09/2017 11:47
hello, i'm new in pl/sql i have problem with basic command like: declare a number := 2;begin a := a + 1;end;.
run; becouse database show me: Executing: end ORA-00900: invalid SQL statement[Error Code: 900][SQL State: 42000] Executing: .
run ORA-00900: invalid SQL statement[Error Code: 900][SQL State: 42000] what is wrong, could enybody explain where is problem.
thanks in advantige.
sw

2 answersclick here to view

06/09/2017 11:47
I have a simple table with a hierarchical structure: CREATE TABLE relation (parent_id number, child_id number); INSERT INTO relation values (10,3);INSERT INTO relation values (3,2);INSERT INTO relation values (2,1);INSERT INTO relation values (10,5);INSERT INTO relation values (14,11);INSERT INTO relation values (11,17); I need to a query to return a results that lists every child and it'sdirect and not direct parent (it's parents parent and so on), Havingthe level would be nice too Fo.... read more

9 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS