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
  SQL
Oracle 11g
By: jen804 on Thu, 09 April 2015
2 635 Fri, 10 April 2015 02:50
By: cookiemonster
  help in writing query
oracle 11 g
By: simplesanju on Thu, 09 April 2015
2 579 Thu, 09 April 2015 07:43
By: Michel Cadot
  Materialized is getting invalid after refresh
Oracle Database 11g Release 11.2.0.3.0
By: saipavan.plsql on Wed, 08 April 2015
4 766 Thu, 09 April 2015 04:24
By: saipavan.plsql
  saving query Output in a single variable
By: palpali on Thu, 09 April 2015
9 749 Thu, 09 April 2015 04:18
By: palpali
  Oracle Number length to SQL Numeric length
By: giszzmo on Tue, 07 April 2015
3 739 Wed, 08 April 2015 18:58
By: WayCal
icon2.gif need help for oracle sql
ORACLE
By: hivwood on Tue, 07 April 2015
12 977 Wed, 08 April 2015 04:54
By: Michel Cadot
  %rowtype error 06512
By: Nasir.azeem on Wed, 08 April 2015
5 629 Wed, 08 April 2015 02:27
By: Nasir.azeem
  how to retreive the second word using substring
By: Info_dev on Tue, 07 April 2015
3 618 Wed, 08 April 2015 01:36
By: Lalit Kumar B
  Unable to drop an Index
By: msinha8 on Tue, 07 April 2015
5 644 Tue, 07 April 2015 03:00
By: msinha8
  Package Initialization block for performance tuning
Oracle 11g
By: dhulia_padhi@yahoo.com on Sun, 05 April 2015
3 668 Mon, 06 April 2015 09:11
By: BlackSwan
  how to user regexp to put single quotes
oracle 11g
By: gentleman777us on Fri, 03 April 2015
3 640 Sat, 04 April 2015 01:17
By: Lalit Kumar B
  Need help in tablespace
Oracle 10g XE, Windows 7
By: dark_prince on Mon, 30 March 2015
29 1470 Fri, 03 April 2015 21:37
By: BlackSwan
  explicit and implicit cursor loop
By: sampathkore4444@gmail.com on Fri, 03 April 2015
2 477 Fri, 03 April 2015 10:39
By: Michel Cadot
  Child tables, grand child tables of a table
Oracle 11.2.0.3
By: pointers on Wed, 01 April 2015
2 612 Thu, 02 April 2015 02:28
By: pointers
  Best way to get count of unique months with activity
Oracle 11.2
By: statey603 on Wed, 01 April 2015
3 529 Wed, 01 April 2015 15:23
By: joy_division
  how to get unmatched record from emp and dept tables
oracle 10g
By: ursfriend77 on Sun, 29 March 2015
13 874 Wed, 01 April 2015 01:19
By: Michel Cadot
icon5.gif different results of sql query on different servers (with the same data)
see below
By: ecivgamer on Tue, 31 March 2015
3 585 Tue, 31 March 2015 14:42
By: EdStevens
  JSON parsing?
12c
By: JDOaktown on Mon, 30 March 2015
12 728 Tue, 31 March 2015 12:44
By: JDOaktown
  Select query is hitting the database multiple times
By: kiran_vangeti on Tue, 31 March 2015
6 574 Tue, 31 March 2015 05:43
By: Michel Cadot
  case
By: palpali on Mon, 30 March 2015
7 600 Tue, 31 March 2015 01:07
By: palpali
icon5.gif Split CLOB column to multiple columns within a row
Oracle 11g
By: as1986 on Thu, 19 February 2015
23 2749 Mon, 30 March 2015 23:43
By: as1986
  sql 9I ,10G ,11GDIFFERENCE SQL LEVEL
9I,10G,11G
By: duttatarun on Mon, 30 March 2015
7 644 Mon, 30 March 2015 05:25
By: Michel Cadot
  Query regarding Outer Join
Oracle 11g , Windows 7
By: rakeshramm on Wed, 25 March 2015
9 895 Sat, 28 March 2015 10:29
By: Kevin Meade
  SQL query (merged 3)
By: sunny1234 on Thu, 26 March 2015
13 950 Fri, 27 March 2015 06:21
By: Solomon Yakobson
  Converting Prompt syntax into regular sql
Oracle IDE 4.0
By: haryshenoy on Thu, 26 March 2015
1 433 Thu, 26 March 2015 12:18
By: Michel Cadot
  insert statement w/o having unique constraint error
By: suji6281 on Thu, 26 March 2015
3 546 Thu, 26 March 2015 12:16
By: Michel Cadot
  pl sql error
oracle 11g,windows 7
By: hcdba on Thu, 26 March 2015
10 733 Thu, 26 March 2015 10:48
By: Solomon Yakobson
  Using TYPE within an SQL IN statement
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: Duane on Tue, 24 March 2015
19 1106 Thu, 26 March 2015 01:28
By: Michel Cadot
  request for solution
By: pramodnawle on Wed, 25 March 2015
3 586 Wed, 25 March 2015 14:22
By: Littlefoot
  Enforcing a particular execution plan
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: manubatham20 on Wed, 25 March 2015
3 524 Wed, 25 March 2015 11:56
By: manubatham20
  need conditional quantity insert into table
oracle
By: niteshtet on Tue, 24 March 2015
6 790 Wed, 25 March 2015 06:32
By: niteshtet
  Query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Tue, 24 March 2015
4 546 Tue, 24 March 2015 15:27
By: sspn2010
  merging two queries to create a table
sql
By: palpali on Mon, 23 March 2015
14 776 Tue, 24 March 2015 07:12
By: palpali
  DBMS_JOB TO run every saturday starting next saturday
oracle 11g Release2
By: azeem87 on Wed, 18 March 2015
6 808 Mon, 23 March 2015 09:35
By: azeem87
  synonyms
Developer 6i, Databse 11G R2,window 7 ultimate
By: kilimanjaro on Thu, 19 March 2015
13 1228 Sun, 22 March 2015 07:37
By: EdStevens
  REGEXP_REPLACE Help NEEDED....
Oracle, 11.2.3, AIX
By: eastbay_oracle on Thu, 19 March 2015
3 438 Thu, 19 March 2015 16:59
By: eastbay_oracle
  EXISTS SQL QUERY
By: palpali on Thu, 19 March 2015
15 783 Thu, 19 March 2015 14:48
By: Michel Cadot
  need query based on the below requirement
Oracle 10g
By: vasu.bods703 on Thu, 19 March 2015
5 522 Thu, 19 March 2015 13:34
By: joy_division
  Need to identify columns not referenced in UPDATE SET clause.
By: gajini on Wed, 18 March 2015
4 629 Thu, 19 March 2015 11:05
By: EdStevens
  Result in same rows
plsql
By: mehboob110233 on Thu, 19 March 2015
8 748 Thu, 19 March 2015 09:24
By: Lalit Kumar 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: Tue May 24 01:29:16 CDT 2016

Total time taken to generate the page: 0.09631 seconds