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
  select statement to split string as per the content and show it
oracle 11g, windows
By: chinmay89 on Wed, 31 August 2016
5 743 Mon, 05 September 2016 04:20
By: sandeep_orafaq
  Hierarchy view
Oracle Database 12c Standard Edition Release 12.1.0.2.0
By: steveshephard87 on Sat, 03 September 2016
2 698 Sat, 03 September 2016 17:52
By: Barbara Boehmer
  Mail Notification
By: udaykuditipudi on Fri, 02 September 2016
4 800 Fri, 02 September 2016 07:22
By: EdStevens
  Query to find special alphabets
Oracle 11g Release 2, Linux
By: anil_mk on Wed, 31 August 2016
5 785 Thu, 01 September 2016 06:33
By: Michel Cadot
  QUERY HELP
ORACLE 11G
By: DivP on Wed, 31 August 2016
4 633 Wed, 31 August 2016 15:16
By: DivP
  finding previous quarter end date
By: lappi on Tue, 30 August 2016
13 1260 Wed, 31 August 2016 08:22
By: Michel Cadot
  Help required in SQL Analytic Funciton
Oracle 11g 11.2.0.1.0
By: jimit_shaili on Wed, 31 August 2016
2 564 Wed, 31 August 2016 06:55
By: Michel Cadot
  Insert data into SYSTEM partitioned table using DB link
Oracle 11g Release 2, Linux
By: anil_mk on Tue, 30 August 2016
4 683 Wed, 31 August 2016 05:34
By: anil_mk
  query to write rows to column values
11.2.0.4
By: grpatwari on Tue, 31 May 2016
13 1017 Mon, 29 August 2016 23:00
By: grpatwari
  Selective count with a condition
Oracle SQL 11G
By: vickytalware on Thu, 25 August 2016
8 11063 Fri, 26 August 2016 23:25
By: vickytalware
  How to identify the partition type
Oracle 11
By: saipradyumn on Tue, 23 August 2016
5 888 Fri, 26 August 2016 02:46
By: saipradyumn
  Minus Minutes
11g
By: glmjoy on Fri, 26 August 2016
9 768 Fri, 26 August 2016 02:43
By: glmjoy
  Script Help
SQL Developer
By: kolpalamayaw on Tue, 16 August 2016
4 705 Thu, 25 August 2016 09:40
By: ALEXWE
  how to restrict set of data in oracle
oracle,12.1.0.2.0 ,windows7
By: saini006 on Thu, 25 August 2016
3 589 Thu, 25 August 2016 07:51
By: Michel Cadot
  Query to get Middle Record from a table
Oracle 11g
By: arifs3738 on Wed, 24 August 2016
8 1064 Thu, 25 August 2016 06:37
By: EdStevens
icon5.gif Union of 4 different columns in Single Row
SQL, PLSQL
By: anil_apps on Wed, 24 August 2016
4 682 Thu, 25 August 2016 00:44
By: Michel Cadot
  Sequence partition clause
DB12.x (and possibly earlier)
By: John Watson on Tue, 23 August 2016
2 978 Tue, 23 August 2016 03:15
By: John Watson
  Need to correlate and reconcile two data sets with different number of records
Oracle Database, 10g Rel.2 , Windows Server 2012
By: mazam on Mon, 22 August 2016
1 633 Mon, 22 August 2016 13:54
By: Barbara Boehmer
  How to remove duplicate value from type in SQL
Oracle 11i,Toad
By: victoryhendry on Tue, 16 August 2016
6 1241 Mon, 22 August 2016 04:51
By: sandeep_orafaq
  connect by prior help
11G
By: sanjuchand on Sat, 20 August 2016
4 1031 Sun, 21 August 2016 11:00
By: sanjuchand
  Dropping tables in a stored procedure
119
By: simonrlee22 on Fri, 19 August 2016
8 1035 Fri, 19 August 2016 14:28
By: BlackSwan
  Dynamic SQL Learning
11g
By: Irish88 on Wed, 10 August 2016
7 893 Thu, 18 August 2016 12:10
By: Irish88
  ORA-01917 ERROR
By: mfahimaamirgmailcom on Thu, 18 August 2016
2 685 Thu, 18 August 2016 06:11
By: Michel Cadot
  How to get a value that has never been updated
Oracle Database:11.2.0.1.0; TOAD: 12.1, O/S: Windows 7 Professional 64 bit
By: buggleboy007 on Wed, 17 August 2016
2 1067 Wed, 17 August 2016 21:33
By: buggleboy007
  previous data
oracle 11gr2
By: guddu_12 on Wed, 17 August 2016
7 710 Wed, 17 August 2016 14:04
By: Michel Cadot
  Renaming a table
Oracle 11
By: saipradyumn on Tue, 16 August 2016
6 763 Wed, 17 August 2016 07:28
By: Bill B
  PL/SQL: ORA-00942: table or view does not exist
Oracle 11g, 11.2.0.3.0
By: wtolentino on Tue, 16 August 2016
3 928 Wed, 17 August 2016 06:45
By: wtolentino
  Find unique and sorted field value
By: amarbose on Tue, 16 August 2016
10 915 Wed, 17 August 2016 06:28
By: Michel Cadot
  keep only numeric values in a string
oracle 11g, windows
By: chinmay45 on Tue, 16 August 2016
18 1041 Wed, 17 August 2016 01:35
By: Michel Cadot
  PLS-00231:
By: desmond30 on Mon, 15 August 2016
7 1127 Tue, 16 August 2016 08:08
By: Michel Cadot
  Update or create function paramater
Oracle Database 10g Enterprise Edition ,10.2.0.4.0, linux64_86
By: abdo2203 on Sat, 13 August 2016
5 837 Sat, 13 August 2016 09:36
By: abdo2203
  Help reverse engineering pl sql query
Oracle sql
By: jprisk on Fri, 12 August 2016
4 822 Fri, 12 August 2016 15:03
By: Barbara Boehmer
  Repeat data based on count column
Oracle 11g Release 2, Linux
By: anil_mk on Thu, 11 August 2016
5 687 Fri, 12 August 2016 07:23
By: anil_mk
  Dynamic Update statement Error
Oracle 9i
By: cvs_1984 on Thu, 11 August 2016
2 594 Thu, 11 August 2016 05:31
By: cvs_1984
  Query help
Oracle 12.1.0.2.0, Linux
By: sspn2010 on Mon, 08 August 2016
6 780 Tue, 09 August 2016 16:21
By: sspn2010
  Check if value EXISTS in plsql table of record type
11G
By: harshadsp on Wed, 03 August 2016
11 1768 Mon, 08 August 2016 05:57
By: harshadsp
  SQL connectivity test
oracle, 11g, AIX
By: Prathikesh on Sat, 06 August 2016
24 1290 Mon, 08 August 2016 02:50
By: cookiemonster
  UTL_DBWS error: ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist
Oracle DB, 10g R2, Windows Server 2008R2
By: mdsirajoddin on Sat, 06 August 2016
12 3069 Sat, 06 August 2016 10:38
By: Michel Cadot
  Sum from part of coloumn
Oracle,11g Release 11.2.0.4.0, Solaris 11
By: nms123 on Fri, 05 August 2016
2 587 Fri, 05 August 2016 09:47
By: nms123
  Help using regexp_substr - Urgent Help needed
Oracle 11
By: Member2014 on Thu, 04 August 2016
8 884 Fri, 05 August 2016 08:41
By: Member2014
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 May 23 06:17:47 CDT 2018