|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Execution of Query Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production |
4 |
1716 |
Tue, 02 August 2016 07:51 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to report oracle internal error |
4 |
3434 |
Tue, 02 August 2016 00:24 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sorting 12c |
6 |
2854 |
Mon, 01 August 2016 08:05 By: pablolee ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Error An INTO Clause Oracle, Toad, SQL Developer, Windows Server |
6 |
2517 |
Mon, 01 August 2016 06:53 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Same record with Space and Without Space Oracle 12c, Windows NT |
13 |
4528 |
Sun, 31 July 2016 03:33 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
comparison ALL with subquery returns no rows - TRUE Oracle 11.2.0.3 |
7 |
2462 |
Sat, 30 July 2016 03:08 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how create synonym for full database |
7 |
2905 |
Fri, 29 July 2016 07:54 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Database vs Tablespace |
17 |
4648 |
Fri, 29 July 2016 07:42 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Creating different worksheets in a single excel Oracle 11g |
2 |
1357 |
Thu, 28 July 2016 14:15 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Extract value from xml Oracle 12c |
3 |
2596 |
Thu, 28 July 2016 14:12 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
place set values next to each other Oracle 11.2.0.3 |
4 |
1662 |
Thu, 28 July 2016 13:47 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to display report format data Oracle 11 ( 1 2) By: ssyr22 on Thu, 30 June 2016 |
49 |
10805 |
Thu, 28 July 2016 02:40 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
unusable index on inserting data into partition table Oracle 11.0.2 |
3 |
1620 |
Thu, 28 July 2016 01:03 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
XML tag selection ORACLE 11g |
8 |
6913 |
Wed, 27 July 2016 02:09 By: pablolee ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Retrieve text for ID from another table for two columns in a SELECT statement Oracle 11.2.0.3.0 , OEL 5 |
4 |
1946 |
Tue, 26 July 2016 10:35 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How can I load 300k of data into a CLOB OEL 5, Oracle 11.2.0.3.0 |
13 |
3668 |
Mon, 25 July 2016 15:00 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
LAG error 10g, 8i, win 8.1 By: rzkhan on Mon, 25 July 2016 |
8 |
2933 |
Mon, 25 July 2016 07:35 By: rzkhan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Break a > 300k CLOB string into 32k chunks OEL 5, Oracle 11.2.0.3.0 |
10 |
2314 |
Sun, 24 July 2016 14:55 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Set a range into in time Forms, |
32 |
7893 |
Sat, 23 July 2016 06:54 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL query for formatted data display oracle, 11gR2, RHEL |
2 |
1846 |
Fri, 22 July 2016 13:40 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
GETTING NULLS WHEN USING PIVOT |
6 |
2200 |
Fri, 22 July 2016 10:24 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Deadlock experienced but Blocking lock expected 12.1.0.2 |
7 |
2430 |
Thu, 21 July 2016 12:20 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Getting Parent and Child from the same table & same column Oracle 11g/Windows 8.1 |
6 |
2451 |
Thu, 21 July 2016 06:23 By: naveenjv ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-01006 ORA-01006: la variable attachée (bind variable) n'existe pas By: pcouas on Wed, 20 July 2016 |
5 |
3012 |
Thu, 21 July 2016 04:50 By: pcouas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Logic for displaying below row as first row Oracle 10g |
12 |
3999 |
Thu, 21 July 2016 02:20 By: sss111ind ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Collection Last Record Oracle 11g |
4 |
1884 |
Wed, 20 July 2016 03:05 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Merging BLOB Oracle 11GR2, Windows Server 2008 R2 |
6 |
4045 |
Tue, 19 July 2016 08:00 By: Jaffat1982 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
sorting order need to be done when the columns in the order by are given in input parameter 11 g |
5 |
2146 |
Tue, 19 July 2016 07:31 By: saipavan.plsql ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
transposing of data in oracle oracle 12 c |
23 |
7773 |
Tue, 19 July 2016 03:49 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Change Current schema to other schema Oracle 11g, windows |
2 |
5435 |
Mon, 18 July 2016 03:54 By: flyboy ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Table joining Windows |
4 |
2390 |
Sun, 17 July 2016 23:44 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
heirarchy between tables |
1 |
1249 |
Sun, 17 July 2016 12:38 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Unpivot Query Help to transpose the data Oracle 11g |
2 |
1372 |
Sun, 17 July 2016 12:19 By: arifs3738 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-01722 when returning ROWTYPE in function oracle Database 11g Enterprise Edition Release 11.1.0.6.0 |
13 |
4514 |
Fri, 15 July 2016 14:45 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Parent child count? |
6 |
1618 |
Wed, 13 July 2016 03:36 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PLS-00907: cannot load libraryunit PROD.DAILY_RPT (referenced by ) 11G |
6 |
15304 |
Tue, 12 July 2016 13:40 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
finding constrains on table oracle 12c |
15 |
5084 |
Tue, 12 July 2016 02:20 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query: select id where max(value) - possible? Oracle By: ich01 on Mon, 11 July 2016 |
10 |
3491 |
Mon, 11 July 2016 17:52 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
information oracle 8 |
12 |
3673 |
Mon, 11 July 2016 16:32 By: ceciaide ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PL/SQL error Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit By: jcasas on Sat, 09 July 2016 |
11 |
3426 |
Sat, 09 July 2016 21:09 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |