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 695 Tue, 14 March 2017 12:14
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 2333 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 626 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 793 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 676 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 1807 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 1327 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 1440 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 1130 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 1031 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 1520 Thu, 09 March 2017 07:11
By: Bill B
  Exchange Partition
Oracle 11g
By: saipradyumn on Wed, 08 March 2017
2 709 Wed, 08 March 2017 01:43
By: saipradyumn
  Enable novalidate constraint
Oracle 11g
By: ORAGENASHOK on Mon, 06 March 2017
7 1058 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 1625 Tue, 07 March 2017 03:02
By: cookiemonster
  Date closest to event date
By: ertweety on Mon, 06 March 2017
5 663 Mon, 06 March 2017 20:44
By: ertweety
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 618 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 794 Mon, 06 March 2017 02:58
By: cookiemonster
  why cbo select FULL TABLE SCAN
By: meganmegan on Thu, 02 March 2017
14 1440 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 2177 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 600 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 1037 Thu, 02 March 2017 09:53
By: Michel Cadot
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 769 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 642 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 1415 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 740 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 1313 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 1800 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 642 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 1686 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 656 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 746 Mon, 27 February 2017 09:14
By: Bill B
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 759 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 677 Mon, 27 February 2017 07:21
By: Michel Cadot
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 2011 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 1759 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 10027 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 1003 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 1910 Wed, 22 February 2017 05:24
By: Michel Cadot
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 820 Tue, 21 February 2017 23:23
By: Barbara Boehmer
  Flashback techniues
By: Vijayarajan51 on Tue, 21 February 2017
2 652 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: Fri Jun 22 12:42:05 CDT 2018