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
  How to select last rate of Product
10g
By: manisngpl on Sat, 19 September 2015
4 613 Mon, 21 September 2015 04:47
By: dude4084
  merge statement (merged :)
By: sa_dwhite on Sat, 19 September 2015
15 874 Mon, 21 September 2015 02:58
By: flyboy
  how to loop within sql statement without using PL/SQL Block
By: ramya29p on Thu, 17 September 2015
6 612 Mon, 21 September 2015 01:21
By: Michel Cadot
  query same table multiple times
Oracle DB 11gR2
By: hungman on Sun, 20 September 2015
0 604 Sun, 20 September 2015 20:49
By: hungman
  pl/sql
By: ORA456 on Sun, 20 September 2015
4 466 Sun, 20 September 2015 11:43
By: ORA456
  DBMS_OUTPUT
11g
By: thiruvari on Thu, 17 September 2015
11 537 Thu, 17 September 2015 14:09
By: Michel Cadot
  SQL to get amounts by type
Oracle RDBMS 11G
By: oteixeira on Thu, 17 September 2015
25 732 Thu, 17 September 2015 10:45
By: cookiemonster
icon5.gif Pivot
By: tunny2014 on Thu, 17 September 2015
8 496 Thu, 17 September 2015 09:03
By: BlackSwan
  Query running fine in TOAD and SQL developer but very slow in Server ( oracle DB) [merged 2]
By: saurabh.sha on Fri, 11 September 2015
20 4235 Thu, 17 September 2015 07:04
By: cookiemonster
  Table patition and aautomate sub partition.
By: raopatwariyahoocom on Tue, 15 September 2015
9 6089 Wed, 16 September 2015 11:49
By: BlackSwan
  Options for definitions of INDEXES used by CONSTRAINTS
By: mjm22 on Tue, 15 September 2015
2 1869 Wed, 16 September 2015 01:56
By: John Watson
  Dynamic SQL in cursor
By: phiroc on Mon, 14 September 2015
21 861 Tue, 15 September 2015 11:05
By: cookiemonster
  Using constants
By: phiroc on Mon, 14 September 2015
5 623 Tue, 15 September 2015 10:40
By: phiroc
  except duplicate record
By: Nasir.azeem on Fri, 11 September 2015
9 676 Mon, 14 September 2015 07:25
By: cookiemonster
  Display the range wise column names
11.2.0.3
By: grpatwari on Fri, 21 August 2015
14 1044 Mon, 14 September 2015 07:16
By: cookiemonster
  String Comparasition
By: steek12 on Sun, 13 September 2015
3 511 Mon, 14 September 2015 03:42
By: steek12
  how to write this unpivot query
oracle 12c.
By: zeninblue on Fri, 11 September 2015
3 2190 Fri, 11 September 2015 19:18
By: BlackSwan
  String longer than 4000 chars inside cursor-for loop
Oracle 11g, Oracle SQL Developer 3.2.10.09
By: yepp on Thu, 10 September 2015
10 10645 Fri, 11 September 2015 11:12
By: Jay1
  Count records from two tables
RDBMS 11G, EBS 11i
By: oteixeira on Fri, 11 September 2015
4 2634 Fri, 11 September 2015 09:21
By: oteixeira
  Consolidated output from a LOOP
Oracle 12c, windows 2012
By: muktha_22 on Thu, 10 September 2015
11 7730 Fri, 11 September 2015 02:49
By: cookiemonster
  Search Oracle table and only list data depending on rows
Oracle 11
By: aft5425@anthem.com on Thu, 10 September 2015
4 2568 Fri, 11 September 2015 00:14
By: Littlefoot
  Compare 2 encrypted values
Oralce 12c - Release 12.1.0.2.0
By: raskotha on Thu, 10 September 2015
3 1977 Thu, 10 September 2015 14:10
By: Michel Cadot
  hierarchial query
oracle 10g
By: kadhirvel.k on Thu, 10 September 2015
2 455 Thu, 10 September 2015 00:49
By: Michel Cadot
  How to display employee table information based on salary in different ranges
Oracle 11g, windows
By: nbarun07 on Wed, 09 September 2015
9 688 Wed, 09 September 2015 10:07
By: sandeep_orafaq
  Different way of writing OR condition
Oralce 11 g
By: na.dharma@gmail.com on Tue, 08 September 2015
2 449 Tue, 08 September 2015 05:06
By: Flyby
  Data Function help
By: samyms on Fri, 04 September 2015
3 622 Tue, 08 September 2015 02:39
By: sandeep_orafaq
  PLSQL - providing values to Bind variables appearing multiple times in USING clause
Oracle 11g, Linux
By: danand77 on Sun, 06 September 2015
6 688 Mon, 07 September 2015 07:52
By: Michel Cadot
  Remove Second Occurrence of a word in String
oracle form 10G
By: malya on Fri, 04 September 2015
18 1062 Sat, 05 September 2015 07:15
By: Solomon Yakobson
  ora-00900 invalid sql statement while using open cursor for variable
By: bhardkap on Fri, 28 August 2015
14 1465 Fri, 04 September 2015 10:07
By: Michel Cadot
  Table Lock
Oracle 11g
By: stsivaraj on Tue, 01 September 2015
5 705 Fri, 04 September 2015 00:53
By: Michel Cadot
  to derive previous dates and ignore first date
Oracle 11g ( 1 2)
By: rohit_shinez on Fri, 14 August 2015
63 3071 Thu, 03 September 2015 23:04
By: BlackSwan
  Constraint problem for flag
Oracle 11
By: brown_zzz on Thu, 03 September 2015
5 507 Thu, 03 September 2015 09:10
By: brown_zzz
  Top 2 Salary from Each Dept without using Analytic Function
Oracle 11g,windows 7
By: aspire on Wed, 02 September 2015
14 925 Thu, 03 September 2015 00:51
By: Michel Cadot
  migrate View from SQL to Oracle
11.g
By: oracle1987 on Wed, 02 September 2015
7 663 Wed, 02 September 2015 08:35
By: Michel Cadot
  Data migration fromOracle to SFDC
By: vasudevaviswa on Tue, 01 September 2015
3 534 Tue, 01 September 2015 18:20
By: BlackSwan
  innerjoin on variable date range
By: mattz on Mon, 31 August 2015
3 627 Tue, 01 September 2015 06:39
By: pablolee
  Order by in Listagg
Oracle 11g
By: Xandot on Tue, 01 September 2015
3 524 Tue, 01 September 2015 04:13
By: Xandot
  Struggling with Query holding temp space
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
By: manubatham20 on Mon, 31 August 2015
1 420 Mon, 31 August 2015 10:30
By: BlackSwan
  MERGE
db 12.1.0.2
By: John Watson on Fri, 28 August 2015
2 547 Fri, 28 August 2015 13:59
By: John Watson
  Need data beween date range
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: sathishh.mk@gmail.com on Thu, 27 August 2015
9 640 Fri, 28 August 2015 04:16
By: sandeep_orafaq
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: Wed Jun 29 16:53:34 CDT 2016

Total time taken to generate the page: 0.10077 seconds