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
  Problem in Handling value with single quote in Dynamic SQL
11g Enterprise Edition Release 11.1.0.7.0/Linux
By: anil_mk on Wed, 21 May 2014
2 216 Wed, 21 May 2014 10:22
By: cookiemonster
  Retain first and last record according to id.
oracle 10g
By: gauravgautam135 on Wed, 21 May 2014
3 287 Wed, 21 May 2014 06:35
By: gauravgautam135
  remove special characters except , - .
oracle 10g
By: thelearner on Tue, 20 May 2014
8 462 Wed, 21 May 2014 06:12
By: Michel Cadot
  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 304 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 362 Wed, 21 May 2014 02:16
By: Lalit Kumar B
  Looping joins
By: 8511TPC on Mon, 19 May 2014
3 321 Mon, 19 May 2014 09:59
By: Lalit Kumar B
  help with procedures!
By: reuben123 on Sun, 18 May 2014
4 349 Mon, 19 May 2014 03:28
By: Michel Cadot
  ORA-01031: insufficient privileges
Oracle 11g, windows
By: mokarem on Mon, 19 May 2014
3 361 Mon, 19 May 2014 02:07
By: Littlefoot
  Oracle form error 06502
D2k 10G
By: vivek6648 on Sat, 17 May 2014
7 558 Sun, 18 May 2014 09:25
By: Lalit Kumar B
  UTL_HTTP error
By: ora_meh on Sun, 18 May 2014
13 828 Sun, 18 May 2014 08:35
By: Michel Cadot
  Rolls limit
10g database
By: mahnazzz on Sat, 17 May 2014
10 454 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 469 Sun, 18 May 2014 05:41
By: Solomon Yakobson
  plsql statment with this output
By: hahaie on Sat, 17 May 2014
8 419 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 396 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 219 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 386 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 246 Fri, 16 May 2014 00:20
By: HugeOu
  insert with different values
Oracle 10g
By: m.abdulhaq on Thu, 15 May 2014
4 323 Thu, 15 May 2014 07:24
By: m.abdulhaq
  Need Help In Query
11g
By: annu-agi on Wed, 14 May 2014
5 351 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 395 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 561 Tue, 13 May 2014 15:13
By: ipisors
  replace
oracle
By: thelearner on Tue, 13 May 2014
2 258 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 300 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 290 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 571 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 382 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 539 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 325 Mon, 12 May 2014 17:08
By: ipisors
  String Manipulation
Oracle 10g
By: kletho on Mon, 12 May 2014
2 254 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 515 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 329 Mon, 12 May 2014 07:27
By: EdStevens
  FLAG BASED ON PREVIOUS ROWS
By: nsk78 on Fri, 09 May 2014
9 391 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 397 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 494 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 943 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 270 Thu, 08 May 2014 11:46
By: BlackSwan
  Bulk insert and record missing
By: Malakay79 on Thu, 08 May 2014
6 355 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 233 Thu, 08 May 2014 07:58
By: Lalit Kumar B
  Strange Pivot - Concatenate Text Fields
By: hdogg on Wed, 07 May 2014
3 313 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 9660 Wed, 07 May 2014 17:15
By: shulamit kerem
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 Nov 28 05:29:03 CST 2014

Total time taken to generate the page: 0.12448 seconds