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 1155 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 645 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 585 Wed, 06 January 2016 12:20
By: Michel Cadot
  NVL Function
By: johnsid on Tue, 05 January 2016
3 694 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 1125 Wed, 06 January 2016 03:35
By: cookiemonster
  XML parsing error-ORA-06512
oracle 10g
By: gobi21 on Tue, 05 January 2016
4 936 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 703 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 795 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 954 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 465 Thu, 31 December 2015 04:47
By: brown_zzz
  Performance Issue in VARRAY
oracle 11G
By: ramchandru1989 on Wed, 30 December 2015
4 1509 Thu, 31 December 2015 03:57
By: John Watson
  Please help - pivot option
oracle 11g, linux
By: lb92 on Wed, 30 December 2015
5 749 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 720 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 1356 Tue, 29 December 2015 07:43
By: EdStevens
  Materialized View
Window 10, 11G
By: Bilal Khan on Mon, 28 December 2015
4 555 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 1349 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 1097 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 1395 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 502 Tue, 22 December 2015 21:52
By: Solomon Yakobson
  Parameterized One-Time-Only procedure....
By: mokarem on Tue, 15 December 2015
18 1303 Tue, 22 December 2015 17:27
By: Solomon Yakobson
  Help with oracle query to manipulate dates
By: nsk78 on Tue, 22 December 2015
1 545 Tue, 22 December 2015 08:29
By: BlackSwan
  help to correct syntax error
oracle 12c
By: vs140580 on Mon, 21 December 2015
11 665 Mon, 21 December 2015 22:47
By: BlackSwan
  how to checkout tablespace
oracle 11g
By: rahuljadhav177@gmail.com on Mon, 21 December 2015
2 517 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 513 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 1408 Mon, 21 December 2015 01:08
By: flyboy
  Help with how to do
oracle 12c
By: vs140580 on Sun, 20 December 2015
2 414 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 726 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 1566 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 729 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 637 Sun, 20 December 2015 00:55
By: vs140580
  find missing record
ORACLE 10G
By: nmd_group on Sat, 19 December 2015
10 878 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 773 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 660 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 1355 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 452 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 533 Thu, 17 December 2015 06:37
By: JNagtzaam
  Date Conersion From UTC to EST
Oracle10g
By: ssyr22 on Thu, 17 December 2015
8 647 Thu, 17 December 2015 06:26
By: EdStevens
  Date conversion
By: blyzz on Wed, 16 December 2015
2 544 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 1436 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 1256 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: Sun Jun 25 03:58:47 CDT 2017

Total time taken to generate the page: 0.13924 seconds