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
  Reset Sunday as first start week
11g Enterprise Edition Release 11.1.0.7.0/Linux
By: anil_mk on Wed, 21 May 2014
6 295 Wed, 21 May 2014 04:06
By: Michel Cadot
  How to add whitespace as default value using execute immediate?
11g 11.2.0.1 , windows server 2008r2 standard
By: JP10 on Tue, 20 May 2014
5 342 Wed, 21 May 2014 02:16
By: Lalit Kumar B
  Looping joins
By: 8511TPC on Mon, 19 May 2014
3 309 Mon, 19 May 2014 09:59
By: Lalit Kumar B
  help with procedures!
By: reuben123 on Sun, 18 May 2014
4 332 Mon, 19 May 2014 03:28
By: Michel Cadot
  ORA-01031: insufficient privileges
Oracle 11g, windows
By: mokarem on Mon, 19 May 2014
3 331 Mon, 19 May 2014 02:07
By: Littlefoot
  Oracle form error 06502
D2k 10G
By: vivek6648 on Sat, 17 May 2014
7 525 Sun, 18 May 2014 09:25
By: Lalit Kumar B
  UTL_HTTP error
By: ora_meh on Sun, 18 May 2014
13 749 Sun, 18 May 2014 08:35
By: Michel Cadot
  Rolls limit
10g database
By: mahnazzz on Sat, 17 May 2014
10 439 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 444 Sun, 18 May 2014 05:41
By: Solomon Yakobson
  plsql statment with this output
By: hahaie on Sat, 17 May 2014
8 407 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 378 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 204 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 363 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 236 Fri, 16 May 2014 00:20
By: HugeOu
  insert with different values
Oracle 10g
By: m.abdulhaq on Thu, 15 May 2014
4 315 Thu, 15 May 2014 07:24
By: m.abdulhaq
  Need Help In Query
11g
By: annu-agi on Wed, 14 May 2014
5 336 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 387 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 527 Tue, 13 May 2014 15:13
By: ipisors
  replace
oracle
By: thelearner on Tue, 13 May 2014
2 245 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 283 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 282 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 518 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 341 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 502 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 309 Mon, 12 May 2014 17:08
By: ipisors
  String Manipulation
Oracle 10g
By: kletho on Mon, 12 May 2014
2 244 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 501 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 309 Mon, 12 May 2014 07:27
By: EdStevens
  FLAG BASED ON PREVIOUS ROWS
By: nsk78 on Fri, 09 May 2014
9 369 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 382 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 464 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 797 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 252 Thu, 08 May 2014 11:46
By: BlackSwan
  Bulk insert and record missing
By: Malakay79 on Thu, 08 May 2014
6 332 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 218 Thu, 08 May 2014 07:58
By: Lalit Kumar B
  Strange Pivot - Concatenate Text Fields
By: hdogg on Wed, 07 May 2014
3 292 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 9389 Wed, 07 May 2014 17:15
By: shulamit kerem
  Validate an IP Range
PL/SQL
By: praveenramaswamy on Wed, 07 May 2014
10 455 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 515 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 420 Wed, 07 May 2014 08:15
By: Solomon Yakobson
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 Oct 24 05:20:53 CDT 2014

Total time taken to generate the page: 0.11474 seconds