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
  Collections- Associative arrays
Oracle, 11.2.0.4.0, Windows 7 Professional
By: buggleboy007 on Sun, 03 January 2016
14 477 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 486 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 718 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 331 Thu, 31 December 2015 04:47
By: brown_zzz
  Performance Issue in VARRAY
oracle 11G
By: ramchandru1989 on Wed, 30 December 2015
4 451 Thu, 31 December 2015 03:57
By: John Watson
  Please help - pivot option
oracle 11g, linux
By: lb92 on Wed, 30 December 2015
5 534 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 458 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 1087 Tue, 29 December 2015 07:43
By: EdStevens
  Materialized View
Window 10, 11G
By: Bilal Khan on Mon, 28 December 2015
4 361 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 1019 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 778 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 840 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 294 Tue, 22 December 2015 21:52
By: Solomon Yakobson
  Parameterized One-Time-Only procedure....
By: mokarem on Tue, 15 December 2015
18 941 Tue, 22 December 2015 17:27
By: Solomon Yakobson
  Help with oracle query to manipulate dates
By: nsk78 on Tue, 22 December 2015
1 359 Tue, 22 December 2015 08:29
By: BlackSwan
  help to correct syntax error
oracle 12c
By: vs140580 on Mon, 21 December 2015
11 411 Mon, 21 December 2015 22:47
By: BlackSwan
  how to checkout tablespace
oracle 11g
By: rahuljadhav177@gmail.com on Mon, 21 December 2015
2 384 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 335 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 1173 Mon, 21 December 2015 01:08
By: flyboy
  Help with how to do
oracle 12c
By: vs140580 on Sun, 20 December 2015
2 271 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 532 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 656 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 524 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 498 Sun, 20 December 2015 00:55
By: vs140580
  find missing record
ORACLE 10G
By: nmd_group on Sat, 19 December 2015
10 606 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 488 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 431 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 478 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 289 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 335 Thu, 17 December 2015 06:37
By: JNagtzaam
  Date Conersion From UTC to EST
Oracle10g
By: ssyr22 on Thu, 17 December 2015
8 415 Thu, 17 December 2015 06:26
By: EdStevens
  Date conversion
By: blyzz on Wed, 16 December 2015
2 396 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 1172 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 944 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 1322 Wed, 16 December 2015 02:28
By: vs140580
  how to remove more than one value
Oracle10g
By: ssyr22 on Mon, 14 December 2015
12 650 Tue, 15 December 2015 03:36
By: JNagtzaam
  Materialised view won't refresh
Oracle 10.2.0.4.0
By: brown_zzz on Mon, 14 December 2015
7 529 Tue, 15 December 2015 03:32
By: cookiemonster
  How to Resolve error: ORA-00932
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Sun, 13 December 2015
10 723 Mon, 14 December 2015 05:40
By: msol25
  + 0 in the where clause
PL/SQL Release 12.1.0.2.0 - Production
By: msinha8 on Thu, 10 December 2015
8 875 Fri, 11 December 2015 01:25
By: Michel Cadot
  Join on TABLE OF NUMBER passed as a parameter to a function
Oracle 11G
By: Sam D. on Wed, 09 December 2015
11 727 Thu, 10 December 2015 13:15
By: Michel Cadot
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: Fri Apr 29 07:43:28 CDT 2016

Total time taken to generate the page: 0.23501 seconds