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
  Merge BLOB
By: Rafeek on Fri, 24 December 2010
9 2243 Tue, 02 December 2014 01:09
By: Michel Cadot
  How to print empty tag if value does not exist
oracle 11g
By: b_chugh on Thu, 27 November 2014
6 398 Mon, 01 December 2014 06:04
By: Michel Cadot
  Concate 2 table columns
oracle 11
By: ajay.r1982 on Sat, 29 November 2014
24 912 Sun, 30 November 2014 12:59
By: Michel Cadot
  Is there possible to update trigger table inside the same trigger
11.1.0.7.0 - 64 bit
By: mm_kanish05 on Sun, 30 November 2014
1 257 Sun, 30 November 2014 04:05
By: Michel Cadot
  Sql querry for count
By: asbh123 on Thu, 20 November 2014
17 759 Sat, 29 November 2014 06:42
By: Solomon Yakobson
  Trigger on before delete
By: altaffdba on Fri, 28 November 2014
8 313 Sat, 29 November 2014 06:26
By: Michel Cadot
  Unable to execute private procedure at SQL prompt
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Fri, 28 November 2014
10 256 Fri, 28 November 2014 16:29
By: buggleboy007
  FORALL and Associative Arrays
Oracle 10g2
By: mjm22 on Fri, 28 November 2014
6 344 Fri, 28 November 2014 15:28
By: Solomon Yakobson
  Split 1 row into multiple based on date
Oracle 11G
By: sinpeak on Wed, 26 November 2014
11 683 Fri, 28 November 2014 10:52
By: Michel Cadot
  using VIEW in procedures
Oracle 9i
By: live4learn on Fri, 28 November 2014
2 201 Fri, 28 November 2014 09:57
By: Michel Cadot
  Getting the Minimum of a date column
Oracle DB 11.2.0.3, Solaris
By: suddhasatwa_oracle on Fri, 28 November 2014
2 190 Fri, 28 November 2014 07:32
By: suddhasatwa_oracle
  Find duplicate rows having same null values
10g
By: nciteamo on Thu, 27 November 2014
16 430 Fri, 28 November 2014 03:35
By: Michel Cadot
  how often to analyze partition table
11g Enterprise Edition Release 11.2.0.3.0
By: rahul1982 on Thu, 27 November 2014
3 309 Fri, 28 November 2014 00:58
By: rahul1982
  Unable to get the procedure compiled -PLS-00306:Wrong number or types of arguments
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Thu, 27 November 2014
9 287 Thu, 27 November 2014 12:46
By: buggleboy007
  Return individuals most regular areas
Oracle 11g
By: asr77 on Thu, 27 November 2014
9 288 Thu, 27 November 2014 07:05
By: Solomon Yakobson
  number to character conversion
oracle 11g
By: b_chugh on Thu, 27 November 2014
4 211 Thu, 27 November 2014 03:01
By: b_chugh
  creating view based on availability of data in 2 tables
windows, plsql
By: raja.i on Wed, 26 November 2014
12 350 Thu, 27 November 2014 00:20
By: Littlefoot
  OUTPUT Of SYS_REFCURSOR
oracle 11g Release 2
By: azeem87 on Wed, 26 November 2014
3 184 Wed, 26 November 2014 16:32
By: azeem87
  Fulfill the width with different combination
10g
By: ashokb21 on Wed, 26 November 2014
4 210 Wed, 26 November 2014 14:47
By: Solomon Yakobson
  Updating missing values
Oracle 11g
By: ramya_162 on Tue, 25 November 2014
11 356 Wed, 26 November 2014 06:58
By: cookiemonster
icon7.gif Update Statement with multiple joins
Oracle 12c, Windows 8.1 x64
By: SunilJdh on Tue, 18 November 2014
5 371 Wed, 26 November 2014 01:42
By: SunilJdh
  Need data from table but there is multiple conditions
oracle 11g
By: deepak416 on Tue, 25 November 2014
7 222 Tue, 25 November 2014 13:38
By: Michel Cadot
  INSERT with SELECT ON DISTINCT
oracle 11g Rel2
By: azeem87 on Tue, 25 November 2014
5 238 Tue, 25 November 2014 13:36
By: joy_division
  Merge materialized views
oracle 11
By: JamesxxFord on Tue, 25 November 2014
4 202 Tue, 25 November 2014 10:36
By: gazzag
  materialized view on prebuilt table - refresh
By: ecivgamer on Tue, 25 November 2014
4 235 Tue, 25 November 2014 09:05
By: ecivgamer
  execution time
By: nisjess on Wed, 19 November 2014
6 392 Tue, 25 November 2014 08:19
By: Michel Cadot
  Quering Access DB.Table
11 g
By: annu-agi on Tue, 25 November 2014
3 183 Tue, 25 November 2014 05:30
By: Littlefoot
  Varchar2(4000 bytes) to Varchar2(4000 char) Conversion
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: queeny on Tue, 25 November 2014
3 208 Tue, 25 November 2014 04:07
By: Michel Cadot
  index
oracle 11g
By: Ashish_chand on Tue, 25 November 2014
3 188 Tue, 25 November 2014 04:03
By: Michel Cadot
  json data
By: nisjess on Mon, 24 November 2014
2 241 Tue, 25 November 2014 00:11
By: Michel Cadot
  INSERT with subquery in VALUES
By: aliyesami on Sun, 23 November 2014
11 451 Mon, 24 November 2014 17:31
By: BlackSwan
  PL/SQL email config
By: slemma on Wed, 19 November 2014
6 360 Mon, 24 November 2014 17:03
By: slemma
  divisor is equal to zero error
Oracle 11g
By: kkeebler on Mon, 24 November 2014
2 213 Mon, 24 November 2014 13:33
By: Michel Cadot
  Sql Satement print list of string
11.2.0.3,Linux X86_64
By: preet_kumar on Mon, 24 November 2014
6 232 Mon, 24 November 2014 08:23
By: John Watson
  Oracle Regular Expression
Oracle 10g
By: infosuresh2k on Wed, 19 November 2014
6 593 Sun, 23 November 2014 14:12
By: Solomon Yakobson
  "too many declarations of 'SUBSTR' match this call" while refreshing Materialized view
Oracle 11.1.0.7
By: kskarun on Thu, 20 November 2014
6 530 Sun, 23 November 2014 13:08
By: Solomon Yakobson
  oracle xml
oracle 10.2.0.3
By: pointers on Sat, 22 November 2014
3 246 Sat, 22 November 2014 10:15
By: Michel Cadot
  Convert Columns to rows
win 8,Oracle 10g
By: Xandot on Thu, 20 November 2014
5 497 Fri, 21 November 2014 05:55
By: Xandot
  column names are row values from another table.
11g
By: shree_z on Thu, 20 November 2014
8 350 Thu, 20 November 2014 16:01
By: BlackSwan
  retrieving previous status code
oracle sql
By: silver_fox on Thu, 20 November 2014
2 252 Thu, 20 November 2014 09:20
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: Wed Jan 28 22:52:10 CST 2015

Total time taken to generate the page: 0.09210 seconds