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
  Replace HTML codes with the special characters in CLOB data types.
By: rameshaimhigh@gmail.com on Tue, 13 May 2014
6 264 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 428 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 262 Mon, 12 May 2014 17:08
By: ipisors
  String Manipulation
Oracle 10g
By: kletho on Mon, 12 May 2014
2 218 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 452 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 272 Mon, 12 May 2014 07:27
By: EdStevens
  FLAG BASED ON PREVIOUS ROWS
By: nsk78 on Fri, 09 May 2014
9 309 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 324 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 423 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 547 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 215 Thu, 08 May 2014 11:46
By: BlackSwan
  Bulk insert and record missing
By: Malakay79 on Thu, 08 May 2014
6 285 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 188 Thu, 08 May 2014 07:58
By: Lalit Kumar B
  Strange Pivot - Concatenate Text Fields
By: hdogg on Wed, 07 May 2014
3 243 Thu, 08 May 2014 06:51
By: Solomon Yakobson
  NVL2 -> why doesn't this work in a package??? Oracle
By: chetwyn on Tue, 21 March 2006
25 8915 Wed, 07 May 2014 17:15
By: shulamit kerem
  Validate an IP Range
PL/SQL
By: praveenramaswamy on Wed, 07 May 2014
10 368 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 470 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 349 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 276 Wed, 07 May 2014 07:08
By: Solomon Yakobson
  ORA-00905 error
oracle 10g
By: laxmi.oracle on Tue, 06 May 2014
3 361 Wed, 07 May 2014 06:24
By: laxmi.oracle
  Date format in PL/SQL vs. PSP
By: agarfin on Tue, 06 May 2014
6 353 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 562 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 268 Tue, 06 May 2014 07:33
By: Michel Cadot
  webservices
11g
By: usmanelahi on Tue, 06 May 2014
3 244 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 350 Tue, 06 May 2014 02:00
By: Michel Cadot
  Oracle Alphanumeric Sequence
Oracle 11g,win7
By: Xandot on Sun, 04 May 2014
13 706 Tue, 06 May 2014 00:02
By: Michel Cadot
  Creating Table in plsql
By: pratikshamehra on Sat, 03 May 2014
9 431 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 450 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 920 Fri, 02 May 2014 08:01
By: Lalit Kumar B
  How to avoid trigger
By: aaditya321 on Thu, 01 May 2014
8 420 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 377 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 355 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 474 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 288 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 369 Thu, 01 May 2014 03:36
By: srinivas.k2005
  Oracle Roles -- Users -- Grant Privileges
By: praveenramaswamy on Wed, 30 April 2014
11 345 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 449 Wed, 30 April 2014 12:32
By: smedvid
  HSODBC.EXE, unable to find corresponding oracle session
By: praveenramaswamy on Wed, 30 April 2014
2 202 Wed, 30 April 2014 12:15
By: praveenramaswamy
  how to set FROM DATE with time in sql query
oracle 11gr2 linux 6.4
By: kesavansundaram on Wed, 30 April 2014
2 371 Wed, 30 April 2014 11:36
By: Michel Cadot
  QEP and Query Reconstruction Technique
11.2.0.3
By: Kevin Meade on Fri, 25 April 2014
8 596 Wed, 30 April 2014 08:38
By: Kevin Meade
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 22 10:59:52 CDT 2014

Total time taken to generate the page: 0.09313 seconds