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
  Exchange Partition
Oracle 11g
By: saipradyumn on Wed, 08 March 2017
2 388 Wed, 08 March 2017 01:43
By: saipradyumn
  Assistance in Query Construction
Oracle 10g, 11g
By: ORA2015 on Thu, 09 March 2017
11 547 Fri, 10 March 2017 10:55
By: ORA2015
  Date closest to event date
By: ertweety on Mon, 06 March 2017
5 331 Mon, 06 March 2017 20:44
By: ertweety
  Enable novalidate constraint
Oracle 11g
By: ORAGENASHOK on Mon, 06 March 2017
7 613 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 616 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 759 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 665 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 434 Thu, 16 March 2017 07:31
By: Bill B
  why cbo select FULL TABLE SCAN
By: meganmegan on Thu, 02 March 2017
14 671 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 320 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 496 Mon, 06 March 2017 02:58
By: cookiemonster
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 400 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 405 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 362 Thu, 02 March 2017 02:17
By: Barbara Boehmer
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 343 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 590 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 649 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 361 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 924 Thu, 02 March 2017 20:08
By: Bill B
  Complex date differences - Bet you can't figure this one out.
By: ertweety on Mon, 27 February 2017
11 605 Tue, 28 February 2017 09:27
By: Michel Cadot
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 333 Mon, 27 February 2017 12:00
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 1341 Tue, 14 March 2017 05:49
By: asliyanage
  Return all rows if no matching condition found
Oracle 12c
By: pratik4891 on Sun, 26 February 2017
4 361 Mon, 27 February 2017 07:21
By: Michel Cadot
  can we use column alias in having clause
By: asliyanage on Sun, 26 February 2017
6 395 Mon, 27 February 2017 09:14
By: Bill B
  online table structure changes without affecting the user
11g
By: manikandan23 on Sat, 25 February 2017
22 806 Tue, 28 February 2017 06:49
By: EdStevens
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 419 Mon, 27 February 2017 09:11
By: Bill B
  2 column values going inverse and how to display corresponding keys
11g
By: manikandan23 on Sat, 25 February 2017
14 815 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 1057 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 795 Sat, 25 February 2017 05:59
By: Solomon Yakobson
  Loading techniques
By: Vijayarajan51 on Tue, 21 February 2017
3 318 Tue, 21 February 2017 10:10
By: Vijayarajan51
  UTL_FILE.Put_Line carriage return.
11g R2
By: Manoj.Gupta.91 on Tue, 21 February 2017
6 959 Sat, 11 March 2017 02:43
By: Manoj.Gupta.91
  unique result
Oracle 11g
By: rahul1982 on Tue, 21 February 2017
2 312 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 440 Mon, 20 February 2017 07:49
By: Michel Cadot
  Declare a cursor from the return of a procedure?
By: sdsmaster on Tue, 21 February 2017
8 581 Thu, 23 February 2017 15:07
By: Barbara Boehmer
  Synonym switching
oracle 11g release 2
By: raj85844 on Thu, 16 February 2017
5 522 Thu, 16 February 2017 16:50
By: Caffeine+
  Oracle BLOB DATA
ORACLE,PLSQL
By: bkumar on Wed, 15 February 2017
5 252 Wed, 15 February 2017 14:11
By: BlackSwan
  cumulative sum & product
oracle 11g release 2
By: varada on Wed, 15 February 2017
18 683 Thu, 16 February 2017 10:02
By: varada
  Create a Job to run Oracle Package stored procedure
11.0.2.10
By: OraFerro on Wed, 15 February 2017
4 524 Wed, 15 February 2017 23:05
By: OraFerro
  Global Temporary table storage
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
By: abhi_orcl on Tue, 14 February 2017
9 419 Wed, 15 February 2017 10:36
By: abhi_orcl
  PLSQL - Update in Loop
Oracle 11g
By: wmpl on Mon, 20 February 2017
5 503 Tue, 21 February 2017 23:23
By: Barbara Boehmer
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: Tue Nov 21 11:41:00 CST 2017

Total time taken to generate the page: 0.08485 seconds