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
  CURSOR taking more time
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
By: amarjadhav on Fri, 10 March 2017
11 629 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 644 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 454 Sun, 12 March 2017 00:49
By: SADASIVAM
  Exchange Partition
Oracle 11g
By: saipradyumn on Wed, 08 March 2017
2 392 Wed, 08 March 2017 01:43
By: saipradyumn
  Assistance in Query Construction
Oracle 10g, 11g
By: ORA2015 on Thu, 09 March 2017
11 550 Fri, 10 March 2017 10:55
By: ORA2015
  Date closest to event date
By: ertweety on Mon, 06 March 2017
5 334 Mon, 06 March 2017 20:44
By: ertweety
  Enable novalidate constraint
Oracle 11g
By: ORAGENASHOK on Mon, 06 March 2017
7 618 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 619 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 763 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 668 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 437 Thu, 16 March 2017 07:31
By: Bill B
  why cbo select FULL TABLE SCAN
By: meganmegan on Thu, 02 March 2017
14 676 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 324 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 500 Mon, 06 March 2017 02:58
By: cookiemonster
  {} in SQL
Oracle 11g
By: rahul1982 on Thu, 02 March 2017
5 407 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 409 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 366 Thu, 02 March 2017 02:17
By: Barbara Boehmer
  Analytical query
Oracle 11g
By: srinivas.k2005 on Mon, 06 March 2017
3 347 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 600 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 652 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 364 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 929 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 608 Tue, 28 February 2017 09:27
By: Michel Cadot
  Avoiding 2 Group By clauses
By: manikandan23 on Mon, 27 February 2017
5 337 Mon, 27 February 2017 12:00
By: Michel Cadot
  How to find highest salary ?
By: asliyanage on Sun, 26 February 2017
37 1345 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 364 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 400 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 810 Tue, 28 February 2017 06:49
By: EdStevens
  Deletes with respect to table sizes
11g
By: manikandan23 on Sat, 25 February 2017
6 422 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 819 Mon, 27 February 2017 16:13
By: Barbara Boehmer
  Why difference between count(*) and count(*)
By: asliyanage on Sat, 25 February 2017
15 1061 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 799 Sat, 25 February 2017 05:59
By: Solomon Yakobson
  Loading techniques
By: Vijayarajan51 on Tue, 21 February 2017
3 321 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 975 Sat, 11 March 2017 02:43
By: Manoj.Gupta.91
  unique result
Oracle 11g
By: rahul1982 on Tue, 21 February 2017
2 315 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 444 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 584 Thu, 23 February 2017 15:07
By: Barbara Boehmer
  Synonym switching
oracle 11g release 2
By: raj85844 on Thu, 16 February 2017
5 526 Thu, 16 February 2017 16:50
By: Caffeine+
  Oracle BLOB DATA
ORACLE,PLSQL
By: bkumar on Wed, 15 February 2017
5 255 Wed, 15 February 2017 14:11
By: BlackSwan
  cumulative sum & product
oracle 11g release 2
By: varada on Wed, 15 February 2017
18 687 Thu, 16 February 2017 10:02
By: varada
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 Nov 24 01:29:26 CST 2017

Total time taken to generate the page: 0.01449 seconds