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 display employee table information based on salary in different ranges
Oracle 11g, windows
By: nbarun07 on Wed, 09 September 2015
9 678 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 440 Tue, 08 September 2015 05:06
By: Flyby
  Data Function help
By: samyms on Fri, 04 September 2015
3 600 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 674 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 1033 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 1414 Fri, 04 September 2015 10:07
By: Michel Cadot
  Table Lock
Oracle 11g
By: stsivaraj on Tue, 01 September 2015
5 683 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 3045 Thu, 03 September 2015 23:04
By: BlackSwan
  Constraint problem for flag
Oracle 11
By: brown_zzz on Thu, 03 September 2015
5 497 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 904 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 648 Wed, 02 September 2015 08:35
By: Michel Cadot
  Data migration fromOracle to SFDC
By: vasudevaviswa on Tue, 01 September 2015
3 509 Tue, 01 September 2015 18:20
By: BlackSwan
  innerjoin on variable date range
By: mattz on Mon, 31 August 2015
3 612 Tue, 01 September 2015 06:39
By: pablolee
  Order by in Listagg
Oracle 11g
By: Xandot on Tue, 01 September 2015
3 512 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 401 Mon, 31 August 2015 10:30
By: BlackSwan
  MERGE
db 12.1.0.2
By: John Watson on Fri, 28 August 2015
2 533 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 625 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 493 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 1092 Thu, 27 August 2015 09:35
By: manubatham20
  Query
9i
By: glmjoy on Wed, 26 August 2015
4 486 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 686 Wed, 26 August 2015 06:20
By: EdStevens
  Table partition
oracle
By: sanodani on Mon, 24 August 2015
23 1055 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 846 Mon, 24 August 2015 08:53
By: rkhatiwala
  Oracle Hierarchical Query max_level/connect_by_is_root
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: tmcallister on Thu, 20 August 2015
4 805 Fri, 21 August 2015 10:46
By: tmcallister
  Update statement where update exists.
Oracle 12.1.0.1.0 Window
By: tmcallister on Thu, 01 May 2014
6 1278 Fri, 21 August 2015 10:37
By: Michel Cadot
  Returning a sys_refcursor from an explicit cursor
11.2
By: tmcallister on Mon, 15 December 2014
2 889 Fri, 21 August 2015 10:36
By: Michel Cadot
  Creating String
Oracle 11g
By: Xandot on Fri, 31 July 2015
21 1466 Thu, 20 August 2015 04:16
By: Lalit Kumar B
  PL/SQL: ORA-00911: invalid character
Oracle 10g
By: thiruvari on Sat, 18 July 2015
5 1145 Thu, 20 August 2015 03:06
By: Michel Cadot
  Merge String
Oracle 11g
By: Xandot on Thu, 20 August 2015
4 543 Thu, 20 August 2015 02:12
By: Lalit Kumar B
  How to implement Materialized view in PL/SQL using Collections
Oracle Database 11g Release 11.2.0.3.0 - Production PL/SQL Release 11.2.0.3.0 - Production "CORE 11.2.0.3.0 Production" TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3
By: Lingaraju H C on Wed, 19 August 2015
10 683 Wed, 19 August 2015 21:42
By: John Watson
  check the column is numeric or data
oracle 9i
By: arun888 on Mon, 10 August 2015
35 1746 Wed, 19 August 2015 08:23
By: Bill B
icon7.gif Challenging Query
Oracle 11g , Windows 8
By: rakeshramm on Tue, 18 August 2015
5 585 Tue, 18 August 2015 06:44
By: Michel Cadot
  Hierarchy flattening and repetition
By: loosecontrol on Tue, 18 August 2015
3 417 Tue, 18 August 2015 05:23
By: Michel Cadot
  Exact String Match in Instr
Oracle 11g
By: Xandot on Sun, 16 August 2015
21 1136 Tue, 18 August 2015 00:30
By: Michel Cadot
  Need a Stored Procedure ( 1 2 3)
By: vasudevaviswa on Wed, 05 August 2015
86 4079 Mon, 17 August 2015 11:07
By: vasudevaviswa
  Need a Query to transpose rows to columns dynamically
By: yashaswini.gopalan on Wed, 12 August 2015
20 1427 Mon, 17 August 2015 01:26
By: Michel Cadot
  Need a Help on SQL query
By: ajay696 on Fri, 14 August 2015
7 672 Sat, 15 August 2015 09:37
By: EdStevens
  LEFT & Right functions to carve out data from a field
By: Johnseito on Tue, 11 August 2015
15 945 Fri, 14 August 2015 15:17
By: Bill B
  rownum and order by
Oracle 12
By: mats-larsson@iname.com on Thu, 13 August 2015
5 685 Fri, 14 August 2015 10:24
By: Michel Cadot
  Execute stored procedure after interval
Oracle 11g
By: christian.delbianco on Fri, 14 August 2015
1 468 Fri, 14 August 2015 02:43
By: Michel Cadot
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: Sat May 28 17:23:44 CDT 2016

Total time taken to generate the page: 0.16650 seconds