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
  dynamically creating index from same table in different schema
11g release 2
By: raj85844 on Tue, 14 March 2017
5 2421 Tue, 14 March 2017 12:14
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 8395 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 2123 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 6601 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 2068 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 9042 Sat, 11 March 2017 02:43
By: Manoj.Gupta.91
  Assistance in Query Construction
Oracle 10g, 11g
By: ORA2015 on Thu, 09 March 2017
11 4924 Fri, 10 March 2017 10:55
By: ORA2015
  Cant get rid of ORA-14155 after all googling (2 threads merged by bb)
9i, 9.0.1.1, XP
By: billgates on Fri, 10 March 2017
11 6879 Fri, 10 March 2017 10:48
By: Michel Cadot
  FOR UPDATE NOWAIT and ORA-29285: file write error
Oracle 11g
By: Prabhu Hooli on Sat, 04 March 2017
7 3603 Fri, 10 March 2017 08:16
By: BlackSwan
  How do I total each column of data with multiple queries?
Oracle 12.1, Version 3.2.20.09
By: Dallas Graves on Mon, 06 March 2017
8 3329 Thu, 09 March 2017 07:16
By: Bill B
  which is best to locate row in oracle table
By: asliyanage on Wed, 08 March 2017
15 5404 Thu, 09 March 2017 07:11
By: Bill B
  Exchange Partition
Oracle 11g
By: saipradyumn on Wed, 08 March 2017
2 3151 Wed, 08 March 2017 01:43
By: saipradyumn
  Enable novalidate constraint
Oracle 11g
By: ORAGENASHOK on Mon, 06 March 2017
7 4086 Tue, 07 March 2017 03:27
By: Roachcoach
  How to split col into two columns according to data types
By: ssyr on Mon, 06 March 2017
21 5847 Tue, 07 March 2017 03:02
By: cookiemonster
  Date closest to event date
By: ertweety on Mon, 06 March 2017
5 2831 Mon, 06 March 2017 20:44
By: ertweety
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 2387 Mon, 06 March 2017 09:46
By: cookiemonster
  Delays between two dates excluding holidays/weekends
Oracle 11.2.0.3
By: pointers on Thu, 02 March 2017
3 2541 Mon, 06 March 2017 02:58
By: cookiemonster
  why cbo select FULL TABLE SCAN
By: meganmegan on Thu, 02 March 2017
14 5270 Sun, 05 March 2017 04:57
By: meganmegan
  Bitmap index for nullable timestamp column ?
Oracle 11gR2 / Linux
By: kevinz on Mon, 27 February 2017
19 6640 Thu, 02 March 2017 20:08
By: Bill B
  Convert select query to a cursor and that has to fetch first record
Oracle 11g
By: msyogi on Thu, 02 March 2017
3 2090 Thu, 02 March 2017 14:21
By: Michel Cadot
  Using debug in EBS r12 database with SQL Developer
ORACLE EBS R12
By: annu-agi on Wed, 01 March 2017
4 3119 Thu, 02 March 2017 09:53
By: Michel Cadot
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 2372 Thu, 02 March 2017 08:13
By: cookiemonster
  How to query and not include weekend or Bankholidays
SQL
By: timppap on Thu, 02 March 2017
2 2213 Thu, 02 March 2017 02:17
By: Barbara Boehmer
  Carriage return in column data for spool
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: abhi_orcl on Tue, 28 February 2017
12 7326 Wed, 01 March 2017 12:08
By: Michel Cadot
  Today I came across different space issue in 12c DB (merged 2)
PL/SQL Release 12.1.0.2.0 - Production
By: saini006 on Wed, 01 March 2017
5 3462 Wed, 01 March 2017 09:18
By: Flyby
  Complex date differences - Bet you can't figure this one out.
By: ertweety on Mon, 27 February 2017
11 5566 Tue, 28 February 2017 09:27
By: Michel Cadot
  online table structure changes without affecting the user
11g
By: manikandan23 on Sat, 25 February 2017
22 6159 Tue, 28 February 2017 06:49
By: EdStevens
  Execute Immediate with Dynamic From table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 28 February 2017
2 2135 Tue, 28 February 2017 01:51
By: saipradyumn
  2 column values going inverse and how to display corresponding keys
11g
By: manikandan23 on Sat, 25 February 2017
14 6396 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 2477 Mon, 27 February 2017 12:00
By: Michel Cadot
  can we use column alias in having clause
By: asliyanage on Sun, 26 February 2017
6 2739 Mon, 27 February 2017 09:14
By: Bill B
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 2343 Mon, 27 February 2017 09:11
By: Bill B
  Return all rows if no matching condition found
Oracle 12c
By: pratik4891 on Sun, 26 February 2017
4 2086 Mon, 27 February 2017 07:21
By: Michel Cadot
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 5338 Sun, 26 February 2017 01:40
By: Michel Cadot
  How to find No of Entries per week For consecutive week
By: gspandian on Thu, 23 February 2017
30 10647 Sat, 25 February 2017 05:59
By: Solomon Yakobson
  ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
12c
By: jaysorcale on Wed, 18 January 2017
14 22060 Sat, 25 February 2017 01:42
By: asliyanage
  Declare a cursor from the return of a procedure?
By: sdsmaster on Tue, 21 February 2017
8 3505 Thu, 23 February 2017 15:07
By: Barbara Boehmer
  Update based on grouping
11.0.2.10
By: OraFerro on Mon, 20 February 2017
26 7216 Wed, 22 February 2017 05:24
By: Michel Cadot
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 3175 Tue, 21 February 2017 23:23
By: Barbara Boehmer
  Flashback techniues
By: Vijayarajan51 on Tue, 21 February 2017
2 2028 Tue, 21 February 2017 10:26
By: Michel Cadot
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: Thu Apr 25 15:37:54 CDT 2024