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
  SQL Query
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production, Centos 5
By: Raakh on Tue, 04 November 2014
27 799 Fri, 07 November 2014 07:54
By: Raakh
  How to get the result for my query
By: venki459 on Thu, 06 November 2014
9 356 Fri, 07 November 2014 06:35
By: EdStevens
  need help in query
oracle 11i
By: moulivasireddy on Fri, 07 November 2014
3 247 Fri, 07 November 2014 03:30
By: Michel Cadot
  Table Creation using WITH Clause
oracle 11g R2 WIN 7
By: 9390512774 on Thu, 06 November 2014
4 265 Fri, 07 November 2014 03:19
By: sandeep_orafaq
  What is the limitation in number of parameters in oracle stored procedure and function?
By: Jothish on Fri, 07 November 2014
1 182 Fri, 07 November 2014 02:15
By: John Watson
  split clob into rows
Oracle 11g
By: mape on Thu, 06 November 2014
5 261 Thu, 06 November 2014 12:43
By: mape
icon5.gif ORA-01427: single-row subquery returns more than one row
By: hunterakishou on Thu, 06 November 2014
4 294 Thu, 06 November 2014 12:19
By: hunterakishou
  how do associate array working
By: mist598 on Thu, 06 November 2014
4 356 Thu, 06 November 2014 10:10
By: Solomon Yakobson
  insert data
oracle 11g
By: thelearner on Wed, 05 November 2014
13 464 Thu, 06 November 2014 07:54
By: Lalit Kumar B
  how to convert code of sql server into oracle
By: aaditya321 on Wed, 05 November 2014
6 385 Wed, 05 November 2014 16:07
By: Michel Cadot
  One Single Stored Procedure to fetch data using multiple complex queries
Oracle
By: contactsenthils@yahoo.com on Tue, 28 October 2014
2 382 Wed, 05 November 2014 10:58
By: raj_te
  trigger on update
By: mist598 on Wed, 05 November 2014
6 344 Wed, 05 November 2014 08:40
By: Michel Cadot
  how to handle zero divide error in formula calculation
By: venki459 on Sun, 02 November 2014
16 912 Wed, 05 November 2014 01:08
By: m.abdulhaq
  Data migration
By: NewToOracle10g on Sun, 02 November 2014
11 546 Wed, 05 November 2014 00:46
By: Michel Cadot
  Change the Data type of non empty column
Oracle 11g
By: Xandot on Tue, 04 November 2014
7 464 Tue, 04 November 2014 08:06
By: Lalit Kumar B
  Modify unique index to non-unique index without dropping index
Oracle 11.2.0.3.0 - 64bit
By: avineshr on Sun, 02 November 2014
5 449 Sun, 02 November 2014 22:45
By: Kevin Meade
  ORA-12012 ORA-01031 ORA-06512
oracle 11.2.0.4
By: ganesh_gvn on Sat, 01 November 2014
6 410 Sun, 02 November 2014 22:44
By: Kevin Meade
  Hierarchy problem
11.2.0.3
By: Amine on Mon, 27 October 2014
6 531 Sun, 02 November 2014 01:22
By: Michel Cadot
  Please clarify the LOCK doubts
Oracle 11g
By: ramya_162 on Sat, 01 November 2014
2 400 Sat, 01 November 2014 07:08
By: EdStevens
  FOR UPDATE OF not working
oracle 10g
By: vivek_rol on Fri, 31 October 2014
14 481 Fri, 31 October 2014 11:01
By: Michel Cadot
  Transforming rows to colums
Oracle, 10g
By: MeRamki on Thu, 30 October 2014
11 452 Fri, 31 October 2014 04:36
By: sandeep_orafaq
  Calling Shell script from pl/sql procedure
11g R2, Linux(unix)
By: srinivas.k2005 on Thu, 30 October 2014
2 666 Thu, 30 October 2014 11:39
By: Michel Cadot
  Time Difference Between two Time
By: Nasir.azeem on Thu, 30 October 2014
6 293 Thu, 30 October 2014 06:30
By: Nasir.azeem
  How to use PL/SQL Collection Type in TABLE function(how to convert PL/SQL type to SQL Object Type)
Oracle 10gR2
By: balaji.chelladurai on Thu, 30 October 2014
2 252 Thu, 30 October 2014 06:07
By: Michel Cadot
icon5.gif Oracle Function to get ISO Country Code
11g
By: suddhasatwa_oracle on Tue, 28 October 2014
17 726 Thu, 30 October 2014 06:04
By: Michel Cadot
icon7.gif Oracle GTT vs SQL Temporary Table
By: SunilJdh on Mon, 27 October 2014
25 1038 Thu, 30 October 2014 05:15
By: SunilJdh
  XMLTYPE procedure
oracle 11g
By: alagpereira on Thu, 30 October 2014
9 313 Thu, 30 October 2014 03:47
By: Michel Cadot
  Error about Oracle External Table
Oracle Database 11g Release 11.2.0.1.0 - Production
By: mokarem on Wed, 29 October 2014
2 259 Thu, 30 October 2014 00:00
By: mokarem
  ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
xp
By: arora.charan on Wed, 29 October 2014
5 507 Wed, 29 October 2014 09:47
By: sandeep_orafaq
  when "group by" isn't enough...
Oracle 11g
By: quirks on Tue, 28 October 2014
23 1204 Wed, 29 October 2014 06:21
By: quirks
  replace string with hyphens
Oracle 10g
By: m.abdulhaq on Wed, 29 October 2014
8 370 Wed, 29 October 2014 06:06
By: Lalit Kumar B
  dblink - stored proc
By: lijjumathew on Mon, 27 October 2014
3 396 Tue, 28 October 2014 15:08
By: Bill B
  Loading Multi line columns using external table
Oracle 11g,OEL
By: Jay1 on Sun, 26 October 2014
4 513 Tue, 28 October 2014 15:04
By: Bill B
  Create partitioned table
By: Malakay79 on Mon, 27 October 2014
10 701 Tue, 28 October 2014 15:02
By: Bill B
  Sequence ora-8002 error for every connection.
Oracle 12, Linux
By: pradies on Tue, 28 October 2014
2 337 Tue, 28 October 2014 03:32
By: Michel Cadot
  SQL Query Optimization
Oracle 11g
By: raj_te on Fri, 17 October 2014
27 1014 Mon, 27 October 2014 10:46
By: raj_te
  Merging Data from three sources and identifying duplicates
PL/SQL
By: mohammed.mca09@gmail.com on Sun, 26 October 2014
6 593 Sun, 26 October 2014 22:03
By: Barbara Boehmer
  Merging two tables based on child table FK
11.2.0.1.0
By: OraFerro on Sun, 26 October 2014
1 328 Sun, 26 October 2014 05:34
By: Solomon Yakobson
  REMOVE DUPLICATES IN ROWS TO COLUMN
Oracle 10G r2
By: mmohsinaziz on Thu, 23 October 2014
11 600 Sat, 25 October 2014 10:35
By: Lalit Kumar B
  how to write return in the function
By: mist598 on Fri, 24 October 2014
7 428 Fri, 24 October 2014 09:45
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 Mar 04 05:38:33 CST 2015

Total time taken to generate the page: 0.08523 seconds