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
  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 436 Mon, 31 August 2015 10:30
By: BlackSwan
  MERGE
db 12.1.0.2
By: John Watson on Fri, 28 August 2015
2 574 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 670 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 560 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 1146 Thu, 27 August 2015 09:35
By: manubatham20
  Query
9i
By: glmjoy on Wed, 26 August 2015
4 527 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 750 Wed, 26 August 2015 06:20
By: EdStevens
  Table partition
oracle
By: sanodani on Mon, 24 August 2015
23 1150 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 907 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 876 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 1366 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 934 Fri, 21 August 2015 10:36
By: Michel Cadot
  Creating String
Oracle 11g
By: Xandot on Fri, 31 July 2015
21 1510 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 1311 Thu, 20 August 2015 03:06
By: Michel Cadot
  Merge String
Oracle 11g
By: Xandot on Thu, 20 August 2015
4 613 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 734 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 1814 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 641 Tue, 18 August 2015 06:44
By: Michel Cadot
  Hierarchy flattening and repetition
By: loosecontrol on Tue, 18 August 2015
3 460 Tue, 18 August 2015 05:23
By: Michel Cadot
  Exact String Match in Instr
Oracle 11g
By: Xandot on Sun, 16 August 2015
21 1208 Tue, 18 August 2015 00:30
By: Michel Cadot
  Need a Stored Procedure ( 1 2 3)
By: vasudevaviswa on Wed, 05 August 2015
86 4178 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 1504 Mon, 17 August 2015 01:26
By: Michel Cadot
  Need a Help on SQL query
By: ajay696 on Fri, 14 August 2015
7 739 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 1021 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 768 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 506 Fri, 14 August 2015 02:43
By: Michel Cadot
icon5.gif "Merge" Values in one field with case?
Oracle 11.2 on Windows 2008R2
By: forumwurm on Thu, 13 August 2015
9 675 Thu, 13 August 2015 07:36
By: cookiemonster
  insert incremented value
plsql
By: sanodani on Thu, 13 August 2015
4 580 Thu, 13 August 2015 06:34
By: sanodani
  Cursor Query help
Oracle
By: GeetikaLearn on Mon, 10 August 2015
6 834 Wed, 12 August 2015 12:24
By: GeetikaLearn
  SQL join
By: sanodani on Tue, 11 August 2015
5 637 Wed, 12 August 2015 04:59
By: Lalit Kumar B
  Transpose of rows to Columns & Dynamically Adding the Columns (merged)
By: Harsha20 on Tue, 11 August 2015
2 539 Tue, 11 August 2015 10:04
By: Michel Cadot
  union
sql
By: palpali on Tue, 11 August 2015
5 499 Tue, 11 August 2015 07:06
By: pablolee
  Oracle analytic query help
Oracle 10g R10.0.2
By: parmarjm on Mon, 10 August 2015
3 408 Mon, 10 August 2015 13:56
By: pablolee
  Need PL/SQL Script
12.1.3
By: vharish006 on Mon, 10 August 2015
5 518 Mon, 10 August 2015 13:56
By: vharish006
  calulating target and actual hrs
sql
By: palpali on Tue, 04 August 2015
16 937 Mon, 10 August 2015 00:32
By: palpali
  How to get value of table
oracle 11g
By: realbassist on Thu, 06 August 2015
18 1281 Fri, 07 August 2015 04:02
By: Lalit Kumar B
  Filtering data by aggregated columns calculated in a subquery.
By: mcrum1 on Thu, 06 August 2015
2 526 Fri, 07 August 2015 01:21
By: Littlefoot
icon3.gif help with pattern match REGEXP etc
Oracle 11, 12
By: namitanamburi on Wed, 05 August 2015
4 535 Thu, 06 August 2015 19:09
By: namitanamburi
  Update multiple columns in Case
Oracle 11g
By: Xandot on Thu, 06 August 2015
2 596 Thu, 06 August 2015 11:39
By: cookiemonster
  Convert rows into columns
oracle 10g
By: nciteamo on Thu, 06 August 2015
2 561 Thu, 06 August 2015 05:27
By: nciteamo
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 Aug 27 08:32:32 CDT 2016

Total time taken to generate the page: 0.12430 seconds