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
  Help me with error Compilation unit analysis terminated (2 threads merged by bb)
window7
By: hosun0919 on Sun, 12 March 2017
3 784 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 667 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 1775 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 1267 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 1425 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 1124 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 1022 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 1487 Thu, 09 March 2017 07:11
By: Bill B
  Exchange Partition
Oracle 11g
By: saipradyumn on Wed, 08 March 2017
2 700 Wed, 08 March 2017 01:43
By: saipradyumn
  Enable novalidate constraint
Oracle 11g
By: ORAGENASHOK on Mon, 06 March 2017
7 1049 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 1593 Tue, 07 March 2017 03:02
By: cookiemonster
  Date closest to event date
By: ertweety on Mon, 06 March 2017
5 652 Mon, 06 March 2017 20:44
By: ertweety
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 611 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 787 Mon, 06 March 2017 02:58
By: cookiemonster
  why cbo select FULL TABLE SCAN
By: meganmegan on Thu, 02 March 2017
14 1404 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 2088 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 593 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 1012 Thu, 02 March 2017 09:53
By: Michel Cadot
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 742 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 634 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 1383 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 731 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 1272 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 1754 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 636 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 1650 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 648 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 735 Mon, 27 February 2017 09:14
By: Bill B
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 747 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 664 Mon, 27 February 2017 07:21
By: Michel Cadot
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 1984 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 1721 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 9935 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 988 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 1879 Wed, 22 February 2017 05:24
By: Michel Cadot
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 813 Tue, 21 February 2017 23:23
By: Barbara Boehmer
  Flashback techniues
By: Vijayarajan51 on Tue, 21 February 2017
2 649 Tue, 21 February 2017 10:26
By: Michel Cadot
  Loading techniques
By: Vijayarajan51 on Tue, 21 February 2017
3 567 Tue, 21 February 2017 10:10
By: Vijayarajan51
  unique result
Oracle 11g
By: rahul1982 on Tue, 21 February 2017
2 544 Tue, 21 February 2017 03:39
By: rahul1982
  Comma separate value with column value as column name
11.2.0.4
By: grpatwari on Sun, 19 February 2017
4 706 Mon, 20 February 2017 07:49
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: Mon Jun 18 09:35:50 CDT 2018