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
  Subquery
By: sudharshan on Fri, 23 May 2014
4 257 Fri, 23 May 2014 09:55
By: sudharshan
  How to resolve mutation error in function?
By: aaditya321 on Fri, 23 May 2014
6 294 Fri, 23 May 2014 07:41
By: BlackSwan
  Reverse running sum
By: 8511TPC on Thu, 22 May 2014
4 444 Fri, 23 May 2014 05:50
By: Solomon Yakobson
  To create External table for database table
Oracle 10g/11g
By: Nellai on Wed, 14 May 2014
3 269 Thu, 22 May 2014 11:45
By: Nellai
  Need procedure logic
oracle 11g
By: mvrkr44 on Sun, 08 December 2013
12 773 Thu, 22 May 2014 10:34
By: cookiemonster
  plsql procedure gets invalidated
11g
By: ashwanth77 on Tue, 13 May 2014
11 629 Thu, 22 May 2014 05:30
By: ashwanth77
  randomize records and groupby date.
By: rlsublime on Wed, 21 May 2014
10 448 Thu, 22 May 2014 02:53
By: cookiemonster
  convert string to date
By: rlsublime on Wed, 21 May 2014
3 231 Thu, 22 May 2014 01:11
By: Lalit Kumar B
  How to group days in a week
11.2.0.3 Win 2008 Server
By: Amine on Wed, 21 May 2014
15 360 Wed, 21 May 2014 10:45
By: Amine
  Increment sequence to max value of column
Oracle 10g
By: rose@ora on Tue, 20 May 2014
3 260 Wed, 21 May 2014 10:40
By: rose@ora
  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 173 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 227 Wed, 21 May 2014 06:35
By: gauravgautam135
  remove special characters except , - .
oracle 10g
By: thelearner on Tue, 20 May 2014
8 353 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 239 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 293 Wed, 21 May 2014 02:16
By: Lalit Kumar B
  Looping joins
By: 8511TPC on Mon, 19 May 2014
3 274 Mon, 19 May 2014 09:59
By: Lalit Kumar B
  help with procedures!
By: reuben123 on Sun, 18 May 2014
4 289 Mon, 19 May 2014 03:28
By: Michel Cadot
  ORA-01031: insufficient privileges
Oracle 11g, windows
By: mokarem on Mon, 19 May 2014
3 243 Mon, 19 May 2014 02:07
By: Littlefoot
  Oracle form error 06502
D2k 10G
By: vivek6648 on Sat, 17 May 2014
7 467 Sun, 18 May 2014 09:25
By: Lalit Kumar B
  UTL_HTTP error
By: ora_meh on Sun, 18 May 2014
13 601 Sun, 18 May 2014 08:35
By: Michel Cadot
  Rolls limit
10g database
By: mahnazzz on Sat, 17 May 2014
10 396 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 377 Sun, 18 May 2014 05:41
By: Solomon Yakobson
  plsql statment with this output
By: hahaie on Sat, 17 May 2014
8 363 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 343 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 181 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 296 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 208 Fri, 16 May 2014 00:20
By: HugeOu
  insert with different values
Oracle 10g
By: m.abdulhaq on Thu, 15 May 2014
4 292 Thu, 15 May 2014 07:24
By: m.abdulhaq
  Need Help In Query
11g
By: annu-agi on Wed, 14 May 2014
5 293 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 363 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 458 Tue, 13 May 2014 15:13
By: ipisors
  replace
oracle
By: thelearner on Tue, 13 May 2014
2 189 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 238 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 245 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 430 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 262 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 426 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 259 Mon, 12 May 2014 17:08
By: ipisors
  String Manipulation
Oracle 10g
By: kletho on Mon, 12 May 2014
2 216 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 451 Mon, 12 May 2014 08:37
By: na.dharma@gmail.com
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: Wed Aug 20 13:49:57 CDT 2014

Total time taken to generate the page: 0.12282 seconds