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
  Transpose columns
Oracle 11g
By: rohit_shinez on Thu, 23 July 2015
1 580 Fri, 24 July 2015 10:40
By: LKBrwn_DBA
  SUM & Cursor
Oracle Database 11.2.0.1; Centos
By: nqtrung on Fri, 24 July 2015
4 306 Fri, 24 July 2015 01:57
By: nqtrung
  how to trapping error in SQL using SYS.DBMS_XMLGEN
oracle 11g redhat
By: Freewilly3d on Thu, 23 July 2015
4 231 Thu, 23 July 2015 10:55
By: Lalit Kumar B
  how to clear the output data using utl_file?
By: mist598 on Tue, 21 July 2015
12 515 Thu, 23 July 2015 05:43
By: mist598
  Like in Order by
Oracle 11g
By: Xandot on Tue, 21 July 2015
7 311 Wed, 22 July 2015 13:59
By: Bill B
  Covert unique string to unique number
Oracle 10
By: brown_zzz on Wed, 22 July 2015
4 245 Wed, 22 July 2015 12:42
By: John Watson
  Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error.
Oracle 11g : bug
By: victoryhendry on Tue, 21 July 2015
5 317 Wed, 22 July 2015 05:01
By: gazzag
  all_scheduler_job_run_details session_id column
Oracle 11g
By: dag1ngapr1nce on Tue, 21 July 2015
15 344 Tue, 21 July 2015 09:27
By: dag1ngapr1nce
  German Character Set
Oracle 11.2.0.1, RHEL
By: suddhasatwa_oracle on Tue, 21 July 2015
2 227 Tue, 21 July 2015 08:26
By: mnitu
  Creating SQL String
Oracle 11g
By: Xandot on Mon, 20 July 2015
8 364 Tue, 21 July 2015 07:52
By: Michel Cadot
  Issue with Number Conversion !!
Oracle 11.2.0.1, RHEL
By: suddhasatwa_oracle on Mon, 06 July 2015
5 389 Tue, 21 July 2015 04:02
By: suddhasatwa_oracle
  Bulk collect limit on what basis we will keep
By: sasank54 on Mon, 20 July 2015
2 287 Tue, 21 July 2015 02:06
By: Michel Cadot
  linking gv$sql and gv$session
11g
By: dag1ngapr1nce on Thu, 16 July 2015
14 590 Mon, 20 July 2015 08:46
By: dag1ngapr1nce
  Error with Delete Trigger
Oracle
By: mattfriend on Sun, 19 July 2015
7 380 Mon, 20 July 2015 07:29
By: mattfriend
  How to Split the Records
Oracle 10g
By: rahulsf on Mon, 20 July 2015
3 260 Mon, 20 July 2015 04:53
By: Michel Cadot
  procedure error ger end of file
By: naga_raju on Sat, 18 July 2015
2 448 Sat, 18 July 2015 05:09
By: flyboy
  copy one table to another table
hp unix
By: arun888 on Fri, 12 June 2015
29 1937 Sat, 18 July 2015 02:39
By: pablolee
  25% lowest sal
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Wed, 15 July 2015
15 814 Fri, 17 July 2015 17:05
By: shumail
icon5.gif Wrong results with combination of Boolean, Left Join and To_Char
Oracle 12c, Windows Server 2012
By: RFoersterj on Wed, 08 July 2015
8 763 Fri, 17 July 2015 12:11
By: RFoersterj
  How to retrieve parent and child in different columns when they exist in a single column.
Db2 9.7
By: ankita.anand on Thu, 16 July 2015
16 529 Thu, 16 July 2015 08:26
By: ankita.anand
  Extraction from BLOB data type
Oracle 11g, Linux
By: ANILKUYI on Thu, 16 July 2015
1 302 Thu, 16 July 2015 01:17
By: Lalit Kumar B
  match/merge steps
win7 32 bit / owb 11g r2
By: freestyle on Wed, 08 July 2015
25 1110 Wed, 15 July 2015 06:18
By: freestyle
  Merge using row order
11.2.0.1.0
By: OraFerro on Tue, 14 July 2015
3 450 Wed, 15 July 2015 00:02
By: Michel Cadot
  Same serial for a group
Oracle 11g
By: vspn on Mon, 06 July 2015
30 1382 Tue, 14 July 2015 23:59
By: Michel Cadot
  Disabling unique constraints and data warehousing query
By: GusGF on Tue, 14 July 2015
5 360 Tue, 14 July 2015 05:10
By: GusGF
  Rowcount
Oracle 11g
By: thiruvari on Mon, 13 July 2015
9 523 Tue, 14 July 2015 04:48
By: Michel Cadot
  Select Query based on closed / reopened flag
By: simramkumar on Mon, 13 July 2015
5 339 Mon, 13 July 2015 04:50
By: Michel Cadot
  To tune a PL/SQL block
12c, 11g
By: 13478 on Sun, 12 July 2015
6 473 Mon, 13 July 2015 03:27
By: cookiemonster
  Variable in PLSQL
PLSQL Version 9
By: rbs100 on Sun, 12 July 2015
2 350 Sun, 12 July 2015 09:29
By: BlackSwan
  Swift message insert script
oracle 11g
By: Nusrat on Mon, 06 July 2015
10 913 Sun, 12 July 2015 02:22
By: Nusrat
  Default Value
11g database
By: cool06prashant on Fri, 10 July 2015
3 396 Sat, 11 July 2015 00:36
By: Michel Cadot
  ORA-2014 on RLS-enabled table with double FGA policy
RDBMS 11.2.0.3, Windows 2008 R2, 64-bit
By: Alien on Fri, 10 July 2015
0 454 Fri, 10 July 2015 14:43
By: Alien
  Interesting explain plan output/puzzle
11.2.0.4.0
By: Roachcoach on Mon, 06 July 2015
8 2466 Fri, 10 July 2015 14:27
By: Alien
  Get data from various partitions with having one extra column
Oracle, Oracle Database 11g Express Edition Release 11.2.0.2.0 ,Win 7 Pro
By: shumail on Wed, 08 July 2015
12 614 Thu, 09 July 2015 05:18
By: pablolee
  Partition table - High_Value in DD-MON-YYYY format
Oracle 11.2.0.3, Linux x86 64
By: hitesh.bhatt on Thu, 09 July 2015
3 470 Thu, 09 July 2015 05:17
By: Michel Cadot
  How to use computed result of one row in the next row for inserting in table
Oracle 11g
By: raman.virk on Thu, 09 July 2015
0 534 Thu, 09 July 2015 02:33
By: raman.virk
  How to update substring using sql
oracle 11g
By: gorants on Wed, 08 July 2015
6 463 Wed, 08 July 2015 12:07
By: BlackSwan
  Extracting the Numeric values from a column in oracle
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: msinha8 on Tue, 07 July 2015
2 317 Tue, 07 July 2015 08:53
By: msinha8
  PL/SQL Cursor
Oracle Database 12.1.0.2; Centos
By: nqtrung on Tue, 07 July 2015
12 516 Tue, 07 July 2015 03:57
By: pablolee
  SQL query help
oracle 11g
By: gorants on Mon, 06 July 2015
8 488 Tue, 07 July 2015 00:05
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: Wed Sep 02 10:09:58 CDT 2015

Total time taken to generate the page: 0.13124 seconds