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
  Oracle form error 06502
D2k 10G
By: vivek6648 on Sat, 17 May 2014
7 500 Sun, 18 May 2014 09:25
By: Lalit Kumar B
  UTL_HTTP error
By: ora_meh on Sun, 18 May 2014
13 664 Sun, 18 May 2014 08:35
By: Michel Cadot
  Rolls limit
10g database
By: mahnazzz on Sat, 17 May 2014
10 413 Sun, 18 May 2014 06:36
By: EdStevens
  Whenever runs server side its run fine but,client side gives error ora- 22288.
By: mist598 on Sun, 18 May 2014
3 411 Sun, 18 May 2014 05:41
By: Solomon Yakobson
  plsql statment with this output
By: hahaie on Sat, 17 May 2014
8 381 Sun, 18 May 2014 00:52
By: Michel Cadot
  How to view if a table indexs are clustered or non clustered?
11g, 11.2.0.3, Windows 7
By: JP10 on Thu, 15 May 2014
8 362 Fri, 16 May 2014 11:47
By: Michel Cadot
  multiple select with and
oralce 11g
By: miroconnect@yahoo.com on Fri, 16 May 2014
1 196 Fri, 16 May 2014 08:10
By: cookiemonster
  Memory use by Hash join in Oracle 11g
By: rekha.singhal@tcs.com on Thu, 15 May 2014
4 343 Fri, 16 May 2014 07:19
By: Roachcoach
  Finding the last trx (by date) per customer, per transaction type
10g, HP-UX
By: HugeOu on Thu, 15 May 2014
3 224 Fri, 16 May 2014 00:20
By: HugeOu
  insert with different values
Oracle 10g
By: m.abdulhaq on Thu, 15 May 2014
4 303 Thu, 15 May 2014 07:24
By: m.abdulhaq
  Need Help In Query
11g
By: annu-agi on Wed, 14 May 2014
5 317 Wed, 14 May 2014 05:41
By: Michel Cadot
  need Expert viewpoint on DDL design Java application [XML data in CLOB]
Oracle 11g
By: rc3d on Wed, 14 May 2014
0 375 Wed, 14 May 2014 03:46
By: rc3d
  Using Temp Tables in Oracle SQL
Toad 11.0 Ora
By: ipisors on Mon, 12 May 2014
10 491 Tue, 13 May 2014 15:13
By: ipisors
  replace
oracle
By: thelearner on Tue, 13 May 2014
2 224 Tue, 13 May 2014 14:41
By: Littlefoot
  Missing right parenthesis error
Oracle TNS for 64-bit Windows: Version 10.2.0.4.0 - Production. Windows 7
By: ipisors on Tue, 13 May 2014
8 269 Tue, 13 May 2014 12:55
By: ipisors
  Query To update a table
oracle 11g IBM-AIX
By: 9390512774 on Tue, 13 May 2014
9 265 Tue, 13 May 2014 10:36
By: Lalit Kumar B
  ORA-01719: outer join operator (+) not allowed in operand of OR or IN
Oracle, 9 , windows
By: akifdadan on Tue, 13 May 2014
15 475 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 302 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 463 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 286 Mon, 12 May 2014 17:08
By: ipisors
  String Manipulation
Oracle 10g
By: kletho on Mon, 12 May 2014
2 232 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 486 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 292 Mon, 12 May 2014 07:27
By: EdStevens
  FLAG BASED ON PREVIOUS ROWS
By: nsk78 on Fri, 09 May 2014
9 347 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 357 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 443 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 662 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 232 Thu, 08 May 2014 11:46
By: BlackSwan
  Bulk insert and record missing
By: Malakay79 on Thu, 08 May 2014
6 308 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 201 Thu, 08 May 2014 07:58
By: Lalit Kumar B
  Strange Pivot - Concatenate Text Fields
By: hdogg on Wed, 07 May 2014
3 268 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 9146 Wed, 07 May 2014 17:15
By: shulamit kerem
  Validate an IP Range
PL/SQL
By: praveenramaswamy on Wed, 07 May 2014
10 388 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 498 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 394 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 303 Wed, 07 May 2014 07:08
By: Solomon Yakobson
  ORA-00905 error
oracle 10g
By: laxmi.oracle on Tue, 06 May 2014
3 374 Wed, 07 May 2014 06:24
By: laxmi.oracle
  Date format in PL/SQL vs. PSP
By: agarfin on Tue, 06 May 2014
6 377 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 595 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 296 Tue, 06 May 2014 07:33
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: Sun Sep 21 01:05:05 CDT 2014

Total time taken to generate the page: 0.12509 seconds