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
  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
  FUNCTION COMPLIATION ERROR
By: IRFANMBAIG on Tue, 08 October 2013
2 358 Tue, 08 October 2013 03:26
By: pablolee
  Queue table - error
11g
By: SKSG on Mon, 07 October 2013
15 1067 Tue, 08 October 2013 00:02
By: Michel Cadot
  duplicate row elimination
Oracle 10.2.0.4.0 on OEL 5
By: 8939513598$ on Mon, 07 October 2013
4 571 Tue, 08 October 2013 00:00
By: Michel Cadot
  Want to ZIP clob field in Oracle
10g
By: kanis on Mon, 07 October 2013
1 356 Mon, 07 October 2013 22:24
By: BlackSwan
  Case statement
SQL Developer
By: davron0 on Mon, 07 October 2013
29 1151 Mon, 07 October 2013 04:21
By: davron0
  Find the names of all stored proc invoked on execution of the main api
By: njnbat on Tue, 01 October 2013
16 779 Mon, 07 October 2013 03:55
By: cookiemonster
  Herarchical query
Oracle 11g,Linux
By: sspn2010 on Sat, 05 October 2013
4 452 Sun, 06 October 2013 13:04
By: sspn2010
  please convert this procedure to oracle
oracle 11g
By: ajaykumarkona on Sat, 05 October 2013
4 477 Sat, 05 October 2013 13:07
By: pablolee
  How to retrieve first letter of every word from string
Windows XP/ 7
By: dark_prince on Fri, 04 October 2013
17 969 Fri, 04 October 2013 22:33
By: dark_prince
  Bulk collect issue
oracle11.2.0 Linux Server(don't know version)
By: MitchM on Fri, 04 October 2013
11 668 Fri, 04 October 2013 17:16
By: BlackSwan
  Is it possible to fetch file path from a folder through PL/SQL
Windows XP, Windows 7
By: Chinmay91 on Fri, 04 October 2013
12 629 Fri, 04 October 2013 11:55
By: Michel Cadot
  Calling .sql file from .ksh file
10g Release 2
By: arunprakash647 on Fri, 04 October 2013
7 706 Fri, 04 October 2013 11:06
By: Michel Cadot
  To check hanging/not run/failed jobs
oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: gopal.biswal on Wed, 02 October 2013
4 549 Fri, 04 October 2013 10:50
By: Michel Cadot
  Loading Data from one remote Server into another Remote server Database....
By: naq_virgo on Fri, 04 October 2013
2 277 Fri, 04 October 2013 10:01
By: BlackSwan
  ORA-00904: : invalid identifier in oracle 11G
Oracle 11G Edition Release 11.2.0.1.0
By: manojkakkar@gmail.com on Tue, 24 September 2013
4 1809 Thu, 03 October 2013 17:27
By: Solomon Yakobson
  error when using return along with ref cursor
oracle 11g
By: ajaykumarkona on Thu, 03 October 2013
5 350 Thu, 03 October 2013 14:01
By: Michel Cadot
  Change Max Partitionname
Oracle, 11G,Solaris
By: nagaraju.ch on Thu, 03 October 2013
1 207 Thu, 03 October 2013 05:56
By: nagaraju.ch
  creating the materialized view for getting the hierarchy
Oracle 11g
By: veeraiahmannem on Thu, 03 October 2013
1 313 Thu, 03 October 2013 04:35
By: Littlefoot
  Executing a function from a string variable
By: lmartyn on Wed, 02 October 2013
1 288 Wed, 02 October 2013 05:46
By: Michel Cadot
  Modify Supertype without dropping Subtypes
Oracle 11g
By: wmgonzalbo on Wed, 02 October 2013
6 596 Wed, 02 October 2013 04:50
By: wmgonzalbo
  after/every 5 rows print the string "execute;" in output [SQL generates batch]
Oracle 10g
By: rc3d on Tue, 01 October 2013
9 668 Wed, 02 October 2013 02:47
By: rc3d
  CHARSET CONVERSION
Oracle 11G
By: sreedi on Tue, 01 October 2013
1 451 Wed, 02 October 2013 00:17
By: Michel Cadot
  Clob_Agg Order by
Oracle 11g, XP
By: rajivn786 on Mon, 30 September 2013
8 860 Tue, 01 October 2013 19:56
By: Solomon Yakobson
  PL/SQL for 3 different tables
Oracle 11.2.0.4
By: Ricky_1362002 on Mon, 30 September 2013
14 924 Tue, 01 October 2013 17:23
By: Ricky_1362002
  Regexp_SUBSTR on an array returning no value
Oracle version 11.2 using windows 7 and Toad 11.5.0
By: caippers on Tue, 01 October 2013
10 782 Tue, 01 October 2013 10:54
By: caippers
  Need help with UNION while selecting from dual
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: rappaj on Thu, 19 September 2013
12 679 Tue, 01 October 2013 08:31
By: rappaj
  confused about outer join
oracle 10g ,windowsxp
By: rnemkul on Mon, 30 September 2013
3 406 Tue, 01 October 2013 07:52
By: ilikesql
  .pkb to .pls
oracle 11G
By: deepak416 on Tue, 01 October 2013
2 269 Tue, 01 October 2013 07:30
By: Michel Cadot
  SQL query
By: panyamravi on Tue, 01 October 2013
8 777 Tue, 01 October 2013 05:36
By: DrabJay
  CASE statement
10g
By: pstanand on Mon, 30 September 2013
18 1357 Tue, 01 October 2013 02:41
By: pablolee
  REGEXP_SUBSTR
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: fakru.y on Mon, 30 September 2013
3 491 Mon, 30 September 2013 12:29
By: fakru.y
  NTILE Issue
By: fakru.y on Fri, 24 May 2013
3 496 Mon, 30 September 2013 12:26
By: fakru.y
  Combining rows in data file based on values in control file
By: sivapodila on Thu, 29 August 2013
2 426 Mon, 30 September 2013 12:19
By: Barbara Boehmer
  ".." Character coming instead of "." while creating an excel spreadsheet from Oracle 10g
Oracle 10g
By: peterf on Mon, 30 September 2013
3 374 Mon, 30 September 2013 09:41
By: BlackSwan
  Package variables and execution Error [merged 2 by jd]
Oracle 11g
By: plsqldev on Fri, 27 September 2013
12 774 Sat, 28 September 2013 18:17
By: BlackSwan
  Selecting the correct record from the table
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production,TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production, Windows
By: gupta27 on Thu, 26 September 2013
14 957 Sat, 28 September 2013 07:26
By: Solomon Yakobson
  complex constraint
By: raopatwariyahoocom on Fri, 27 September 2013
10 946 Sat, 28 September 2013 07:19
By: Michel Cadot
  Returning updated rows with REF CURSOR?
By: nlefk83 on Fri, 27 September 2013
4 573 Sat, 28 September 2013 07:15
By: Solomon Yakobson
  is user() a keyword in mysql
oracle 11g
By: vkanuri on Thu, 26 September 2013
5 386 Fri, 27 September 2013 12:58
By: Bill B
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: Mon Apr 21 04:37:39 CDT 2014

Total time taken to generate the page: 0.13955 seconds