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
  Partition tablespace name does not change after moving subpartition
oracle12c
By: shrinika on Sat, 15 April 2017
2 1458 Sat, 15 April 2017 12:59
By: shrinika
  cursors
windows
By: jay12 on Tue, 04 April 2017
3 1095 Fri, 14 April 2017 15:49
By: Bill B
  testing rollback
12.1.0.1
By: jinga on Fri, 07 April 2017
2 1099 Tue, 11 April 2017 12:56
By: Bill B
  Hierarchical Queries
Oracle 11.2.0.3
By: pointers on Thu, 06 April 2017
2 1495 Sat, 08 April 2017 07:42
By: pointers
  UNION and dependent LOV
Oracle R12
By: umamagi on Fri, 07 April 2017
3 1573 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 1896 Thu, 06 April 2017 21:09
By: pointers
  Avoid Distinct
Oracle 11g
By: manikandan23 on Wed, 05 April 2017
6 1881 Thu, 06 April 2017 03:33
By: cookiemonster
  package
By: jay12 on Wed, 05 April 2017
3 1336 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 1405 Tue, 04 April 2017 10:30
By: Roots_ct5
  Need a help with SQL
Oracle 12C
By: mangeshbhasme on Sun, 02 April 2017
10 2166 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 6969 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 5971 Tue, 04 April 2017 03:28
By: vinodkalpaka
  Need help with SQL
Oracle 12c
By: jvanh on Fri, 31 March 2017
11 3200 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 1487 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 1178 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 2525 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 1096 Fri, 31 March 2017 11:41
By: Bill B
  UTL_FILE_DIR
Oracle 10gR2/ Solaris 10
By: reym21 on Wed, 29 March 2017
13 2665 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 1554 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 1701 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 2941 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 31783 Sat, 25 March 2017 13:10
By: Littlefoot
  Query performance
SQL
By: Jiggu on Thu, 16 March 2017
19 6302 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 2012 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 1552 Wed, 22 March 2017 10:56
By: Michel Cadot
  copy table structure
By: asliyanage on Wed, 15 March 2017
17 6302 Wed, 22 March 2017 09:08
By: cookiemonster
  Conditional Join Logic
Oracle 11g
By: rajsinha on Tue, 21 March 2017
3 2100 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 4110 Tue, 21 March 2017 06:24
By: John Watson
  Append Hint in oracle
By: amit.sonar on Fri, 17 March 2017
10 2288 Mon, 20 March 2017 09:44
By: Solomon Yakobson
  ORA-14028
By: angro123 on Sun, 19 March 2017
5 2222 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 1918 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 1695 Fri, 17 March 2017 13:42
By: Bill B
  query dead slow
ORACLE EBS R12
By: annu-agi on Sat, 11 March 2017
19 6370 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 4119 Fri, 17 March 2017 04:48
By: annu-agi
  oracle transaction
By: asliyanage on Wed, 15 March 2017
14 4304 Thu, 16 March 2017 14:04
By: Solomon Yakobson
  ORACLE sql HELP NEEDED
Oracle 11 g
By: abhi2varmaarma on Thu, 16 March 2017
2 1213 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 1580 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 1223 Tue, 14 March 2017 12:14
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 5352 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 1229 Mon, 13 March 2017 21:07
By: BlackSwan
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 Oct 16 04:40:47 CDT 2019