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
  Backward accessing super type's attributes from sub type body in oracle collection (Types)
Oracle 10g
By: prabakaran.sr on Wed, 02 January 2013
3 324 Wed, 02 January 2013 04:58
By: Michel Cadot
  Oracle query error
oracle 11g
By: JSKOBS on Mon, 31 December 2012
8 408 Mon, 31 December 2012 09:36
By: flyboy
  REGEXP
11.1.0.6.0 ( 1 2)
By: muralikri on Fri, 11 November 2011
40 5600 Mon, 31 December 2012 08:19
By: ind9
  Need a little help in deriving the logic
Oracle 10.2.0.4
By: tigsav on Mon, 31 December 2012
1 279 Mon, 31 December 2012 06:42
By: Michel Cadot
  How to convert a string into numeric other than to_number
11
By: cplusplus1 on Sun, 30 December 2012
2 410 Sun, 30 December 2012 09:43
By: flyboy
  Extract Absent days from the month
Oracle 10g
By: arif_md2009 on Sat, 29 December 2012
16 832 Sun, 30 December 2012 02:18
By: arif_md2009
  Converting number column to date column
By: BeefStu on Tue, 25 December 2012
12 772 Sat, 29 December 2012 13:50
By: cookiemonster
  ORA-29283: invalid file operation
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: gp185007 on Sat, 29 December 2012
1 472 Sat, 29 December 2012 09:08
By: Michel Cadot
  Please help me on how to pass date condition Dynamically.
Oracle 11g
By: ajaykumarkona on Thu, 27 December 2012
12 620 Sat, 29 December 2012 07:35
By: flyboy
  Associative array - no data found
By: satajju on Fri, 28 December 2012
3 451 Sat, 29 December 2012 07:33
By: flyboy
  How we can run pl/sql procedure in parallel
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: msol25 on Fri, 28 December 2012
11 611 Fri, 28 December 2012 12:10
By: msol25
  Join tables on Date with MAX
Oracle 10g 10.2.0.4.0
By: isri on Tue, 18 December 2012
6 698 Fri, 28 December 2012 05:08
By: Michel Cadot
  Exception query
Oracle 10g
By: Bagheera on Thu, 27 December 2012
3 384 Fri, 28 December 2012 05:01
By: Michel Cadot
  Passing input parameter to a like variable in procedure
Oracle 11g
By: gentleman777us on Thu, 27 December 2012
3 468 Fri, 28 December 2012 04:09
By: Littlefoot
  Refcursor question
By: ora1980 on Thu, 27 December 2012
4 368 Thu, 27 December 2012 13:09
By: Michel Cadot
  DBMS_CRYPTO hash a BLOB in a union over dblink
By: ocdeveloper on Thu, 27 December 2012
1 304 Thu, 27 December 2012 10:31
By: Michel Cadot
  Problem with cursor
Oracle 9i
By: akull on Wed, 26 December 2012
9 402 Thu, 27 December 2012 09:38
By: akull
  Document contains too many nodes error message select query search all columns for a string
11
By: cplusplus1 on Thu, 27 December 2012
1 353 Thu, 27 December 2012 07:53
By: Michel Cadot
  Delete Duplicate Records using Anaytical function
By: ramya29p on Sat, 22 December 2012
19 1250 Thu, 27 December 2012 00:17
By: flyboy
  Trigger fires on deletion of uncommitted data and changes saved
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production Windows
By: Andrey_R on Wed, 26 December 2012
17 525 Wed, 26 December 2012 12:25
By: Michel Cadot
  triggers in oracle plsql
windows xp
By: nvsr on Wed, 26 December 2012
3 367 Wed, 26 December 2012 09:37
By: nvsr
  insert or update records into target table
oracle 11g
By: swapnabpnn on Fri, 21 December 2012
10 564 Wed, 26 December 2012 08:15
By: joy_division
  How to call a URL in PL/SQL
By: kanis on Wed, 13 June 2007
8 14226 Wed, 26 December 2012 05:10
By: Michel Cadot
  SQL UPDATION
oracle 10g Release 2
By: glmjoy on Wed, 26 December 2012
8 340 Wed, 26 December 2012 05:07
By: Michel Cadot
  Help in framing sql query
By: rkrish on Wed, 26 December 2012
1 314 Wed, 26 December 2012 04:32
By: Littlefoot
  date query issue
oracle 10g
By: rajmighty972 on Wed, 26 December 2012
1 299 Wed, 26 December 2012 03:12
By: Littlefoot
  SQL for Parent-Child Hierarchy
By: sanushks on Thu, 20 December 2012
11 943 Tue, 25 December 2012 23:33
By: vnithya
  Select query like operator getting wrong data
11g
By: cplusplus1 on Tue, 25 December 2012
4 476 Tue, 25 December 2012 07:13
By: Solomon Yakobson
  query no check wrong mapping
Oracle 10g
By: rajmighty972 on Mon, 24 December 2012
3 400 Mon, 24 December 2012 15:41
By: Littlefoot
  Insert into oracle table of unix script values.
Unix
By: visuora@yahoo.com on Mon, 24 December 2012
2 526 Mon, 24 December 2012 06:27
By: dariyoosh
  Transferring data from one DB to another DB
Oracle 11g
By: ajaykumarkona on Sat, 15 December 2012
31 1280 Mon, 24 December 2012 05:22
By: Michel Cadot
  Inner Join Record Count
Oracle 10g
By: vino06cse57 on Mon, 24 December 2012
3 474 Mon, 24 December 2012 02:54
By: Michel Cadot
icon5.gif pass multiple values as single input parameter into pipelined function
Oracle 11g
By: ecivgamer on Sun, 23 December 2012
2 497 Mon, 24 December 2012 02:18
By: Michel Cadot
  Oracle database to Mysql Conversion
Oracle 11g ,MySql5.2
By: zutty on Fri, 21 December 2012
1 384 Fri, 21 December 2012 22:57
By: BlackSwan
  Query with horizontal running totals
By: sql_dvlpr on Thu, 20 December 2012
3 412 Fri, 21 December 2012 13:31
By: Solomon Yakobson
  Outer Joins & Not Null check
Oracle 11g
By: arung_in on Fri, 21 December 2012
2 365 Fri, 21 December 2012 12:33
By: Solomon Yakobson
  FirstName LastName Swap
Oracle 10g
By: tgreen1 on Thu, 20 December 2012
6 493 Fri, 21 December 2012 11:11
By: tgreen1
  full outer join performance
oracle 10g,oracle 11g
By: y.michaelholding on Thu, 20 December 2012
2 571 Fri, 21 December 2012 06:25
By: tmanju
  Group by matching records
Oracle 10g
By: arif_md2009 on Wed, 19 December 2012
7 615 Fri, 21 December 2012 03:48
By: arif_md2009
  Values to columns of another table
Oracle 11g R2
By: srinivas.k2005 on Thu, 20 December 2012
6 425 Fri, 21 December 2012 02:21
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: Fri May 24 02:34:17 CDT 2013

Total time taken to generate the page: 0.14470 seconds