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 to get amounts by type
Oracle RDBMS 11G
By: oteixeira on Thu, 17 September 2015
25 688 Thu, 17 September 2015 10:45
By: cookiemonster
icon5.gif Pivot
By: tunny2014 on Thu, 17 September 2015
8 457 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 4155 Thu, 17 September 2015 07:04
By: cookiemonster
  Table patition and aautomate sub partition.
By: raopatwariyahoocom on Tue, 15 September 2015
9 6033 Wed, 16 September 2015 11:49
By: BlackSwan
  Options for definitions of INDEXES used by CONSTRAINTS
By: mjm22 on Tue, 15 September 2015
2 1836 Wed, 16 September 2015 01:56
By: John Watson
  Dynamic SQL in cursor
By: phiroc on Mon, 14 September 2015
21 816 Tue, 15 September 2015 11:05
By: cookiemonster
  Using constants
By: phiroc on Mon, 14 September 2015
5 597 Tue, 15 September 2015 10:40
By: phiroc
  except duplicate record
By: Nasir.azeem on Fri, 11 September 2015
9 606 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 1005 Mon, 14 September 2015 07:16
By: cookiemonster
  String Comparasition
By: steek12 on Sun, 13 September 2015
3 470 Mon, 14 September 2015 03:42
By: steek12
  how to write this unpivot query
oracle 12c.
By: zeninblue on Fri, 11 September 2015
3 2141 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 10508 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 2584 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 7689 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 2547 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 1958 Thu, 10 September 2015 14:10
By: Michel Cadot
  hierarchial query
oracle 10g
By: kadhirvel.k on Thu, 10 September 2015
2 429 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 667 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 432 Tue, 08 September 2015 05:06
By: Flyby
  Data Function help
By: samyms on Fri, 04 September 2015
3 575 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 650 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 998 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 1359 Fri, 04 September 2015 10:07
By: Michel Cadot
  Table Lock
Oracle 11g
By: stsivaraj on Tue, 01 September 2015
5 665 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 3009 Thu, 03 September 2015 23:04
By: BlackSwan
  Constraint problem for flag
Oracle 11
By: brown_zzz on Thu, 03 September 2015
5 480 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 885 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 633 Wed, 02 September 2015 08:35
By: Michel Cadot
  Data migration fromOracle to SFDC
By: vasudevaviswa on Tue, 01 September 2015
3 476 Tue, 01 September 2015 18:20
By: BlackSwan
  innerjoin on variable date range
By: mattz on Mon, 31 August 2015
3 582 Tue, 01 September 2015 06:39
By: pablolee
  Order by in Listagg
Oracle 11g
By: Xandot on Tue, 01 September 2015
3 499 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 386 Mon, 31 August 2015 10:30
By: BlackSwan
  MERGE
db 12.1.0.2
By: John Watson on Fri, 28 August 2015
2 507 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 610 Fri, 28 August 2015 04:16
By: sandeep_orafaq
  procedure to give ALTER USER to another
Oracle RDBMS 11G and above
By: wolffjw on Thu, 27 August 2015
6 469 Thu, 27 August 2015 15:03
By: Michel Cadot
  Finding matching values
Oracle 11.2.0.4
By: manubatham20 on Wed, 19 August 2015
12 1062 Thu, 27 August 2015 09:35
By: manubatham20
  Query
9i
By: glmjoy on Wed, 26 August 2015
4 471 Wed, 26 August 2015 09:03
By: CraigB
  Add +1 to Date Field (Newbie to SQL and Oracle)
Oracle
By: bseismic on Tue, 25 August 2015
4 672 Wed, 26 August 2015 06:20
By: EdStevens
  Table partition
oracle
By: sanodani on Mon, 24 August 2015
23 1009 Wed, 26 August 2015 02:31
By: cookiemonster
  compare column value to a column value in next row
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
By: rkhatiwala on Fri, 21 August 2015
2 821 Mon, 24 August 2015 08:53
By: rkhatiwala
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: Sun May 01 03:45:44 CDT 2016

Total time taken to generate the page: 0.06443 seconds