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
  Can we replace any sub query using join
By: asliyanage on Wed, 22 March 2017
3 362 Sat, 01 April 2017 02:59
By: Michel Cadot
  Orcale: Missing Group By expression working
Oracle 12, Windows
By: MikeBnDe on Wed, 22 March 2017
5 317 Wed, 22 March 2017 10:56
By: Michel Cadot
  Conditional Join Logic
Oracle 11g
By: rajsinha on Tue, 21 March 2017
3 285 Wed, 22 March 2017 03:35
By: John Watson
  Append Hint in oracle
By: amit.sonar on Fri, 17 March 2017
10 681 Mon, 20 March 2017 09:44
By: Solomon Yakobson
  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 890 Tue, 21 March 2017 06:24
By: John Watson
  ORDER BY Clause error in cursor
9i, 9.0.1.1, XP
By: billgates on Fri, 17 March 2017
7 442 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 371 Fri, 17 March 2017 13:42
By: Bill B
  ORACLE sql HELP NEEDED
Oracle 11 g
By: abhi2varmaarma on Thu, 16 March 2017
2 270 Thu, 16 March 2017 13:04
By: Michel Cadot
  Query performance
SQL
By: Jiggu on Thu, 16 March 2017
19 896 Fri, 24 March 2017 04:40
By: Bill B
  oracle transaction
By: asliyanage on Wed, 15 March 2017
14 493 Thu, 16 March 2017 14:04
By: Solomon Yakobson
  copy table structure
By: asliyanage on Wed, 15 March 2017
17 840 Wed, 22 March 2017 09:08
By: cookiemonster
  dynamically creating index from same table in different schema
11g release 2
By: raj85844 on Tue, 14 March 2017
5 296 Tue, 14 March 2017 12:14
By: Michel Cadot
  how to send tablespace mail alerts with PL/SQL
By: diomahardhika on Mon, 13 March 2017
24 815 Tue, 04 April 2017 03:56
By: cookiemonster
  Help me with error Compilation unit analysis terminated (2 threads merged by bb)
window7
By: hosun0919 on Sun, 12 March 2017
3 310 Mon, 13 March 2017 01:09
By: Michel Cadot
  Uploading csv files with different names on periodical basis.
Oracle Enterprise Edition 11g R2
By: Manoj.Gupta.91 on Sat, 11 March 2017
3 295 Mon, 13 March 2017 21:07
By: BlackSwan
  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 472 Fri, 10 March 2017 10:48
By: Michel Cadot
  query dead slow
ORACLE EBS R12
By: annu-agi on Sat, 11 March 2017
19 737 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 618 Fri, 17 March 2017 04:48
By: annu-agi
  CURSOR taking more time
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
By: amarjadhav on Fri, 10 March 2017
11 556 Thu, 23 March 2017 14:30
By: mikek
  which is best to locate row in oracle table
By: asliyanage on Wed, 08 March 2017
15 566 Thu, 09 March 2017 07:11
By: Bill B
  Query Help
Oracle 12.1.0.2.0
By: SADASIVAM on Sun, 12 March 2017
0 401 Sun, 12 March 2017 00:49
By: SADASIVAM
  Exchange Partition
Oracle 11g
By: saipradyumn on Wed, 08 March 2017
2 302 Wed, 08 March 2017 01:43
By: saipradyumn
  Assistance in Query Construction
Oracle 10g, 11g
By: ORA2015 on Thu, 09 March 2017
11 477 Fri, 10 March 2017 10:55
By: ORA2015
  Date closest to event date
By: ertweety on Mon, 06 March 2017
5 278 Mon, 06 March 2017 20:44
By: ertweety
  Enable novalidate constraint
Oracle 11g
By: ORAGENASHOK on Mon, 06 March 2017
7 388 Tue, 07 March 2017 03:27
By: Roachcoach
  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 553 Thu, 09 March 2017 07:16
By: Bill B
  How to split col into two columns according to data types
By: ssyr on Mon, 06 March 2017
21 639 Tue, 07 March 2017 03:02
By: cookiemonster
  FOR UPDATE NOWAIT and ORA-29285: file write error
Oracle 11g
By: Prabhu Hooli on Sat, 04 March 2017
7 582 Fri, 10 March 2017 08:16
By: BlackSwan
  calling a function as a input parameter for a stored procedure
oracle 11g release 2
By: raj85844 on Tue, 14 March 2017
6 373 Thu, 16 March 2017 07:31
By: Bill B
  why cbo select FULL TABLE SCAN
By: meganmegan on Thu, 02 March 2017
14 600 Sun, 05 March 2017 04:57
By: meganmegan
  Convert select query to a cursor and that has to fetch first record
Oracle 11g
By: msyogi on Thu, 02 March 2017
3 281 Thu, 02 March 2017 14:21
By: Michel Cadot
  Delays between two dates excluding holidays/weekends
Oracle 11.2.0.3
By: pointers on Thu, 02 March 2017
3 447 Mon, 06 March 2017 02:58
By: cookiemonster
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 350 Thu, 02 March 2017 08:13
By: cookiemonster
  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 340 Wed, 01 March 2017 09:18
By: Flyby
  How to query and not include weekend or Bankholidays
SQL
By: timppap on Thu, 02 March 2017
2 316 Thu, 02 March 2017 02:17
By: Barbara Boehmer
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 305 Mon, 06 March 2017 09:46
By: cookiemonster
  Using debug in EBS r12 database with SQL Developer
ORACLE EBS R12
By: annu-agi on Wed, 01 March 2017
4 457 Thu, 02 March 2017 09:53
By: Michel Cadot
  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 544 Wed, 01 March 2017 12:08
By: Michel Cadot
  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 310 Tue, 28 February 2017 01:51
By: saipradyumn
  Bitmap index for nullable timestamp column ?
Oracle 11gR2 / Linux
By: kevinz on Mon, 27 February 2017
19 818 Thu, 02 March 2017 20:08
By: Bill B
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: Sat Aug 19 12:03:04 CDT 2017

Total time taken to generate the page: 0.09163 seconds