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
  Materialized view refresh does not work
11.2.0.1.0
By: OraFerro on Mon, 08 December 2014
6 643 Tue, 09 December 2014 00:49
By: OraFerro
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
12 471 Mon, 08 December 2014 13:14
By: Solomon Yakobson
  Parallel DML problems (update)
11.2.0.4 RHEL5
By: Roachcoach on Mon, 08 December 2014
3 234 Mon, 08 December 2014 08:23
By: Roachcoach
  Getting data from data dictionary
By: internship on Mon, 08 December 2014
6 510 Mon, 08 December 2014 07:28
By: Lalit Kumar B
  Retrieve all column except 2 coulmn
11g, Window 8
By: Bilal Khan on Sun, 07 December 2014
11 709 Mon, 08 December 2014 07:23
By: Lalit Kumar B
  how to update values using trigger
By: mist598 on Mon, 08 December 2014
12 640 Mon, 08 December 2014 03:47
By: cookiemonster
  Use date field to determine matching field
11.2.0.1.0
By: OraFerro on Thu, 04 December 2014
7 417 Sun, 07 December 2014 22:28
By: OraFerro
  UNPIVOT mutiple columns with different conditions
oracle 11g
By: X123455 on Mon, 01 December 2014
5 413 Sat, 06 December 2014 07:26
By: Solomon Yakobson
  number to char convertion
oracle 10g
By: vivek_rol on Fri, 05 December 2014
8 491 Fri, 05 December 2014 09:14
By: Lalit Kumar B
  ORA-06553: PLS-306: wrong number or types of arguments in call to 'ROWID_BLOCK_NUMBER'
ORACLE 11.2.0.3.0
By: sajeeshts on Wed, 03 December 2014
13 348 Thu, 04 December 2014 09:39
By: Michel Cadot
  Updating Specified Fields
By: Rajesh Reddy on Wed, 03 December 2014
5 296 Thu, 04 December 2014 03:42
By: gazzag
  ORA-01010 Invalid OCI Operation during SCHEDULER job procedure that selects from db link
Oracle 11.2.0.1, x64, Server 2008
By: mbrown22 on Thu, 18 October 2012
9 2616 Wed, 03 December 2014 10:50
By: gazzag
  Procedure for counting rows in a table
By: internship on Tue, 02 December 2014
7 448 Wed, 03 December 2014 08:37
By: cookiemonster
  Order by clause
Oracle 10g
By: sss111ind on Wed, 03 December 2014
20 417 Wed, 03 December 2014 04:57
By: sss111ind
  Job Scheduing
Oracle 10g R2
By: Mayuresh Kumar on Wed, 03 December 2014
16 320 Wed, 03 December 2014 04:07
By: ThomasG
  Failed to execute target procedure ORA-20002: ORA-29279: SMTP permanent error: 550 5.1.1
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Tue, 02 December 2014
10 262 Tue, 02 December 2014 19:39
By: buggleboy007
  Getting bogged down with PLS-00201: identifier 'P_ERR_MESSAGE1' must be declared
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Tue, 02 December 2014
13 265 Tue, 02 December 2014 19:34
By: buggleboy007
  Date function
By: dineshchowdary532 on Mon, 17 November 2014
14 526 Tue, 02 December 2014 09:11
By: Lalit Kumar B
  Return value between two characters
Oracle IDE 4.0.2.15.21
By: SteveShephard on Tue, 02 December 2014
2 202 Tue, 02 December 2014 05:51
By: Lalit Kumar B
  Merge BLOB
By: Rafeek on Fri, 24 December 2010
9 2190 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 370 Mon, 01 December 2014 06:04
By: Michel Cadot
  Concate 2 table columns
oracle 11
By: ajay.r1982 on Sat, 29 November 2014
24 672 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 237 Sun, 30 November 2014 04:05
By: Michel Cadot
  Sql querry for count
By: asbh123 on Thu, 20 November 2014
17 659 Sat, 29 November 2014 06:42
By: Solomon Yakobson
  Trigger on before delete
By: altaffdba on Fri, 28 November 2014
8 300 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 238 Fri, 28 November 2014 16:29
By: buggleboy007
  FORALL and Associative Arrays
Oracle 10g2
By: mjm22 on Fri, 28 November 2014
6 303 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 529 Fri, 28 November 2014 10:52
By: Michel Cadot
  using VIEW in procedures
Oracle 9i
By: live4learn on Fri, 28 November 2014
2 185 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 174 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 396 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 280 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 252 Thu, 27 November 2014 12:46
By: buggleboy007
  Return individuals most regular areas
Oracle 11g
By: asr77 on Thu, 27 November 2014
9 273 Thu, 27 November 2014 07:05
By: Solomon Yakobson
  number to character conversion
oracle 11g
By: b_chugh on Thu, 27 November 2014
4 201 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 328 Thu, 27 November 2014 00:20
By: Littlefoot
  OUTPUT Of SYS_REFCURSOR
oracle 11g Release 2
By: azeem87 on Wed, 26 November 2014
3 164 Wed, 26 November 2014 16:32
By: azeem87
  Fulfill the width with different combination
10g
By: ashokb21 on Wed, 26 November 2014
4 201 Wed, 26 November 2014 14:47
By: Solomon Yakobson
  Updating missing values
Oracle 11g
By: ramya_162 on Tue, 25 November 2014
11 322 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 344 Wed, 26 November 2014 01:42
By: SunilJdh
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 Dec 20 16:46:44 CST 2014

Total time taken to generate the page: 0.10647 seconds