|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
Joining on optional TABLE OF NUMBER parameters Oracle 11G By: Sam D. on Mon, 28 December 2015 |
17 |
4019 |
Thu, 07 January 2016 13:21 By: Sam D. ![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) |
|
Interesting problem with query Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: javon13 on Wed, 06 January 2016 |
10 |
2680 |
Thu, 07 January 2016 08:13 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) |
|
repeat the previous value to next rows oracle 11g |
1 |
1678 |
Wed, 06 January 2016 12: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) |
|
NVL Function By: johnsid on Tue, 05 January 2016 |
3 |
1761 |
Wed, 06 January 2016 07:23 By: javon13 ![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 is not running from 11.2.0.3 to 11.2.0.4 11.2.0.4 |
18 |
4662 |
Wed, 06 January 2016 03:35 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) |
|
XML parsing error-ORA-06512 oracle 10g By: gobi21 on Tue, 05 January 2016 |
4 |
10439 |
Tue, 05 January 2016 21:50 By: gobi21 ![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- Associative arrays Oracle, 11.2.0.4.0, Windows 7 Professional |
14 |
2816 |
Mon, 04 January 2016 09: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) |
|
Getting ORA-01839: date not valid for month specified Oracle 11g |
5 |
4055 |
Mon, 04 January 2016 03:00 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) |
|
Help me on Syntax of PL/SQL PL/SQL using UNIX scripts |
6 |
2144 |
Thu, 31 December 2015 21:59 By: royal4111 ![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) |
|
Can't create a Materialised view Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi |
2 |
1278 |
Thu, 31 December 2015 04:47 By: brown_zzz ![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) |
|
Performance Issue in VARRAY oracle 11G |
4 |
3702 |
Thu, 31 December 2015 03:57 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) |
|
Please help - pivot option oracle 11g, linux By: lb92 on Wed, 30 December 2015 |
5 |
1960 |
Wed, 30 December 2015 11:46 By: lb92 ![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) |
|
Please help for resolving issue for UTL_FILE Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Mon, 28 December 2015 |
7 |
2035 |
Tue, 29 December 2015 08:35 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Can we Write PLSQL concept in WITH clause oracle 11g By: graphe on Fri, 27 November 2015 |
14 |
3581 |
Tue, 29 December 2015 07:43 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) |
|
Materialized View Window 10, 11G |
4 |
2340 |
Mon, 28 December 2015 04:01 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) |
|
Start DB session using sh script with out the password 10g Release 2 |
7 |
4054 |
Fri, 25 December 2015 06:18 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 fetch deleted row oracle 11g |
15 |
2985 |
Thu, 24 December 2015 05: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) |
|
Generate GUID other than sys_GUID() (merged 3) Oracle 12c By: fabi88 on Tue, 22 December 2015 |
27 |
7639 |
Wed, 23 December 2015 23:15 By: fabi88 ![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) |
|
TO_NUMBER Doesn't Support These Elements: RN, rn, TM, and V ? Oracle Database 11g, Unix |
2 |
2133 |
Tue, 22 December 2015 21: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) |
|
Parameterized One-Time-Only procedure.... By: mokarem on Tue, 15 December 2015 |
18 |
3668 |
Tue, 22 December 2015 17:27 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) |
|
Help with oracle query to manipulate dates By: nsk78 on Tue, 22 December 2015 |
1 |
1571 |
Tue, 22 December 2015 08:29 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) |
|
help to correct syntax error oracle 12c |
11 |
2392 |
Mon, 21 December 2015 22: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 checkout tablespace oracle 11g |
2 |
1233 |
Mon, 21 December 2015 07:35 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) |
|
help with syntax error kind help oracle 12c |
1 |
1335 |
Mon, 21 December 2015 01:38 By: vs140580 ![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 correct syntax error oracle 12c ( 1 2) |
40 |
4267 |
Mon, 21 December 2015 01:08 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) |
|
Help with how to do oracle 12c |
2 |
1099 |
Sun, 20 December 2015 22:08 By: vs140580 ![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) |
|
Please help for Resolving issue with utl_file Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit By: msol25 on Sun, 20 December 2015 |
25 |
3146 |
Sun, 20 December 2015 15:46 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) |
|
dbms_ldap.simple_bind_s doesn't work with PW containing "!" Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 By: Duane on Fri, 18 December 2015 |
7 |
7338 |
Sun, 20 December 2015 13:42 By: Duane ![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 fetch data from multiple table based on a input date Oracle 11g By: suvijyo on Sat, 19 December 2015 |
3 |
1675 |
Sun, 20 December 2015 05:10 By: Littlefoot ![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) |
|
Kind help with a pl sql for the below link I had posted oracle 12c |
0 |
1411 |
Sun, 20 December 2015 00:55 By: vs140580 ![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) |
|
find missing record ORACLE 10G |
10 |
2205 |
Sat, 19 December 2015 10:01 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) |
|
Same SQL work differently in different SQL Plus Oracle 11g |
10 |
2971 |
Fri, 18 December 2015 16:03 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) |
|
dynamic Column header using Pivot operator Oracle12c |
3 |
2081 |
Fri, 18 December 2015 05:20 By: ajamitjain129@gmail.com ![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) |
|
Converting Excel to csv using PL/SQL Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production |
4 |
6577 |
Fri, 18 December 2015 02:03 By: venkat_bollu ![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) |
|
Staff Lft Company and display his pervisos recoreds |
1 |
1357 |
Thu, 17 December 2015 08:01 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) |
|
A trigger to give a 10 per cent discount to a regular customer By: ora1992 on Thu, 17 December 2015 |
4 |
1771 |
Thu, 17 December 2015 06:37 By: JNagtzaam ![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) |
|
Date Conersion From UTC to EST Oracle10g By: ssyr22 on Thu, 17 December 2015 |
8 |
2252 |
Thu, 17 December 2015 06:26 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) |
|
Date conversion By: blyzz on Wed, 16 December 2015 |
2 |
2266 |
Wed, 16 December 2015 10:00 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) |
|
PL SQL Code with variable Oracle 10 G |
13 |
3451 |
Wed, 16 December 2015 09:26 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) |
|
Define/declare dates and use in CTE SQL Developer 4.1.2 By: To-Dai on Mon, 14 December 2015 |
30 |
4106 |
Wed, 16 December 2015 06:22 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |