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
  sticky: How to use code tags and make your code easier to read
By: Littlefoot on Mon, 05 September 2011
0 557 Mon, 05 September 2011 02:20
By: Littlefoot
  Top 2 Salary from Each Dept without using Analytic Function
Oracle 11g,windows 7
By: b.balabtech@yahoo.com on Wed, 02 September 2015
12 170 Wed, 02 September 2015 11:43
By: John Watson
  migrate View from SQL to Oracle
11.g
By: oracle1987 on Wed, 02 September 2015
7 172 Wed, 02 September 2015 08:35
By: Michel Cadot
CE_RECONCILED_TRANSACTIONS_V returns no rows in R12 has been moved to Client Tools by the moderator.
  Data migration fromOracle to SFDC
By: vasudevaviswa on Tue, 01 September 2015
3 168 Tue, 01 September 2015 18:20
By: BlackSwan
  Table Lock
Oracle 11g
By: stsivaraj on Tue, 01 September 2015
3 218 Tue, 01 September 2015 07:54
By: Michel Cadot
  innerjoin on variable date range
By: mattz on Mon, 31 August 2015
3 325 Tue, 01 September 2015 06:39
By: pablolee
  Order by in Listagg
Oracle 11g
By: Xandot on Tue, 01 September 2015
3 235 Tue, 01 September 2015 04:13
By: Xandot
  Oracle pair combination with two column values in a table
Oracle 11g
By: swca on Sat, 29 August 2015
14 819 Tue, 01 September 2015 01:14
By: Michel Cadot
  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 189 Mon, 31 August 2015 10:30
By: BlackSwan
  ora-00900 invalid sql statement while using open cursor for variable
By: bhardkap on Fri, 28 August 2015
6 556 Sat, 29 August 2015 04:03
By: Michel Cadot
  MERGE
db 12.1.0.2
By: John Watson on Fri, 28 August 2015
2 279 Fri, 28 August 2015 13:59
By: John Watson
  to derive previous dates and ignore first date
Oracle 11g ( 1 2)
By: rohit_shinez on Fri, 14 August 2015
61 2668 Fri, 28 August 2015 10:58
By: rohit_shinez
  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 391 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 230 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 783 Thu, 27 August 2015 09:35
By: manubatham20
  Query
9i
By: glmjoy on Wed, 26 August 2015
4 305 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 446 Wed, 26 August 2015 06:20
By: EdStevens
  Table partition
oracle
By: sanodani on Mon, 24 August 2015
23 712 Wed, 26 August 2015 02:31
By: cookiemonster
  Display the range wise column names
11.2.0.3
By: grpatwari on Fri, 21 August 2015
7 563 Tue, 25 August 2015 00:12
By: Michel Cadot
  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 488 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 510 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 956 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 660 Fri, 21 August 2015 10:36
By: Michel Cadot
  Creating String
Oracle 11g
By: Xandot on Fri, 31 July 2015
21 1279 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 651 Thu, 20 August 2015 03:06
By: Michel Cadot
  Merge String
Oracle 11g
By: Xandot on Thu, 20 August 2015
4 315 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: nepolian on Wed, 19 August 2015
10 435 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 1412 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 413 Tue, 18 August 2015 06:44
By: Michel Cadot
  Hierarchy flattening and repetition
By: loosecontrol on Tue, 18 August 2015
3 246 Tue, 18 August 2015 05:23
By: Michel Cadot
  Exact String Match in Instr
Oracle 11g
By: Xandot on Sun, 16 August 2015
21 826 Tue, 18 August 2015 00:30
By: Michel Cadot
  Need a Stored Procedure ( 1 2 3)
By: vasudevaviswa on Wed, 05 August 2015
86 3634 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 1121 Mon, 17 August 2015 01:26
By: Michel Cadot
  Need a Help on SQL query
By: ajay696 on Fri, 14 August 2015
7 431 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 689 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 432 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 279 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 347 Thu, 13 August 2015 07:36
By: cookiemonster
  insert incremented value
plsql
By: sanodani on Thu, 13 August 2015
4 323 Thu, 13 August 2015 06:34
By: sanodani
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 Sep 02 12:42:02 CDT 2015

Total time taken to generate the page: 0.12516 seconds