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
  separate string by comma
Oracle 11g
By: mape on Wed, 20 January 2016
4 675 Thu, 21 January 2016 16:28
By: Bill B
  Unable to pass 1st value into the query
Oracle, 11.2.0.4.0, Windows 7 Professional 64 bit
By: buggleboy007 on Tue, 19 January 2016
8 586 Wed, 20 January 2016 22:07
By: buggleboy007
  How To Get JV/34 as JV/0034 or JV/034 as JV/0034 or JV/0034 as JV/0034 using regular expression
By: jainarayan5484 on Wed, 20 January 2016
3 466 Wed, 20 January 2016 09:15
By: Solomon Yakobson
  db link between 10g and 12c
10g 12c
By: mshrkshl on Tue, 19 January 2016
4 722 Wed, 20 January 2016 04:25
By: Littlefoot
  Use cursor output in the IN CLAUSE
11.2.1.0
By: OraFerro on Tue, 19 January 2016
4 483 Tue, 19 January 2016 13:48
By: Barbara Boehmer
  ora-12096
Oracle 11.2.0.4, Windows 2008 R2
By: sant_new1 on Mon, 18 January 2016
22 800 Tue, 19 January 2016 13:32
By: sant_new1
  How do I find a value anywhere in a Oracle schema ?
12c
By: gorants on Mon, 18 January 2016
15 4825 Tue, 19 January 2016 10:08
By: gorants
  VARCHAR2 Convert to H:MI:SS tt (merged 2)
Windows server 2008r2
By: farrukh786 on Mon, 18 January 2016
28 768 Tue, 19 January 2016 03:11
By: Michel Cadot
  CHAR '
ORACLE 6i
By: NNAAEE on Thu, 14 January 2016
11 645 Mon, 18 January 2016 08:38
By: EdStevens
  SQL Query
Oracle 10g
By: swapnil_naik on Mon, 18 January 2016
6 404 Mon, 18 January 2016 04:24
By: Michel Cadot
  ANSI SQL STATEMENTS
By: Danny Freeman on Fri, 15 January 2016
3 713 Sun, 17 January 2016 08:26
By: Solomon Yakobson
  How to use minus, union for CLOB datatype column in Oracle?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: Oracle_Walker on Thu, 14 January 2016
12 1043 Sat, 16 January 2016 06:56
By: Solomon Yakobson
  interview question
oracle 10g
By: san-deep on Fri, 15 January 2016
5 692 Fri, 15 January 2016 12:43
By: pablolee
  Odd case of removing duplicates within a set.
Oracle, 11.2.0.4.0, Windows 7
By: tmcallister on Fri, 08 January 2016
6 771 Thu, 14 January 2016 08:53
By: Solomon Yakobson
  how to write below procedure
By: ram7aj1a0235 on Tue, 12 January 2016
8 696 Wed, 13 January 2016 04:00
By: pablolee
  To Log DBMS in a file from procedure
By: rohit_shinez on Thu, 07 January 2016
9 882 Tue, 12 January 2016 12:00
By: Bill B
  Not able to create the Materialized view
11.2.0.4
By: grpatwari on Mon, 04 January 2016
7 981 Tue, 12 January 2016 01:00
By: Michel Cadot
  Not able to insert with returning option on view with instead of trigger
11g
By: saini006 on Mon, 11 January 2016
3 490 Mon, 11 January 2016 22:33
By: Kevin Meade
  Pull 20 records for each time
Oracle Pl/sql
By: itnagaraj on Mon, 11 January 2016
8 585 Mon, 11 January 2016 08:46
By: cookiemonster
  Generate unique combinations
Oracle 11g
By: Xandot on Fri, 08 January 2016
2 411 Fri, 08 January 2016 08:15
By: Xandot
  Case statement for multiple options
By: blyzz on Thu, 07 January 2016
3 502 Fri, 08 January 2016 02:54
By: cookiemonster
icon8.gif Joining on optional TABLE OF NUMBER parameters
Oracle 11G
By: Sam D. on Mon, 28 December 2015
17 989 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 561 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 485 Wed, 06 January 2016 12:20
By: Michel Cadot
  NVL Function
By: johnsid on Tue, 05 January 2016
3 602 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 986 Wed, 06 January 2016 03:35
By: cookiemonster
  XML parsing error-ORA-06512
oracle 10g
By: gobi21 on Tue, 05 January 2016
4 594 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 616 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 662 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 866 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 409 Thu, 31 December 2015 04:47
By: brown_zzz
  Performance Issue in VARRAY
oracle 11G
By: ramchandru1989 on Wed, 30 December 2015
4 960 Thu, 31 December 2015 03:57
By: John Watson
  Please help - pivot option
oracle 11g, linux
By: lb92 on Wed, 30 December 2015
5 665 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 604 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 1240 Tue, 29 December 2015 07:43
By: EdStevens
  Materialized View
Window 10, 11G
By: Bilal Khan on Mon, 28 December 2015
4 475 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 1208 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 965 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 1122 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 408 Tue, 22 December 2015 21:52
By: Solomon Yakobson
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: Wed Dec 07 06:33:26 CST 2016

Total time taken to generate the page: 0.21695 seconds