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
  Flattening out a table
Oracle 10G
By: mxz25 on Thu, 13 June 2013
9 5393 Mon, 30 November 2015 08:00
By: gazzag
  Query execute time versus fetch time
11.2.1.0
By: OraFerro on Wed, 18 November 2015
35 42854 Mon, 30 November 2015 00:03
By: OraFerro
  Display Employee details with min & max hired date
Oracle 11g
By: arifs3738 on Sun, 29 November 2015
4 2482 Sun, 29 November 2015 11:40
By: BlackSwan
  sql - transpose
By: rankrose on Fri, 31 July 2015
12 9467 Sun, 29 November 2015 08:04
By: Michel Cadot
  Delete duplicate records without Rowid and drop (2 Merged)
Oracle 10G Pl/Sql ( 1 2)
By: bonvivant on Sat, 07 April 2012
41 47875 Sat, 28 November 2015 11:57
By: Solomon Yakobson
  Closing cursors - but its does not? Error: maximum open cursors exceeded
Oracle 12c
By: wmgonzalbo on Sat, 28 November 2015
2 361 Sat, 28 November 2015 08:19
By: BlackSwan
  sql queries
oracle 11g sql developer
By: sabsac on Mon, 23 November 2015
18 750 Sat, 28 November 2015 02:31
By: Michel Cadot
  SQL Query Suggestion
Oracle 12c
By: msambasiva on Fri, 27 November 2015
4 410 Fri, 27 November 2015 11:20
By: msambasiva
  SQL Query Help
Oracle 11g
By: arifs3738 on Tue, 17 November 2015
7 758 Fri, 27 November 2015 06:03
By: arifs3738
  SQL Query Help
Oracle 11g
By: arifs3738 on Mon, 16 November 2015
7 967 Fri, 27 November 2015 06:00
By: arifs3738
  count of tests
10
By: pratik4891 on Thu, 26 November 2015
16 1634 Fri, 27 November 2015 01:58
By: pratik4891
  Decode expression help
By: redhonda9834 on Tue, 24 November 2015
7 614 Wed, 25 November 2015 07:10
By: redhonda9834
  Insert into multiple blocks
Oracle 11.2.0.3
By: pointers on Tue, 24 November 2015
1 378 Tue, 24 November 2015 04:33
By: Michel Cadot
  Selecting/Inserting Missing values
Oracle 11gR2 ,Solaris
By: tigsav on Thu, 19 November 2015
2 414 Mon, 23 November 2015 10:57
By: tigsav
  How to get first and last day for 13 month back
By: blyzz on Mon, 23 November 2015
6 469 Mon, 23 November 2015 10:21
By: Michel Cadot
  MERGE: DELETE CLAUSE definition explanation.
Oracle 11g
By: arifs3738 on Mon, 23 November 2015
3 387 Mon, 23 November 2015 08:48
By: Solomon Yakobson
  opposite of listagg
Oracle 11g
By: mape on Fri, 26 October 2012
11 11683 Mon, 23 November 2015 07:53
By: pablolee
icon5.gif WITH clause working in 10g but not in 11g (XE)
Oracle 10g and 11g
By: Rishab_le_noob on Mon, 23 November 2015
3 404 Mon, 23 November 2015 02:04
By: Michel Cadot
icon4.gif Sysdate to_char DAY conversion not comparable
Oracle 10g and 11g
By: Rishab_le_noob on Mon, 23 November 2015
3 375 Mon, 23 November 2015 01:40
By: Michel Cadot
  Convert Rows to Columns
Oracle, 11g, Solaris
By: uman2631 on Wed, 18 November 2015
7 625 Mon, 23 November 2015 01:33
By: Rishab_le_noob
  Need Explanation on this query
Oracle SQL
By: hharishh86 on Fri, 20 November 2015
2 733 Mon, 23 November 2015 01:02
By: hharishh86
  SYS_GUID FUNCTION RETURNING SAME VALUE
Oracle 11g Enterprise Edition Release 11.2.0.3.0
By: jarockiadoss on Thu, 19 November 2015
18 919 Fri, 20 November 2015 12:34
By: jarockiadoss
  Difference the rows
Oracle 11g windows
By: knari007 on Thu, 19 November 2015
6 654 Fri, 20 November 2015 09:08
By: Solomon Yakobson
  Basic sorting concept
10g
By: nciteamo on Thu, 19 November 2015
9 505 Thu, 19 November 2015 11:20
By: EdStevens
  extract string using regex
10g
By: m.abdulhaq on Thu, 19 November 2015
4 367 Thu, 19 November 2015 06:09
By: Solomon Yakobson
icon5.gif How to display multiple records in a single row
Oracle 11g
By: subash141 on Wed, 18 November 2015
7 488 Wed, 18 November 2015 14:04
By: Michel Cadot
  How to analyze complex sql queries
11G
By: gorants on Tue, 17 November 2015
4 547 Wed, 18 November 2015 12:42
By: gorants
  Results Set based on Dynamic Date stored in variable
Oracle SQL Developer
By: Anil98765 on Mon, 16 November 2015
6 717 Tue, 17 November 2015 13:32
By: BlackSwan
  Stored Proc not inserting all records
By: kr1347 on Sun, 15 November 2015
10 1005 Mon, 16 November 2015 15:08
By: flyboy
  arraysize and PL/SQL
Oracle 11g Solaris
By: uman2631 on Fri, 13 November 2015
3 795 Sun, 15 November 2015 12:57
By: Lalit Kumar B
  E-Mail sending issue from Oracle Database
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Fri, 12 December 2014
14 4212 Fri, 13 November 2015 15:54
By: Bill B
  ORA-12015: cannot create a fast refresh materialized view from a complex query
Oracle 11g (11.2.0.3)
By: tony_soprano786 on Wed, 11 November 2015
2 524 Fri, 13 November 2015 15:35
By: Bill B
  Determine Incomplete Orders
Oracle 11g
By: stun66 on Wed, 11 November 2015
4 576 Thu, 12 November 2015 03:49
By: mnitu
  PLSQL Collection index by varchar
By: wantsunny007 on Mon, 09 November 2015
21 823 Mon, 09 November 2015 15:06
By: wantsunny007
  Need Help in SQL Query
Oracle 11g
By: arifs3738 on Wed, 04 November 2015
22 1052 Mon, 09 November 2015 10:40
By: Michel Cadot
  sql query help
Oracle 11g
By: arifs3738 on Sun, 08 November 2015
6 608 Mon, 09 November 2015 07:28
By: Michel Cadot
  Oracle Regular Expression - Remove space between alphabetic tokens of length 1 within a string
Oracle 11.2
By: orauser001 on Thu, 05 November 2015
10 715 Sat, 07 November 2015 23:00
By: orauser001
  find updated table name
oracle 11gr2
By: guddu_12 on Thu, 05 November 2015
12 582 Thu, 05 November 2015 09:38
By: BlackSwan
icon5.gif i want to use temporary data source for next time and it is going in that way
11g
By: graphe on Wed, 04 November 2015
2 439 Thu, 05 November 2015 06:17
By: graphe
  Out of SQL Query
Oracle 11g
By: arifs3738 on Wed, 04 November 2015
3 398 Wed, 04 November 2015 06:33
By: arifs3738
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 Feb 09 12:28:35 CST 2016

Total time taken to generate the page: 0.05338 seconds