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
  ORA-01719: outer join operator (+) not allowed in operand of OR or IN
Oracle, 9 , windows
By: akifdadan on Tue, 13 May 2014
15 401 Tue, 13 May 2014 10:33
By: cookiemonster
  Replace HTML codes with the special characters in CLOB data types.
By: rameshaimhigh@gmail.com on Tue, 13 May 2014
6 242 Tue, 13 May 2014 03:07
By: Lalit Kumar B
  ORA-01555 snapshot too old
Oracle 11g
By: Oracle_Walker on Fri, 09 May 2014
13 402 Tue, 13 May 2014 00:51
By: Oracle_Walker
  Multi-step query script in Toad
Toad Ora 11.0
By: ipisors on Mon, 12 May 2014
4 242 Mon, 12 May 2014 17:08
By: ipisors
  String Manipulation
Oracle 10g
By: kletho on Mon, 12 May 2014
2 197 Mon, 12 May 2014 14:48
By: BlackSwan
  How to handle null values in function having dynamic sql
By: na.dharma@gmail.com on Mon, 12 May 2014
12 437 Mon, 12 May 2014 08:37
By: na.dharma@gmail.com
  procedure to read file from ftp login and write it into another table.
oracle 10g
By: gupta0kumud on Mon, 12 May 2014
2 243 Mon, 12 May 2014 07:27
By: EdStevens
  FLAG BASED ON PREVIOUS ROWS
By: nsk78 on Fri, 09 May 2014
9 290 Fri, 09 May 2014 23:09
By: BlackSwan
  How to downgrade Oracle version in a session
11.2.0.3
By: pointers on Thu, 08 May 2014
5 312 Fri, 09 May 2014 05:50
By: pointers
  A Query to Display Sequence of Numbers in a Order
Oracle 10g, Win Xp
By: stalin4d on Fri, 09 May 2014
7 402 Fri, 09 May 2014 05:50
By: Solomon Yakobson
  Pivot concept in procedures
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Thu, 20 March 2014
5 500 Fri, 09 May 2014 01:32
By: Lalit Kumar B
  1 Statement Runs other Doesn't
Oracle 11g
By: azeem87 on Thu, 08 May 2014
3 196 Thu, 08 May 2014 11:46
By: BlackSwan
  Bulk insert and record missing
By: Malakay79 on Thu, 08 May 2014
6 257 Thu, 08 May 2014 08:08
By: Lalit Kumar B
  Performance of Window Sort
Oracle 11g
By: orc_dev on Thu, 08 May 2014
2 169 Thu, 08 May 2014 07:58
By: Lalit Kumar B
  Strange Pivot - Concatenate Text Fields
By: hdogg on Wed, 07 May 2014
3 216 Thu, 08 May 2014 06:51
By: Solomon Yakobson
  Oracle XML Parsing
Oracle 9.2.0.8
By: sarankumar.ds on Thu, 08 May 2014
5 248 Thu, 08 May 2014 05:42
By: Michel Cadot
  NVL2 -> why doesn't this work in a package??? Oracle
By: chetwyn on Tue, 21 March 2006
25 8780 Wed, 07 May 2014 17:15
By: shulamit kerem
  Validate an IP Range
PL/SQL
By: praveenramaswamy on Wed, 07 May 2014
10 338 Wed, 07 May 2014 13:55
By: Littlefoot
  how to get the values from the another table if the table has null
By: mist598 on Wed, 07 May 2014
22 440 Wed, 07 May 2014 11:31
By: Michel Cadot
  unable truncate table in plsql block
11g,toad 12.1
By: ashwanth77 on Wed, 07 May 2014
5 315 Wed, 07 May 2014 08:15
By: Solomon Yakobson
  MV creation error PLS-512: Cannot directly access remote package variable or cursor
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
By: Buchas on Wed, 07 May 2014
7 256 Wed, 07 May 2014 07:08
By: Solomon Yakobson
  ORA-00905 error
oracle 10g
By: laxmi.oracle on Tue, 06 May 2014
3 341 Wed, 07 May 2014 06:24
By: laxmi.oracle
  Date format in PL/SQL vs. PSP
By: agarfin on Tue, 06 May 2014
6 332 Tue, 06 May 2014 13:57
By: Lalit Kumar B
  How to define range in where clause?
Windows 7
By: indrarai on Tue, 06 May 2014
14 544 Tue, 06 May 2014 07:56
By: Lalit Kumar B
  ORA-00979: not a GROUP BY expression
Oracle 11g
By: na.dharma@gmail.com on Tue, 06 May 2014
3 248 Tue, 06 May 2014 07:33
By: Michel Cadot
  webservices
11g
By: usmanelahi on Tue, 06 May 2014
3 229 Tue, 06 May 2014 06:21
By: Michel Cadot
  Time Out Or Kill the Session
Oracle 11 g Release 2
By: azeem87 on Wed, 30 April 2014
5 337 Tue, 06 May 2014 02:00
By: Michel Cadot
  Oracle Alphanumeric Sequence
Oracle 11g,win7
By: Xandot on Sun, 04 May 2014
13 671 Tue, 06 May 2014 00:02
By: Michel Cadot
  Creating Table in plsql
By: pratikshamehra on Sat, 03 May 2014
9 408 Sat, 03 May 2014 14:03
By: BlackSwan
  Simple Stored Procedure help...
11g Enterprise Edition Release 11.2.0.2.0 - 64bit
By: rappaj on Fri, 02 May 2014
6 424 Fri, 02 May 2014 08:28
By: Lalit Kumar B
  Why we cannot use procedure in select statement?
By: aaditya321 on Tue, 29 April 2014
11 883 Fri, 02 May 2014 08:01
By: Lalit Kumar B
  How to avoid trigger
By: aaditya321 on Thu, 01 May 2014
8 399 Fri, 02 May 2014 05:32
By: aaditya321
  Update statement where update exists.
Oracle 12.1.0.1.0 Window
By: tmcallister on Thu, 01 May 2014
5 357 Fri, 02 May 2014 00:25
By: Michel Cadot
  PLS-00306: wrong number or types of arguments in call to 'PR_4552'
Oralce 11g
By: na.dharma@gmail.com on Wed, 30 April 2014
7 322 Thu, 01 May 2014 13:03
By: Lalit Kumar B
  need function convert time digit to analog
By: hassan08 on Thu, 01 May 2014
13 453 Thu, 01 May 2014 12:29
By: EdStevens
  Dimension Mapping For Data Continuity - using Oracle SQL/PL/SQL
Oracle 11gR2, RHL 5 EE
By: suresh1985xp on Wed, 30 April 2014
1 281 Thu, 01 May 2014 04:21
By: Lalit Kumar B
  Instead of trigger not supporting blob
Oracle 11g
By: srinivas.k2005 on Wed, 30 April 2014
4 356 Thu, 01 May 2014 03:36
By: srinivas.k2005
  Oracle Roles -- Users -- Grant Privileges
By: praveenramaswamy on Wed, 30 April 2014
11 311 Wed, 30 April 2014 16:41
By: BlackSwan
  Impact of Using Same Alias Twice in Huge SQL Statement
SQL
By: smedvid on Wed, 30 April 2014
12 413 Wed, 30 April 2014 12:32
By: smedvid
  HSODBC.EXE, unable to find corresponding oracle session
By: praveenramaswamy on Wed, 30 April 2014
2 185 Wed, 30 April 2014 12:15
By: praveenramaswamy
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 Aug 01 09:35:07 CDT 2014

Total time taken to generate the page: 0.15214 seconds