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
  file input and output
Oracle 11g
By: saurau on Tue, 15 October 2013
7 457 Tue, 15 October 2013 02:47
By: Lalit Kumar B
  Dynamic column in SQL Output
Oracle 11.2.0.2
By: ridhi_sundar on Tue, 15 October 2013
3 369 Tue, 15 October 2013 01:43
By: Michel Cadot
  Error ORA-04091
By: andreacaffy on Mon, 14 October 2013
7 350 Mon, 14 October 2013 10:56
By: Michel Cadot
  Procedure Calling Methods
PL/SQL Toad Oracle 10g
By: jgjeetu on Mon, 14 October 2013
6 467 Mon, 14 October 2013 09:07
By: Michel Cadot
  calling a function in another function to insert a dml record is failing
By: 912345 on Tue, 08 October 2013
27 1336 Sun, 13 October 2013 23:45
By: BlackSwan
  dynamic cursor
oracle 11.2.0.3 sun solaris 10.5
By: guddu_12 on Fri, 11 October 2013
7 539 Sun, 13 October 2013 06:20
By: Michel Cadot
  Why the second query is more efficient?
By: zhaoquer on Sat, 12 October 2013
9 587 Sat, 12 October 2013 10:40
By: Littlefoot
  Remove string duplicates
11.2
By: jj_white on Fri, 11 October 2013
14 1188 Sat, 12 October 2013 07:59
By: Solomon Yakobson
  while running a Stored procedure getting error
Sql developer 3.2
By: ram7 on Sat, 12 October 2013
5 516 Sat, 12 October 2013 03:29
By: Michel Cadot
  Inserting multiple records with CLOB using select
Oracle PL/SQL 11G
By: cdavis@hsph.harvard.edu on Fri, 11 October 2013
2 294 Sat, 12 October 2013 01:18
By: Michel Cadot
  Performance with Materialized view fast refresh
oracle 11.2.0.3, Linux
By: sspn2010 on Thu, 10 October 2013
15 754 Fri, 11 October 2013 19:04
By: BlackSwan
  How to get this SQL output :-
Sql Plus 10g
By: jgjeetu on Wed, 09 October 2013
18 681 Fri, 11 October 2013 13:18
By: jgjeetu
  *Action: Get the result as a lob instead
Oracle Database 11g Enterprise Edition 11.2.0.3.0 64bit Production
By: andre159753 on Fri, 11 October 2013
3 399 Fri, 11 October 2013 08:49
By: Michel Cadot
  Rank based on multiple conditions
Oracle 11.2.0.3, Linux
By: sspn2010 on Fri, 04 October 2013
3 527 Thu, 10 October 2013 23:46
By: sspn2010
  ORA:01427: single row sub query returns more than one record
Oracle 11g
By: jayant.tripathi on Thu, 10 October 2013
2 416 Thu, 10 October 2013 16:23
By: John Watson
  Creating views - percentages and multiple tables. Newbie
By: bmartin1uk on Thu, 10 October 2013
3 516 Thu, 10 October 2013 14:05
By: Michel Cadot
  Bulk insert dummy data into table
oracle 10g
By: debasisp on Thu, 10 October 2013
5 386 Thu, 10 October 2013 12:50
By: BlackSwan
  Writing Turkey characters to text file
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production, TNS for Linux: Version 11.2.0.3.0 - Production
By: Aju on Tue, 08 October 2013
13 1219 Thu, 10 October 2013 11:08
By: Aju
  Package related Query
PL/SQL Toad Oracle 10g
By: jgjeetu on Thu, 10 October 2013
7 244 Thu, 10 October 2013 09:58
By: jgjeetu
  truncate partition
oracle 11.2.0.3 sun solaris 10.5
By: guddu_12 on Thu, 10 October 2013
12 331 Thu, 10 October 2013 09:51
By: BlackSwan
  date conversion format issue
oracle 11.2.0.3 sun solaris 10.5
By: guddu_12 on Thu, 10 October 2013
21 881 Thu, 10 October 2013 09:41
By: Michel Cadot
  How to get this SQL output (2):-
Sql Plus 10g
By: jgjeetu on Wed, 09 October 2013
9 421 Thu, 10 October 2013 07:41
By: jgjeetu
  Dynamic Table Partitioning
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Thu, 10 October 2013
14 806 Thu, 10 October 2013 07:16
By: Michel Cadot
  Use ANSI standard JOIN syntax
By: nataliafoster26 on Wed, 09 October 2013
15 893 Thu, 10 October 2013 03:42
By: Lalit Kumar B
  PL/SQL Block Structure
By: nataliafoster26 on Wed, 09 October 2013
15 732 Wed, 09 October 2013 23:22
By: Lalit Kumar B
  error
By: nataliafoster26 on Mon, 07 October 2013
28 1483 Wed, 09 October 2013 16:54
By: pablolee
  order by multiple columns
Oracle 11.2g windows 2008R2
By: anncao on Wed, 09 October 2013
3 546 Wed, 09 October 2013 13:39
By: Lalit Kumar B
  partition name based on data
oracle 11.2.0.3 sun solaris 10.5
By: guddu_12 on Wed, 09 October 2013
11 589 Wed, 09 October 2013 11:47
By: Lalit Kumar B
  Return a list of non standard char
11g, Win 2008R2
By: jonathanlouisallen on Wed, 09 October 2013
8 405 Wed, 09 October 2013 08:11
By: Michel Cadot
  Questions about SQL insert clause
By: Totulas on Wed, 09 October 2013
2 183 Wed, 09 October 2013 07:47
By: Michel Cadot
  Copy Bulk data in txt file
Oracle 10G, Windows XP
By: sumedh7 on Wed, 09 October 2013
12 769 Wed, 09 October 2013 05:49
By: pablolee
icon5.gif How is Oracle passing arguments to methods?
By: wakula on Tue, 08 October 2013
10 572 Wed, 09 October 2013 05:21
By: Lalit Kumar B
  how can I do it without error,keep the rowid
By: zhaoquer on Wed, 09 October 2013
6 334 Wed, 09 October 2013 01:50
By: zhaoquer
  VARRAY error in PLSQL BLOCK
11g
By: mapps0999@gmail.com on Mon, 07 October 2013
27 1301 Wed, 09 October 2013 00:23
By: Lalit Kumar B
  Dynamic SQL
Oracle 11g, XP
By: rajivn786 on Mon, 07 October 2013
11 648 Tue, 08 October 2013 15:04
By: Solomon Yakobson
  ORA-01840: input value not long enough fro date format.
Oracle 11 g
By: jayant.tripathi on Mon, 07 October 2013
18 1267 Tue, 08 October 2013 10:57
By: Michel Cadot
  SQL Top N Analysis
By: Hometown1 on Sun, 06 October 2013
12 837 Tue, 08 October 2013 09:57
By: Hometown1
  How to multiplied count in SQL
PL SQL developer
By: kristin_86 on Tue, 08 October 2013
9 613 Tue, 08 October 2013 08:30
By: BlackSwan
  ORA-01008: not all variables bound ORA-06512
By: archie1 on Thu, 10 August 2006
12 38030 Tue, 08 October 2013 08:30
By: Lalit Kumar B
  CREATE TABLE ... DEFAULT TABLESPACE FOR COLUMNS ...
110203
By: Amine on Tue, 08 October 2013
3 264 Tue, 08 October 2013 05:39
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: Sat Apr 19 11:06:09 CDT 2014

Total time taken to generate the page: 0.14832 seconds