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
  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 532 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 452 Wed, 06 January 2016 12:20
By: Michel Cadot
  NVL Function
By: johnsid on Tue, 05 January 2016
3 560 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 920 Wed, 06 January 2016 03:35
By: cookiemonster
  XML parsing error-ORA-06512
oracle 10g
By: gobi21 on Tue, 05 January 2016
4 513 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 578 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 606 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 830 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 387 Thu, 31 December 2015 04:47
By: brown_zzz
  Performance Issue in VARRAY
oracle 11G
By: ramchandru1989 on Wed, 30 December 2015
4 804 Thu, 31 December 2015 03:57
By: John Watson
  Please help - pivot option
oracle 11g, linux
By: lb92 on Wed, 30 December 2015
5 633 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 564 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 1195 Tue, 29 December 2015 07:43
By: EdStevens
  Materialized View
Window 10, 11G
By: Bilal Khan on Mon, 28 December 2015
4 445 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 1148 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 911 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 1025 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 381 Tue, 22 December 2015 21:52
By: Solomon Yakobson
  Parameterized One-Time-Only procedure....
By: mokarem on Tue, 15 December 2015
18 1090 Tue, 22 December 2015 17:27
By: Solomon Yakobson
  Help with oracle query to manipulate dates
By: nsk78 on Tue, 22 December 2015
1 446 Tue, 22 December 2015 08:29
By: BlackSwan
  help to correct syntax error
oracle 12c
By: vs140580 on Mon, 21 December 2015
11 519 Mon, 21 December 2015 22:47
By: BlackSwan
  how to checkout tablespace
oracle 11g
By: rahuljadhav177@gmail.com on Mon, 21 December 2015
2 452 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 420 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 1274 Mon, 21 December 2015 01:08
By: flyboy
  Help with how to do
oracle 12c
By: vs140580 on Sun, 20 December 2015
2 341 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 619 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 981 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 628 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 569 Sun, 20 December 2015 00:55
By: vs140580
  find missing record
ORACLE 10G
By: nmd_group on Sat, 19 December 2015
10 726 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 614 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 522 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 786 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 365 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 439 Thu, 17 December 2015 06:37
By: JNagtzaam
  Date Conersion From UTC to EST
Oracle10g
By: ssyr22 on Thu, 17 December 2015
8 508 Thu, 17 December 2015 06:26
By: EdStevens
  Date conversion
By: blyzz on Wed, 16 December 2015
2 453 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 1276 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 1069 Wed, 16 December 2015 06:22
By: EdStevens
  Help any one with a code please
oracle 12c ( 1 2)
By: vs140580 on Mon, 14 December 2015
47 1448 Wed, 16 December 2015 02:28
By: vs140580
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: Sat Sep 24 21:15:30 CDT 2016

Total time taken to generate the page: 0.10220 seconds