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
  Variables
sql
By: M123 on Thu, 04 February 2016
4 437 Thu, 04 February 2016 19:17
By: M123
  change permanently the value of the initialization parameter
Oracle
By: Nagaram on Thu, 04 February 2016
4 2242 Thu, 04 February 2016 16:30
By: Barbara Boehmer
  Comma separated column values matching
10.0.0.1
By: pratik4891 on Thu, 04 February 2016
20 830 Thu, 04 February 2016 16:25
By: Barbara Boehmer
  How to use DISTINCT for CLOB data type?
Oracle 11g
By: Oracle_Walker on Thu, 28 January 2016
4 1094 Thu, 04 February 2016 10:34
By: Oracle_Walker
  Updating duplicate records with different data
Oracle 11g
By: bhush5bhai on Mon, 01 February 2016
8 3752 Tue, 02 February 2016 11:11
By: Solomon Yakobson
  Missing Day data
Oracle SQl
By: razasheikh on Mon, 01 February 2016
6 2763 Tue, 02 February 2016 04:18
By: Michel Cadot
  Regarding row lock
oracle 12c
By: gorants on Tue, 26 January 2016
21 1543 Sun, 31 January 2016 19:21
By: gorants
icon5.gif UTL_FILE Writeing in multiple text files
Oracle SQL Developer
By: thsankar on Tue, 26 January 2016
21 938 Fri, 29 January 2016 21:49
By: thsankar
  How can I pass UserId/Password securely as a parameter using UTL_HTTP
Oracle 11G Enterprise 11.2.0.4.0 - 64bit
By: kjcook on Tue, 26 January 2016
10 782 Fri, 29 January 2016 16:04
By: Bill B
icon5.gif How to capture particular column from select statement inside a package body in oracle pl sql
oracle pl sql
By: adfire on Fri, 15 January 2016
13 1086 Wed, 27 January 2016 16:16
By: Barbara Boehmer
  Determine Missing Route_Seq Numbers
Oracle 11g
By: stun66 on Tue, 26 January 2016
5 1130 Wed, 27 January 2016 05:55
By: Solomon Yakobson
  SQL QUERY HELP
By: arifs3738 on Wed, 27 January 2016
2 1002 Wed, 27 January 2016 03:24
By: John Watson
  How to get the first less date than agiven date in sql
By: blyzz on Tue, 26 January 2016
2 348 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 808 Mon, 25 January 2016 07:04
By: quirks
  help to make sql query
sql
By: deepak416 on Sun, 24 January 2016
3 633 Sun, 24 January 2016 07:54
By: Solomon Yakobson
  Interval Partitioning and local index
By: menoarc on Sat, 23 January 2016
6 494 Sun, 24 January 2016 04:47
By: menoarc
  INSERT into a Partition
By: tony_soprano786 on Fri, 22 January 2016
3 449 Fri, 22 January 2016 09:32
By: Michel Cadot
  separate string by comma
Oracle 11g
By: mape on Wed, 20 January 2016
4 638 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 554 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 436 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 564 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 449 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 746 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 4737 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 732 Tue, 19 January 2016 03:11
By: Michel Cadot
  CHAR '
ORACLE 6i
By: NNAAEE on Thu, 14 January 2016
11 599 Mon, 18 January 2016 08:38
By: EdStevens
  SQL Query
Oracle 10g
By: swapnil_naik on Mon, 18 January 2016
6 386 Mon, 18 January 2016 04:24
By: Michel Cadot
  ANSI SQL STATEMENTS
By: Danny Freeman on Fri, 15 January 2016
3 652 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 951 Sat, 16 January 2016 06:56
By: Solomon Yakobson
  interview question
oracle 10g
By: san-deep on Fri, 15 January 2016
5 645 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 724 Thu, 14 January 2016 08:53
By: Solomon Yakobson
  how to write below procedure
By: ram7aj1a0235 on Tue, 12 January 2016
8 664 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 827 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 807 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 454 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 550 Mon, 11 January 2016 08:46
By: cookiemonster
  calculate working days not beween date ( 1 2)
By: shahzad-ul-hasan on Tue, 10 November 2015
67 2524 Fri, 08 January 2016 09:43
By: BlackSwan
  Generate unique combinations
Oracle 11g
By: Xandot on Fri, 08 January 2016
2 381 Fri, 08 January 2016 08:15
By: Xandot
  Case statement for multiple options
By: blyzz on Thu, 07 January 2016
3 466 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 927 Thu, 07 January 2016 13:21
By: Sam D.
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 Sep 25 00:46:14 CDT 2016

Total time taken to generate the page: 0.20305 seconds