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
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 990 Sat, 08 April 2017 07:42
By: pointers
  UNION and dependent LOV
Oracle R12
By: umamagi on Fri, 07 April 2017
3 910 Sat, 08 April 2017 03:20
By: Littlefoot
  Pre Insert logic in Trigger
Oracle 11.2.0.3
By: pointers on Wed, 05 April 2017
10 1234 Thu, 06 April 2017 21:09
By: pointers
  Avoid Distinct
Oracle 11g
By: manikandan23 on Wed, 05 April 2017
6 1022 Thu, 06 April 2017 03:33
By: cookiemonster
  package
By: jay12 on Wed, 05 April 2017
3 755 Thu, 06 April 2017 03:30
By: cookiemonster
  Split clob data and store in table
Oracle 11g
By: Roots_ct5 on Tue, 04 April 2017
3 865 Tue, 04 April 2017 10:30
By: Roots_ct5
  Need a help with SQL
Oracle 12C
By: mangeshbhasme on Sun, 02 April 2017
10 1286 Tue, 04 April 2017 06:59
By: EdStevens
  how to send tablespace mail alerts with PL/SQL
By: diomahardhika on Mon, 13 March 2017
24 3037 Tue, 04 April 2017 03:56
By: cookiemonster
  How can I convert a SQL command to MySql
By: vinodkalpaka on Mon, 03 April 2017
24 2889 Tue, 04 April 2017 03:28
By: vinodkalpaka
  Need help with SQL
Oracle 12c
By: jvanh on Fri, 31 March 2017
11 1628 Mon, 03 April 2017 07:05
By: John Watson
  Converting comma separated value in different rows
Oracle 10g R2
By: amarbose on Sun, 02 April 2017
5 909 Mon, 03 April 2017 01:34
By: Michel Cadot
  Can we replace any sub query using join
By: asliyanage on Wed, 22 March 2017
3 856 Sat, 01 April 2017 02:59
By: Michel Cadot
  oracle-dbms-fga-dynamically-create-an-audit-trail-or-policy (3 threads merged by bb)
By: jokrasa on Wed, 22 March 2017
9 1487 Fri, 31 March 2017 11:45
By: Bill B
  Re: ToDate function (split from hijacked thread http://www.orafaq.com/forum/t/56308/ by bb)
By: hyder on Thu, 30 March 2017
2 695 Fri, 31 March 2017 11:41
By: Bill B
  UTL_FILE_DIR
Oracle 10gR2/ Solaris 10
By: reym21 on Wed, 29 March 2017
13 1582 Thu, 30 March 2017 07:22
By: Bill B
  Avoid UNION ALL
Oracle 11.2.0.3
By: pointers on Tue, 28 March 2017
5 1119 Wed, 29 March 2017 08:14
By: pointers
  Grouping for varying weeks
Oracle 11.2.0.3
By: pointers on Mon, 27 March 2017
7 1211 Tue, 28 March 2017 04:13
By: pointers
  Inserting data from multiple table into 1 table
windows
By: Dnmunde on Sun, 26 March 2017
8 1488 Mon, 27 March 2017 00:48
By: Michel Cadot
  Receiving Email Messages through Oracle procedure. ( 1 2)
By: woolmer on Tue, 01 May 2007
68 21473 Sat, 25 March 2017 13:10
By: Littlefoot
  Query performance
SQL
By: Jiggu on Thu, 16 March 2017
19 2916 Fri, 24 March 2017 04:40
By: Bill B
  CURSOR taking more time
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
By: amarjadhav on Fri, 10 March 2017
11 1366 Thu, 23 March 2017 14:30
By: mikek
  Orcale: Missing Group By expression working
Oracle 12, Windows
By: MikeBnDe on Wed, 22 March 2017
5 959 Wed, 22 March 2017 10:56
By: Michel Cadot
  copy table structure
By: asliyanage on Wed, 15 March 2017
17 2741 Wed, 22 March 2017 09:08
By: cookiemonster
  Conditional Join Logic
Oracle 11g
By: rajsinha on Tue, 21 March 2017
3 923 Wed, 22 March 2017 03:35
By: John Watson
  need help in setting constraints for the column based on subquery (2 threads merged by bb)
sql,oracle 11g
By: sowk on Thu, 16 March 2017
13 2177 Tue, 21 March 2017 06:24
By: John Watson
  Append Hint in oracle
By: amit.sonar on Fri, 17 March 2017
10 1518 Mon, 20 March 2017 09:44
By: Solomon Yakobson
  ORA-14028
By: angro123 on Sun, 19 March 2017
5 1401 Mon, 20 March 2017 09:08
By: cookiemonster
  ORDER BY Clause error in cursor
9i, 9.0.1.1, XP
By: billgates on Fri, 17 March 2017
7 1186 Fri, 17 March 2017 16:11
By: BlackSwan
icon14.gif invalid option using INTERVAL( NUMTODSINTERVAL(1, 'DAY'))
oracle db 11.2.0.1.0
By: centaurux on Thu, 16 March 2017
5 1025 Fri, 17 March 2017 13:42
By: Bill B
  query dead slow
ORACLE EBS R12
By: annu-agi on Sat, 11 March 2017
19 2834 Fri, 17 March 2017 11:31
By: Michel Cadot
  function based index on date column
11g, 11.2.0.3.0
By: annu-agi on Fri, 10 March 2017
9 2202 Fri, 17 March 2017 04:48
By: annu-agi
  oracle transaction
By: asliyanage on Wed, 15 March 2017
14 1946 Thu, 16 March 2017 14:04
By: Solomon Yakobson
  ORACLE sql HELP NEEDED
Oracle 11 g
By: abhi2varmaarma on Thu, 16 March 2017
2 756 Thu, 16 March 2017 13:04
By: Michel Cadot
  calling a function as a input parameter for a stored procedure
oracle 11g release 2
By: raj85844 on Tue, 14 March 2017
6 983 Thu, 16 March 2017 07:31
By: Bill B
  dynamically creating index from same table in different schema
11g release 2
By: raj85844 on Tue, 14 March 2017
5 885 Tue, 14 March 2017 12:14
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 3038 Tue, 14 March 2017 05:49
By: asliyanage
  Uploading csv files with different names on periodical basis.
Oracle Enterprise Edition 11g R2
By: Manoj.Gupta.91 on Sat, 11 March 2017
3 769 Mon, 13 March 2017 21:07
By: BlackSwan
  Help me with error Compilation unit analysis terminated (2 threads merged by bb)
window7
By: hosun0919 on Sun, 12 March 2017
3 1045 Mon, 13 March 2017 01:09
By: Michel Cadot
  Query Help
Oracle 12.1.0.2.0
By: SADASIVAM on Sun, 12 March 2017
0 822 Sun, 12 March 2017 00:49
By: SADASIVAM
  UTL_FILE.Put_Line carriage return.
11g R2
By: Manoj.Gupta.91 on Tue, 21 February 2017
6 2265 Sat, 11 March 2017 02:43
By: Manoj.Gupta.91
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 23 05:06:46 CDT 2018