| Thread | Last Post | Replies |
|
| Oracle Intelligent Agent causes segmentation fault. | 21 Jul 2005 23:53 GMT | 1 |
CPU: Pentium OS: RedHat 9 DB Version: 9.2.0.1.0 (no patch) I searched the web and could find nothing conclusive as to the solution.
|
| ASM setup of shared disks for RAC | 21 Jul 2005 23:12 GMT | 1 |
It appears that ASM performs functions that a RAID normally performs. So if you have 6 disks in a shared network storage device, should one configure this is as 6 different drives and let ASM handle the mirroring, etc. or set up a RAID to create one highly available disk
|
| Oracle queues | 21 Jul 2005 23:06 GMT | 1 |
I'm new with Oracle queues, so I have a question. Is it possible to write a "typed" message? I need to write a message in queue and say: "this message has type X" and after read only messages of that type X. Could I make this operation?
|
| Oracle does not choose proper Index | 21 Jul 2005 22:28 GMT | 9 |
I have following 2 Oracle Queries: Query1:Select col1, col2 from table1 where col1 = :value1 order by col2 Query2:Select col1, col2 from table1 where col1 = :value2 order by col2 Here are some facts:
|
| #hints>1? | 21 Jul 2005 21:49 GMT | 2 |
Can one give more than one hint in an select-statement? Greetings Bjørn
|
| SQL sentence | 21 Jul 2005 21:43 GMT | 3 |
I have a table in oracle with information similar to this: city code A XX B SS
|
| ">" in select-Statement | 21 Jul 2005 21:25 GMT | 8 |
I wonder if i can use something like SELECT DECODE(a>b,0,1) FROM dual; to check if a is greater then b? Can someone help me please? Thank you!
|
| Problem comparing dates | 21 Jul 2005 21:13 GMT | 1 |
I amtrying to select rows that fit a certain time period. My table: BCV_START DATE COL1 VARCAHR2
|
| 0ra-01002 error | 21 Jul 2005 19:30 GMT | 5 |
I am getting 0ra-01002 error when I will run the following query. Could you please tell me how I can reolve this issue. Thanks in advance, S
|
| stripping html from a clob | 21 Jul 2005 19:21 GMT | 2 |
I am looking for an oracle function that can strip all html tags from data in a CLOB column. I have tried modifying str_html, which i found thru another posting and ask tom, but am having trouble getting it to work with a CLOB. Has anyone already modified this to work with a CLOB?
|
| Connecting JDeveloper to Oracle DB | 21 Jul 2005 17:59 GMT | 2 |
A dumb, dumb question. I have Oracle JDeveloper Version 9.0.5.0.0 Preview and instance of Oracle 10g Enterprise Edition Release 10.1.0.2.0 . All this is running on a single XP minicomputer. Problem: I cannot get JDeveloper to connect to the Oracle DB. I went through all the ...
|
| Oracle10g: default jobs | 21 Jul 2005 17:39 GMT | 4 |
Oracle10g 10.1.0.3.0 (64 bit) AIX 5.3L ML01 (64 bit) The following jobs are created by default in 10g - during db creation GATHER_STATS_JOB
|
| Oracle datafile recovery after hotback | 21 Jul 2005 15:58 GMT | 3 |
Hello Oracle Gurus, I came across a dabase recovery problem today (18th July-05) while doing some backup / recovery testing in test environment. The scenario is being explained in detail as below:
|
| How is a CLOB stored when XML is created from query? | 21 Jul 2005 15:20 GMT | 4 |
Does anyone know how a CLOB is stored in an XML doc that is created from a query using the XDK? Most XML docs show <column_name>(CLOB)</column_name> Can the clob be viewed? is there a corresponding hidden file that
|
| Need a way to split a varchar | 21 Jul 2005 13:57 GMT | 8 |
I am looking for a function, or some other way to split my variable type varchar. The way i would like to do it is to , cut the first word from the variable, place it in the database, along with the id of that word. Then move to the next word. Im using PL?SQL. Here is what i have
|