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
  Adding column to existing index
Oracle 11
By: brown_zzz on Thu, 29 May 2014
1 157 Thu, 29 May 2014 06:44
By: Lalit Kumar B
  View on synonym
oracle 10.2.0.4 - Windows server 2003
By: muktha_22 on Thu, 29 May 2014
7 279 Thu, 29 May 2014 06:08
By: Lalit Kumar B
  multiple values in a single column should be populated as multiple rows
oracle 11g
By: vkanuri on Wed, 28 May 2014
1 262 Wed, 28 May 2014 14:14
By: Michel Cadot
icon5.gif re-raising the exception.
oracle 11g , Hp UNIX
By: live4learn on Tue, 27 May 2014
9 404 Wed, 28 May 2014 09:57
By: Lalit Kumar B
  ORA-03113: end-of-file on communication channel
By: sibashishnayak on Wed, 28 May 2014
1 217 Wed, 28 May 2014 03:18
By: Michel Cadot
  How to find Table ,column name based on value in schema.
ORACLE 11g
By: gorants on Tue, 27 May 2014
5 322 Wed, 28 May 2014 00:50
By: deepakmannazhi
  use of SQL Hints "RESULT CACHE"
Oracle 11g R2, Windows 7
By: mokarem on Tue, 27 May 2014
1 220 Wed, 28 May 2014 00:27
By: Lalit Kumar B
  How to find Sequences associated to a table
ORACLE 11g
By: gorants on Tue, 27 May 2014
10 363 Tue, 27 May 2014 14:55
By: EdStevens
  Insert into Partition Tables After Column Addition
Oracle 11g Release 2
By: azeem87 on Tue, 27 May 2014
7 289 Tue, 27 May 2014 13:22
By: Solomon Yakobson
  Generate Sequence and then find missing Sequence no
Oracle 10.2.0.1
By: bluetooth420 on Tue, 27 May 2014
9 355 Tue, 27 May 2014 08:14
By: Michel Cadot
  Read Binary Format File
11g
By: tabj on Tue, 27 May 2014
2 163 Tue, 27 May 2014 07:53
By: Michel Cadot
  no output shown
By: mist598 on Tue, 27 May 2014
4 230 Tue, 27 May 2014 02:52
By: Lalit Kumar B
  ORA-8177 when execute procedure from forms10g
Linux 6.4, oracle 11.2.0.3 , patch 14666138 , forms 10g
By: RAY_HT on Sun, 25 May 2014
6 338 Tue, 27 May 2014 00:09
By: Littlefoot
  SQL or PL/SQL query to sum and avg time stamps
ORACLE 11g
By: gorants on Mon, 26 May 2014
9 348 Mon, 26 May 2014 14:30
By: Michel Cadot
  how to send email when the status of the object gets invalid?
11g
By: kiranrathodkr916 on Mon, 26 May 2014
3 251 Mon, 26 May 2014 13:30
By: BlackSwan
  Delimited by '\' in oracle external table
By: arvindvegad on Fri, 23 May 2014
19 836 Sun, 25 May 2014 12:02
By: Michel Cadot
  Help me to write query
Oacle 11g Version 11.2.0.3.0
By: ukumarjsr2 on Fri, 23 May 2014
4 352 Sun, 25 May 2014 10:03
By: Solomon Yakobson
  ORA-08177
Oracle 10g
By: sss111ind on Mon, 10 February 2014
5 502 Sun, 25 May 2014 09:15
By: Littlefoot
  Find number of consecutive days from a table
By: Amyask on Fri, 23 May 2014
4 341 Sun, 25 May 2014 04:38
By: rleishman
  rejected row capture
oracle 11g under linux
By: knroy10 on Sat, 24 May 2014
6 356 Sat, 24 May 2014 09:58
By: Michel Cadot
  Split column data
Oracle 10
By: vs_net on Fri, 24 January 2014
4 530 Fri, 23 May 2014 22:55
By: Barbara Boehmer
  Function that will create comma separated list
8i
By: bobghw on Thu, 22 May 2014
4 363 Fri, 23 May 2014 11:55
By: Littlefoot
  Subquery
By: sudharshan on Fri, 23 May 2014
4 267 Fri, 23 May 2014 09:55
By: sudharshan
  How to resolve mutation error in function?
By: aaditya321 on Fri, 23 May 2014
6 300 Fri, 23 May 2014 07:41
By: BlackSwan
  Reverse running sum
By: 8511TPC on Thu, 22 May 2014
4 451 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 280 Thu, 22 May 2014 11:45
By: Nellai
  Need procedure logic
oracle 11g
By: mvrkr44 on Sun, 08 December 2013
12 786 Thu, 22 May 2014 10:34
By: cookiemonster
  plsql procedure gets invalidated
11g
By: ashwanth77 on Tue, 13 May 2014
11 647 Thu, 22 May 2014 05:30
By: ashwanth77
  randomize records and groupby date.
By: rlsublime on Wed, 21 May 2014
10 455 Thu, 22 May 2014 02:53
By: cookiemonster
  convert string to date
By: rlsublime on Wed, 21 May 2014
3 241 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 369 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 270 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 179 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 240 Wed, 21 May 2014 06:35
By: gauravgautam135
  remove special characters except , - .
oracle 10g
By: thelearner on Tue, 20 May 2014
8 369 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 255 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 306 Wed, 21 May 2014 02:16
By: Lalit Kumar B
  Looping joins
By: 8511TPC on Mon, 19 May 2014
3 284 Mon, 19 May 2014 09:59
By: Lalit Kumar B
  help with procedures!
By: reuben123 on Sun, 18 May 2014
4 298 Mon, 19 May 2014 03:28
By: Michel Cadot
  ORA-01031: insufficient privileges
Oracle 11g, windows
By: mokarem on Mon, 19 May 2014
3 264 Mon, 19 May 2014 02:07
By: Littlefoot
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: Sat Aug 30 07:24:18 CDT 2014

Total time taken to generate the page: 0.05509 seconds