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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 41488 Mon, 05 September 2011 02:20
By: Littlefoot
  Calling Shell script from pl/sql procedure
11g R2, Linux(unix)
By: srinivas.k2005 on Thu, 30 October 2014
2 246 Thu, 30 October 2014 11:39
By: Michel Cadot
  Transforming rows to colums
Oracle, 10g
By: MeRamki on Thu, 30 October 2014
10 213 Thu, 30 October 2014 09:00
By: sandeep_orafaq
  Time Difference Between two Time
By: Nasir.azeem on Thu, 30 October 2014
6 113 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 70 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 436 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 764 Thu, 30 October 2014 05:15
By: SunilJdh
  XMLTYPE procedure
oracle 11g
By: alagpereira on Thu, 30 October 2014
9 144 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 114 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 183 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 1014 Wed, 29 October 2014 06:21
By: quirks
  replace string with hyphens
Oracle 10g
By: m.abdulhaq on Wed, 29 October 2014
8 224 Wed, 29 October 2014 06:06
By: Lalit Kumar B
  dblink - stored proc
By: lijjumathew on Mon, 27 October 2014
3 215 Tue, 28 October 2014 15:08
By: Bill B
  Loading Multi line columns using external table
Oracle 11g,OEL
By: jois on Sun, 26 October 2014
4 341 Tue, 28 October 2014 15:04
By: Bill B
  Create partitioned table
By: Malakay79 on Mon, 27 October 2014
10 497 Tue, 28 October 2014 15:02
By: Bill B
  Hierarchy problem
11.2.0.3
By: Amine on Mon, 27 October 2014
4 194 Tue, 28 October 2014 07:50
By: sandeep_orafaq
  Sequence ora-8002 error for every connection.
Oracle 12, Linux
By: pradies on Tue, 28 October 2014
2 167 Tue, 28 October 2014 03:32
By: Michel Cadot
  One Single Stored Procedure to fetch data using multiple complex queries
Oracle
By: contactsenthils@yahoo.com on Tue, 28 October 2014
1 168 Tue, 28 October 2014 02:13
By: John Watson
  SQL Query Optimization
Oracle 11g
By: raj_te on Fri, 17 October 2014
27 818 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 446 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 189 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 409 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 278 Fri, 24 October 2014 09:45
By: Michel Cadot
icon8.gif Insert Hangs
Oracle 10.0.2
By: nnr420 on Thu, 09 October 2014
24 756 Fri, 24 October 2014 03:11
By: Michel Cadot
  SET Autocommit XXXX
oracle 11g Release 2, Linux
By: azeem87 on Wed, 22 October 2014
2 170 Wed, 22 October 2014 14:50
By: azeem87
  FractionalAgents
Oracle 11G
By: samrams on Wed, 22 October 2014
3 199 Wed, 22 October 2014 12:35
By: Bill B
  need sql query
11g
By: mvrkr44 on Wed, 22 October 2014
3 237 Wed, 22 October 2014 10:31
By: John Watson
  problem with case statement
Oracle 10g
By: bobghw on Mon, 20 October 2014
15 475 Tue, 21 October 2014 14:42
By: Michel Cadot
  CREATE TABLE AS vs CREATE TABLE then INSERT
PL/SQL Developer 10.0.5.1710
By: techiesue83 on Mon, 20 October 2014
13 529 Tue, 21 October 2014 13:30
By: knw15pwr
  What is wrong with this trigger?
Oracle, 10g, windows
By: wzfoto on Fri, 17 October 2014
4 359 Mon, 20 October 2014 08:50
By: wzfoto
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
By: mist598 on Wed, 15 October 2014
13 609 Mon, 20 October 2014 00:05
By: Michel Cadot
  How to Find Duplicate Groups (group of records) in Oracle
Oracle 11g
By: dhakanes@gmail.com on Fri, 26 September 2014
30 1322 Sun, 19 October 2014 19:14
By: Solomon Yakobson
  to_date error
By: irfankundi786@yahoo.com on Sat, 18 October 2014
4 559 Sun, 19 October 2014 07:39
By: Lalit Kumar B
  How to calculate time variation between same day times.
Oracle 10g R2, Windows Server 2008 64 bit
By: mdsirajoddin on Wed, 15 October 2014
6 483 Sat, 18 October 2014 13:43
By: Lalit Kumar B
  Generating Numbers between given ranges
Oracle
By: manubatham20 on Fri, 17 October 2014
8 321 Fri, 17 October 2014 15:05
By: BlackSwan
  Need query
Oracle Database 11g Enterprise Edition Release
By: akash.nathile on Thu, 16 October 2014
7 349 Fri, 17 October 2014 08:54
By: Bill B
  How to calculate age between timestamp ?
By: tondapi on Fri, 17 October 2014
3 246 Fri, 17 October 2014 06:57
By: Michel Cadot
  substring instr query
SQL Oracle
By: incrediblek on Fri, 17 October 2014
2 261 Fri, 17 October 2014 04:46
By: Lalit Kumar B
  oracle
By: shwetha naren on Thu, 16 October 2014
1 188 Thu, 16 October 2014 15:00
By: Michel Cadot
icon1.gif Need a hand finding the script
Oracle 9i
By: dmellobruce1987 on Thu, 16 October 2014
2 203 Thu, 16 October 2014 13:12
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: Thu Oct 30 13:38:53 CDT 2014

Total time taken to generate the page: 0.08184 seconds