Home » SQL & PL/SQL » SQL & PL/SQL
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
icon8.gif Joining on optional TABLE OF NUMBER parameters
Oracle 11G
By: Sam D. on Mon, 28 December 2015
17 1019 Thu, 07 January 2016 13:21
By: Sam D.
  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 580 Thu, 07 January 2016 08:13
By: cookiemonster
  repeat the previous value to next rows
oracle 11g
By: guddu_12 on Wed, 06 January 2016
1 514 Wed, 06 January 2016 12:20
By: Michel Cadot
  NVL Function
By: johnsid on Tue, 05 January 2016
3 634 Wed, 06 January 2016 07:23
By: javon13
  Query is not running from 11.2.0.3 to 11.2.0.4
11.2.0.4
By: grpatwari on Mon, 04 January 2016
18 1022 Wed, 06 January 2016 03:35
By: cookiemonster
  XML parsing error-ORA-06512
oracle 10g
By: gobi21 on Tue, 05 January 2016
4 660 Tue, 05 January 2016 21:50
By: gobi21
  Collections- Associative arrays
Oracle, 11.2.0.4.0, Windows 7 Professional
By: buggleboy007 on Sun, 03 January 2016
14 638 Mon, 04 January 2016 09:49
By: Michel Cadot
  Getting ORA-01839: date not valid for month specified
Oracle 11g
By: shuklajayb4 on Thu, 31 December 2015
5 704 Mon, 04 January 2016 03:00
By: cookiemonster
  Help me on Syntax of PL/SQL
PL/SQL using UNIX scripts
By: royal4111 on Thu, 24 December 2015
6 877 Thu, 31 December 2015 21:59
By: royal4111
  Can't create a Materialised view
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: brown_zzz on Thu, 31 December 2015
2 421 Thu, 31 December 2015 04:47
By: brown_zzz
  Performance Issue in VARRAY
oracle 11G
By: ramchandru1989 on Wed, 30 December 2015
4 1049 Thu, 31 December 2015 03:57
By: John Watson
  Please help - pivot option
oracle 11g, linux
By: lb92 on Wed, 30 December 2015
5 680 Wed, 30 December 2015 11:46
By: lb92
  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 634 Tue, 29 December 2015 08:35
By: Bill B
icon4.gif Can we Write PLSQL concept in WITH clause
oracle 11g
By: graphe on Fri, 27 November 2015
14 1267 Tue, 29 December 2015 07:43
By: EdStevens
  Materialized View
Window 10, 11G
By: Bilal Khan on Mon, 28 December 2015
4 488 Mon, 28 December 2015 04:01
By: John Watson
  Start DB session using sh script with out the password
10g Release 2
By: arunprakash647 on Wed, 25 September 2013
7 1241 Fri, 25 December 2015 06:18
By: Michel Cadot
  how to fetch deleted row
oracle 11g
By: rahuljadhav177@gmail.com on Tue, 22 December 2015
15 998 Thu, 24 December 2015 05:24
By: cookiemonster
  Generate GUID other than sys_GUID() (merged 3)
Oracle 12c
By: fabi88 on Tue, 22 December 2015
27 1184 Wed, 23 December 2015 23:15
By: fabi88
  TO_NUMBER Doesn't Support These Elements: RN, rn, TM, and V ?
Oracle Database 11g, Unix
By: kittokevin on Tue, 22 December 2015
2 432 Tue, 22 December 2015 21:52
By: Solomon Yakobson
  Parameterized One-Time-Only procedure....
By: mokarem on Tue, 15 December 2015
18 1184 Tue, 22 December 2015 17:27
By: Solomon Yakobson
  Help with oracle query to manipulate dates
By: nsk78 on Tue, 22 December 2015
1 489 Tue, 22 December 2015 08:29
By: BlackSwan
  help to correct syntax error
oracle 12c
By: vs140580 on Mon, 21 December 2015
11 589 Mon, 21 December 2015 22:47
By: BlackSwan
  how to checkout tablespace
oracle 11g
By: rahuljadhav177@gmail.com on Mon, 21 December 2015
2 487 Mon, 21 December 2015 07:35
By: Michel Cadot
  help with syntax error kind help
oracle 12c
By: vs140580 on Mon, 21 December 2015
1 463 Mon, 21 December 2015 01:38
By: vs140580
  help to correct syntax error
oracle 12c ( 1 2)
By: vs140580 on Thu, 17 December 2015
40 1339 Mon, 21 December 2015 01:08
By: flyboy
  Help with how to do
oracle 12c
By: vs140580 on Sun, 20 December 2015
2 377 Sun, 20 December 2015 22:08
By: vs140580
  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 670 Sun, 20 December 2015 15:46
By: BlackSwan
  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 1207 Sun, 20 December 2015 13:42
By: Duane
  How to fetch data from multiple table based on a input date
Oracle 11g
By: suvijyo on Sat, 19 December 2015
3 669 Sun, 20 December 2015 05:10
By: Littlefoot
  Kind help with a pl sql for the below link I had posted
oracle 12c
By: vs140580 on Sun, 20 December 2015
0 603 Sun, 20 December 2015 00:55
By: vs140580
  find missing record
ORACLE 10G
By: nmd_group on Sat, 19 December 2015
10 808 Sat, 19 December 2015 10:01
By: Michel Cadot
  Same SQL work differently in different SQL Plus
Oracle 11g
By: jayakumar.u05 on Fri, 18 December 2015
10 699 Fri, 18 December 2015 16:03
By: BlackSwan
  dynamic Column header using Pivot operator
Oracle12c
By: ajamitjain129@gmail.com on Thu, 17 December 2015
3 575 Fri, 18 December 2015 05:20
By: ajamitjain129@gmail.com
  Converting Excel to csv using PL/SQL
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: venkat_bollu on Thu, 17 December 2015
4 1048 Fri, 18 December 2015 02:03
By: venkat_bollu
  Staff Lft Company and display his pervisos recoreds
By: skorpion on Thu, 17 December 2015
1 407 Thu, 17 December 2015 08:01
By: BlackSwan
  A trigger to give a 10 per cent discount to a regular customer
By: ora1992 on Thu, 17 December 2015
4 486 Thu, 17 December 2015 06:37
By: JNagtzaam
  Date Conersion From UTC to EST
Oracle10g
By: ssyr22 on Thu, 17 December 2015
8 579 Thu, 17 December 2015 06:26
By: EdStevens
  Date conversion
By: blyzz on Wed, 16 December 2015
2 482 Wed, 16 December 2015 10:00
By: Solomon Yakobson
  PL SQL Code with variable
Oracle 10 G
By: mashrima on Wed, 16 December 2015
13 1345 Wed, 16 December 2015 09:26
By: flyboy
  Define/declare dates and use in CTE
SQL Developer 4.1.2
By: To-Dai on Mon, 14 December 2015
30 1157 Wed, 16 December 2015 06:22
By: EdStevens
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Tue Jan 17 18:12:27 CST 2017

Total time taken to generate the page: 0.16447 seconds