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
3 253 Thu, 30 July 2015 05:35
By: Lalit Kumar B
  Update table procedure through pl sql using double loop
Oracle
By: freestyle on Wed, 29 July 2015
8 292 Thu, 30 July 2015 03:00
By: freestyle
  Need a query to get the ouput in an expected format
By: nyaduguru on Wed, 29 July 2015
5 198 Thu, 30 July 2015 02:11
By: Lalit Kumar B
  Joining
By: Nasir.azeem on Wed, 29 July 2015
3 251 Wed, 29 July 2015 09:40
By: LKBrwn_DBA
  Max on Sum
By: zoe2003 on Mon, 20 April 2015
18 1043 Wed, 29 July 2015 02:45
By: cookiemonster
  oracle procedure
oracle 10g ( 1 2)
By: arun888 on Mon, 27 July 2015
58 968 Tue, 28 July 2015 12:37
By: Michel Cadot
  problem in record type
oracle 11g
By: somu1984 on Tue, 28 July 2015
4 263 Tue, 28 July 2015 01:21
By: Michel Cadot
  concatenate the values in the o/p
By: mist598 on Mon, 27 July 2015
13 371 Mon, 27 July 2015 06:09
By: Lalit Kumar B
  query taking lot of time to execute
ORACLE 11g
By: manoj12 on Mon, 20 July 2015
18 778 Mon, 27 July 2015 05:42
By: pablolee
  Include if else in sql statement
By: hypesslearner on Mon, 20 July 2015
21 661 Mon, 27 July 2015 03:06
By: Michel Cadot
  Update to_char(date,'YYYY')
oracle 10g
By: nciteamo on Sun, 26 July 2015
3 228 Mon, 27 July 2015 02:06
By: nciteamo
  Split column to rows in Oracle Sql
By: vspn on Wed, 22 July 2015
10 487 Mon, 27 July 2015 01:25
By: Michel Cadot
  History Tables Search Criteria
windows
By: oraranjangmailcom on Thu, 23 July 2015
7 405 Mon, 27 July 2015 00:19
By: Michel Cadot
  NoSQL vs. Oracle
Oracle 11g xe
By: Eric Langager on Sun, 26 July 2015
2 420 Sun, 26 July 2015 11:56
By: Michel Cadot
  NUMERIC DENOMINATION
SQL NAV 6
By: rukku2015 on Sun, 26 July 2015
1 214 Sun, 26 July 2015 10:32
By: BlackSwan
  ORA-01732: data manipulation operation not legal on this view
By: Ashu_26 on Sun, 26 July 2015
6 303 Sun, 26 July 2015 02:48
By: Michel Cadot
  Rewriting a sql with NOT to avoid the NOT and OR clause
Oracle 11.2.0.5
By: orausern on Sat, 25 July 2015
3 247 Sat, 25 July 2015 14:27
By: Michel Cadot
  Transpose columns
Oracle 11g
By: rohit_shinez on Thu, 23 July 2015
1 261 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 244 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 175 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 450 Thu, 23 July 2015 05:43
By: mist598
  Like in Order by
Oracle 11g
By: Xandot on Tue, 21 July 2015
7 252 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 197 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 268 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 292 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 187 Tue, 21 July 2015 08:26
By: mnitu
  Creating SQL String
Oracle 11g
By: Xandot on Mon, 20 July 2015
8 314 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 352 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 223 Tue, 21 July 2015 02:06
By: Michel Cadot
  linking gv$sql and gv$session
11g
By: dag1ngapr1nce on Thu, 16 July 2015
14 540 Mon, 20 July 2015 08:46
By: dag1ngapr1nce
  Error with Delete Trigger
Oracle
By: mattfriend on Sun, 19 July 2015
7 327 Mon, 20 July 2015 07:29
By: mattfriend
  How to Split the Records
Oracle 10g
By: rahulsf on Mon, 20 July 2015
3 217 Mon, 20 July 2015 04:53
By: Michel Cadot
  PL/SQL: ORA-00911: invalid character
Oracle 10g
By: thiruvari on Sat, 18 July 2015
2 328 Sat, 18 July 2015 13:16
By: Michel Cadot
  procedure error ger end of file
By: naga_raju on Sat, 18 July 2015
2 381 Sat, 18 July 2015 05:09
By: flyboy
  copy one table to another table
hp unix
By: arun888 on Fri, 12 June 2015
29 1848 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 755 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 716 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 483 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 262 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 1045 Wed, 15 July 2015 06:18
By: freestyle
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: Thu Jul 30 07:50:39 CDT 2015

Total time taken to generate the page: 0.42726 seconds