|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
JSON Parsing Linux, Oracle 11.2.0.3.0 |
4 |
4010 |
Fri, 27 January 2017 04:31 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) |
|
Doubt in SYS_CONTEXT By: gajini on Tue, 24 January 2017 |
6 |
2698 |
Fri, 27 January 2017 03:24 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) |
|
scrambling the data for a column in a tables oracle 11g version 2 |
15 |
17570 |
Tue, 24 January 2017 13:28 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) |
|
SQL Execution Plan Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
4 |
2474 |
Mon, 23 January 2017 13:18 By: trivendra ![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) |
|
Edition Based Redefinition - Triggers on Editioning Views Oracle Database 11g Enterprise Edition 11.2.0.4.0 64 Bit Production, Linux By: fixxxer on Wed, 18 January 2017 |
7 |
3475 |
Mon, 23 January 2017 04: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) |
|
Oracle Outer join Operator(+) with operand of OR or IN Oracle, 11g, Windows 7 |
1 |
1679 |
Mon, 23 January 2017 00:22 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) |
|
Effective Date/Min Eff Seq subquery issues PS Student Administration |
4 |
2947 |
Sun, 22 January 2017 10:10 By: Lasmith76 ![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 create an object table |
5 |
2629 |
Sat, 21 January 2017 01:16 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) |
|
Remove null records from collection 11.2.0.4.0 |
1 |
2578 |
Thu, 19 January 2017 09:59 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) |
|
Collections Oracle 11.2.0.0 |
9 |
2761 |
Thu, 19 January 2017 08:30 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) |
|
unable to get data from V$SESSION table |
4 |
9316 |
Thu, 19 January 2017 06:39 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) |
|
Help with REGEXP_SUBSTR Oracle 10g |
6 |
3812 |
Tue, 17 January 2017 09:34 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) |
|
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2 Enterprise Edition 10.2.0.4.0 - 64bit, Windows Server 2008 |
9 |
3803 |
Mon, 16 January 2017 09:14 By: Roachcoach ![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) |
|
AUDSID temporary not found 12C (PDB) |
0 |
1795 |
Mon, 16 January 2017 04:36 By: Gogetter ![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) |
|
Regarding Hints Oracle 11g, Windows By: ninan on Thu, 12 January 2017 |
10 |
3435 |
Mon, 16 January 2017 03:44 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) |
|
PL/SQL table :: ORA-00902: invalid datatype Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
10 |
11877 |
Fri, 13 January 2017 22:59 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) |
|
ORA-14155 oracle 10g |
5 |
20084 |
Thu, 12 January 2017 20:34 By: arddy123 ![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) |
|
Help to write the SQL query to Oracle DEveloper 11G |
3 |
2487 |
Thu, 12 January 2017 12:52 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) |
|
DBA_VIEWS giving ORA-00942 Error Oracle Database 12c 12.1.0.2.0 - 64bit Production |
3 |
3746 |
Thu, 12 January 2017 08:01 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) |
|
add a sequential number to a query sql |
3 |
2341 |
Thu, 12 January 2017 07:57 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) |
|
Compiling in Debug Mode Oracle 11g / SQL Developer By: Irish88 on Tue, 10 January 2017 |
19 |
5851 |
Thu, 12 January 2017 07:23 By: Irish88 ![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) |
|
Recursive SQL Insert Oracle 11g |
2 |
1963 |
Tue, 10 January 2017 14:05 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) |
|
dependency question |
1 |
1834 |
Tue, 10 January 2017 13:52 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) |
|
separate 2 columns into 2 rows |
8 |
3385 |
Tue, 10 January 2017 03:42 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) |
|
GROUP BY COST CENTER |
2 |
2054 |
Mon, 09 January 2017 11:50 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) |
|
check format 10g |
6 |
2652 |
Sun, 08 January 2017 12:33 By: arifmd1705 ![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 ORA-01422: exact fetch returns more than requested number of rows By: msyogi on Sun, 08 January 2017 |
2 |
2306 |
Sun, 08 January 2017 11:32 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) |
|
execute immediate 11gR2, windows 7 |
6 |
2860 |
Sun, 08 January 2017 02:37 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 to Move fast the data from one database to another database ? |
2 |
2179 |
Fri, 06 January 2017 13:22 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) |
|
Shrink space Oracle 11g/12c |
3 |
2294 |
Fri, 06 January 2017 10:10 By: srinivas.k2005 ![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) |
|
email validation oracle 10g windowsXP |
11 |
14289 |
Thu, 05 January 2017 08:23 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) |
|
Collections - Nested Tables and VARRAY Oracle 11.2.0.3 |
3 |
2092 |
Thu, 05 January 2017 07:31 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) |
|
EXTERNAL TABLE CREATION ERROR |
7 |
7192 |
Wed, 04 January 2017 16:38 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) |
|
JSON_TABLE concurrent access issue Oracle 12C By: VeeS on Wed, 04 January 2017 |
1 |
3959 |
Wed, 04 January 2017 14:41 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) |
|
SYSDATE - 1 'MM' for JAN showing 0 instead of 12 Oracle By: aceboku on Tue, 03 January 2017 |
8 |
3703 |
Tue, 03 January 2017 12:52 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) |
|
Partitions oracle 12c |
4 |
2657 |
Tue, 03 January 2017 09:49 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) |
|
Insert the data into dynamically created table (2 threads merged by bb) 11.2.0.4 |
15 |
7273 |
Mon, 02 January 2017 23:20 By: grpatwari ![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) |
|
selecting the columns dynamically 11.2.0.4 |
5 |
2401 |
Mon, 02 January 2017 06:16 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) |
|
Problem accessing external tables over network Oracle 10g Windows 2003 server Windows XP By: Iain on Mon, 16 June 2008 |
14 |
14770 |
Fri, 30 December 2016 00:51 By: rizuane ![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) |
|
Calculate percentage based on month Oracle 11.2.0.3.0 |
9 |
6595 |
Thu, 29 December 2016 13:56 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |