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
  How to get back purged data into the tables
By: mist598 on Wed, 29 January 2014
18 533 Wed, 29 January 2014 14:18
By: John Watson
  Searching string with special characters using INSTR function
oracle 10g
By: babhuko on Wed, 29 January 2014
1 262 Wed, 29 January 2014 11:53
By: Michel Cadot
  Oracle Message - <pck name.proc name> : 301
9.2.0.8.0
By: grpatwari on Wed, 29 January 2014
5 197 Wed, 29 January 2014 10:53
By: grpatwari
  Can you any one help me to solve the unique constraint error
Oracle 11g
By: na.dharma@gmail.com on Wed, 29 January 2014
4 165 Wed, 29 January 2014 09:38
By: BlackSwan
  Selecting top records
Oracle 11g
By: KeithS on Tue, 28 January 2014
3 256 Wed, 29 January 2014 09:01
By: BlackSwan
  Restrictions in accessing collections values
Oracle 10g
By: anilkln on Wed, 29 January 2014
3 269 Wed, 29 January 2014 02:59
By: Michel Cadot
  Extracting sub-string in reverse way
SQL
By: hi.villinda on Tue, 28 January 2014
3 278 Tue, 28 January 2014 03:25
By: pablolee
  triggers
oracle 12c
By: danny432 on Mon, 27 January 2014
15 569 Mon, 27 January 2014 12:30
By: Michel Cadot
  Success event log
10.2
By: juhani on Fri, 24 January 2014
7 479 Mon, 27 January 2014 11:39
By: Kevin Meade
  what is the name of the sequence for my table
11.2g windows
By: anncao on Fri, 24 January 2014
12 623 Mon, 27 January 2014 10:36
By: pablolee
  optimize the query and store result in a variable
Oracle 11g, Win7
By: nischalinn on Fri, 24 January 2014
6 475 Mon, 27 January 2014 09:04
By: Kevin Meade
  Populating Primary Key Column using Sequence
Oracle 11g
By: BS_99 on Sun, 26 January 2014
6 346 Sun, 26 January 2014 02:32
By: Michel Cadot
  Same query not working in different schema's
Oracle 10g Rel 2
By: chat2raj.s on Thu, 23 January 2014
6 400 Sat, 25 January 2014 11:12
By: Kevin Meade
  how to Fast Compare
Oracle 11g , Linux
By: RAY_HT on Fri, 24 January 2014
3 310 Sat, 25 January 2014 10:57
By: Kevin Meade
  Split column data
Oracle 10
By: vs_net on Fri, 24 January 2014
3 330 Sat, 25 January 2014 09:57
By: Kevin Meade
  Using sys refcursor in exception block
TOAD(oracle 11g)
By: rameshoracle640@gmail.com on Thu, 23 January 2014
3 347 Fri, 24 January 2014 07:34
By: cookiemonster
  user defined exception and init pragma exception
11G
By: sampathkore4444@gmail.com on Thu, 23 January 2014
4 349 Fri, 24 January 2014 05:20
By: pablolee
  trigger
db2
By: rickmeister on Fri, 24 January 2014
3 292 Fri, 24 January 2014 04:15
By: John Watson
  need query syntax
Oracle10g xe ,win xp
By: rnemkul on Thu, 23 January 2014
2 196 Thu, 23 January 2014 10:13
By: Michel Cadot
  Second max
Oracle 10g, windows xp
By: Lynn321 on Thu, 23 January 2014
4 323 Thu, 23 January 2014 07:28
By: Michel Cadot
  PL/SQL statement
Oracle 11g 11.1.0.7.0
By: SteveShephard on Wed, 22 January 2014
7 504 Thu, 23 January 2014 07:24
By: Michel Cadot
  How to use bind variables in cursors?
By: adityalsr89 on Wed, 22 January 2014
9 517 Thu, 23 January 2014 02:31
By: cookiemonster
  Concatenate issue
11.2.0.3
By: rishwinger on Thu, 23 January 2014
3 247 Thu, 23 January 2014 02:14
By: Michel Cadot
  TO_DATE conversion issue
By: mist598 on Wed, 22 January 2014
9 551 Wed, 22 January 2014 13:34
By: joy_division
  how to improve sql & Skills
oracle 10g
By: thelearner on Wed, 22 January 2014
3 334 Wed, 22 January 2014 13:11
By: Michel Cadot
  default type of null column in explicit cursor
Oracle 11g
By: orsoghu on Wed, 22 January 2014
6 347 Wed, 22 January 2014 10:13
By: orsoghu
  Explain how these errors are coming? is it due to raise_application_error??
By: sampathkore4444@gmail.com on Wed, 22 January 2014
1 238 Wed, 22 January 2014 02:39
By: cookiemonster
  Number of Primary Key Columns
Oracle 10g
By: mamalik on Mon, 20 January 2014
22 1002 Tue, 21 January 2014 23:34
By: Kevin Meade
  Why Commit is not allowed in a trigger in oracle??
By: sampathkore4444@gmail.com on Tue, 21 January 2014
5 309 Tue, 21 January 2014 22:56
By: Kevin Meade
  Passing bind variables to a VIEW
Oracle 11g
By: ora4me on Tue, 21 January 2014
2 204 Tue, 21 January 2014 22:27
By: Kevin Meade
  UTL_SMTP
By: Aydin on Tue, 21 January 2014
8 381 Tue, 21 January 2014 08:05
By: Michel Cadot
  Issue in Database Link
Oracle Database 11g Enterprise Edition 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Mon, 20 January 2014
4 307 Tue, 21 January 2014 01:14
By: Michel Cadot
  The INTO clause of a SELECT statement of PL/SQL block
By: dancko on Mon, 20 January 2014
4 288 Tue, 21 January 2014 01:02
By: dancko
  Rank without analytical function
11.2.0.3
By: rishwinger on Mon, 20 January 2014
7 495 Mon, 20 January 2014 06:13
By: Solomon Yakobson
  SQL query
SQL developer, Oracle Clinical
By: draroda on Mon, 20 January 2014
4 337 Mon, 20 January 2014 01:54
By: Michel Cadot
  / (slash) character after END keyword
By: dancko on Sun, 19 January 2014
2 294 Sun, 19 January 2014 04:54
By: dancko
  how to find last updated date
By: preethia on Fri, 17 January 2014
9 690 Fri, 17 January 2014 11:40
By: Michel Cadot
  update with aggregate value
11.2.0.2.0
By: yuko on Thu, 16 January 2014
8 471 Fri, 17 January 2014 09:35
By: ThomasG
  Is this possible to drop the virtual column from table
Oracle 11g
By: na.dharma@gmail.com on Fri, 17 January 2014
3 332 Fri, 17 January 2014 06:44
By: pablolee
  Add a new column on first position of table in existing table.
Oracle 11g
By: na.dharma@gmail.com on Thu, 16 January 2014
8 669 Fri, 17 January 2014 01:18
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: Sat Apr 19 17:34:30 CDT 2014

Total time taken to generate the page: 0.07566 seconds