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
  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 340 Sun, 30 November 2014 04:05
By: Michel Cadot
  Trigger on before delete
By: altaffdba on Fri, 28 November 2014
8 415 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 384 Fri, 28 November 2014 16:29
By: buggleboy007
  FORALL and Associative Arrays
Oracle 10g2
By: mjm22 on Fri, 28 November 2014
6 509 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 905 Fri, 28 November 2014 10:52
By: Michel Cadot
  using VIEW in procedures
Oracle 9i
By: live4learn on Fri, 28 November 2014
2 294 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 277 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 559 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 399 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 471 Thu, 27 November 2014 12:46
By: buggleboy007
  Return individuals most regular areas
Oracle 11g
By: asr77 on Thu, 27 November 2014
9 411 Thu, 27 November 2014 07:05
By: Solomon Yakobson
  number to character conversion
oracle 11g
By: b_chugh on Thu, 27 November 2014
4 313 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 456 Thu, 27 November 2014 00:20
By: Littlefoot
  OUTPUT Of SYS_REFCURSOR
oracle 11g Release 2
By: azeem87 on Wed, 26 November 2014
3 278 Wed, 26 November 2014 16:32
By: azeem87
  Fulfill the width with different combination
10g
By: ashokb21 on Wed, 26 November 2014
4 295 Wed, 26 November 2014 14:47
By: Solomon Yakobson
  Updating missing values
Oracle 11g
By: ramya_162 on Tue, 25 November 2014
11 485 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 500 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 322 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 346 Tue, 25 November 2014 13:36
By: joy_division
  Merge materialized views
oracle 11
By: JamesxxFord on Tue, 25 November 2014
4 317 Tue, 25 November 2014 10:36
By: gazzag
  materialized view on prebuilt table - refresh
By: ecivgamer on Tue, 25 November 2014
4 354 Tue, 25 November 2014 09:05
By: ecivgamer
  execution time
By: nisjess on Wed, 19 November 2014
6 518 Tue, 25 November 2014 08:19
By: Michel Cadot
  Quering Access DB.Table
11 g
By: annu-agi on Tue, 25 November 2014
3 275 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 300 Tue, 25 November 2014 04:07
By: Michel Cadot
  index
oracle 11g
By: Ashish_chand on Tue, 25 November 2014
3 275 Tue, 25 November 2014 04:03
By: Michel Cadot
  json data
By: nisjess on Mon, 24 November 2014
2 347 Tue, 25 November 2014 00:11
By: Michel Cadot
  INSERT with subquery in VALUES
By: aliyesami on Sun, 23 November 2014
11 554 Mon, 24 November 2014 17:31
By: BlackSwan
  PL/SQL email config
By: slemma on Wed, 19 November 2014
6 468 Mon, 24 November 2014 17:03
By: slemma
  divisor is equal to zero error
Oracle 11g
By: kkeebler on Mon, 24 November 2014
2 348 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 309 Mon, 24 November 2014 08:23
By: John Watson
  Oracle Regular Expression
Oracle 10g
By: infosuresh2k on Wed, 19 November 2014
6 713 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 708 Sun, 23 November 2014 13:08
By: Solomon Yakobson
  oracle xml
oracle 10.2.0.3
By: pointers on Sat, 22 November 2014
3 368 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 718 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 462 Thu, 20 November 2014 16:01
By: BlackSwan
  retrieving previous status code
oracle sql
By: silver_fox on Thu, 20 November 2014
2 350 Thu, 20 November 2014 09:20
By: Michel Cadot
  Pattern Marching using regexp
UNIX, Oracle 11g
By: a_oracle on Thu, 20 November 2014
5 338 Thu, 20 November 2014 05:05
By: Michel Cadot
  materialized view log size doesn't correlate with its rows quantity
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
By: ecivgamer on Wed, 19 November 2014
4 332 Wed, 19 November 2014 13:20
By: ecivgamer
  how to use analytical function
By: mist598 on Tue, 18 November 2014
6 436 Wed, 19 November 2014 09:47
By: Michel Cadot
  how to get the previous value in the loop into, 2 separate variable without overwriting
By: venki459 on Mon, 17 November 2014
4 399 Wed, 19 November 2014 09:22
By: sandeep_orafaq
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: Tue Jun 30 15:42:14 CDT 2015

Total time taken to generate the page: 0.12522 seconds