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
  How to get the first less date than agiven date in sql
By: blyzz on Tue, 26 January 2016
2 970 Tue, 26 January 2016 12:04
By: Barbara Boehmer
  Corrections with overlapping time frames (SOLVED)
Oracle 11
By: quirks on Wed, 20 January 2016
8 1809 Mon, 25 January 2016 07:04
By: quirks
  help to make sql query
sql
By: deepak416 on Sun, 24 January 2016
3 1203 Sun, 24 January 2016 07:54
By: Solomon Yakobson
  Interval Partitioning and local index
By: menoarc on Sat, 23 January 2016
6 1628 Sun, 24 January 2016 04:47
By: menoarc
  INSERT into a Partition
By: tony_soprano786 on Fri, 22 January 2016
3 1033 Fri, 22 January 2016 09:32
By: Michel Cadot
  separate string by comma
Oracle 11g
By: mape on Wed, 20 January 2016
4 1431 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 1405 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 1070 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 5244 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 1067 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 5077 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 10334 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 4048 Tue, 19 January 2016 03:11
By: Michel Cadot
  CHAR '
ORACLE 6i
By: NNAAEE on Thu, 14 January 2016
11 1959 Mon, 18 January 2016 08:38
By: EdStevens
  SQL Query
Oracle 10g
By: swapnil_naik on Mon, 18 January 2016
6 1138 Mon, 18 January 2016 04:24
By: Michel Cadot
  ANSI SQL STATEMENTS
By: Danny Freeman on Fri, 15 January 2016
3 2173 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 8419 Sat, 16 January 2016 06:56
By: Solomon Yakobson
  interview question
oracle 10g
By: san-deep on Fri, 15 January 2016
5 1495 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 1656 Thu, 14 January 2016 08:53
By: Solomon Yakobson
  how to write below procedure
By: ram7aj1a0235 on Tue, 12 January 2016
8 1707 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 2279 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 4714 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 2396 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 1626 Mon, 11 January 2016 08:46
By: cookiemonster
  Generate unique combinations
Oracle 11g
By: Xandot on Fri, 08 January 2016
2 856 Fri, 08 January 2016 08:15
By: Xandot
  Case statement for multiple options
By: blyzz on Thu, 07 January 2016
3 1211 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 3247 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 2022 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 1309 Wed, 06 January 2016 12:20
By: Michel Cadot
  NVL Function
By: johnsid on Tue, 05 January 2016
3 1330 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 3179 Wed, 06 January 2016 03:35
By: cookiemonster
  XML parsing error-ORA-06512
oracle 10g
By: gobi21 on Tue, 05 January 2016
4 8193 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 2195 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 2521 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 1737 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 911 Thu, 31 December 2015 04:47
By: brown_zzz
  Performance Issue in VARRAY
oracle 11G
By: ramchandru1989 on Wed, 30 December 2015
4 3232 Thu, 31 December 2015 03:57
By: John Watson
  Please help - pivot option
oracle 11g, linux
By: lb92 on Wed, 30 December 2015
5 1573 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 1587 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 2882 Tue, 29 December 2015 07:43
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: Sat Dec 04 03:50:48 CST 2021