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
  Capitalization of multiple words in one query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: Malkav on Wed, 10 December 2014
8 1376 Thu, 11 December 2014 05:31
By: Malkav
  Query Rewrite and Self-Joins
Oracle Database EE 11.2.0.3.0
By: lstrn on Thu, 11 December 2014
4 1127 Thu, 11 December 2014 04:34
By: lstrn
  Scenario:
Oracle
By: mohammed.mca09@gmail.com on Wed, 10 December 2014
3 1159 Thu, 11 December 2014 00:35
By: Michel Cadot
  ora-06550
plsql
By: sanodani on Tue, 09 December 2014
14 1174 Wed, 10 December 2014 08:56
By: sanodani
  Can we get back any column after DROP
Oracle 11g, Window 7
By: Bilal Khan on Sat, 06 December 2014
21 1624 Tue, 09 December 2014 08:31
By: joy_division
  dumping data from *.rtf file to oracle table
Linux, oracle 11g
By: nischalinn on Mon, 08 December 2014
3 658 Tue, 09 December 2014 07:00
By: EdStevens
  Materialized view refresh does not work
11.2.0.1.0
By: OraFerro on Mon, 08 December 2014
6 728 Tue, 09 December 2014 00:49
By: OraFerro
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
12 611 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 407 Mon, 08 December 2014 08:23
By: Roachcoach
  Getting data from data dictionary
By: internship on Mon, 08 December 2014
6 663 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 985 Mon, 08 December 2014 07:23
By: Lalit Kumar B
  how to update values using trigger
By: mist598 on Mon, 08 December 2014
12 884 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 517 Sun, 07 December 2014 22:28
By: OraFerro
  UNPIVOT mutiple columns with different conditions
oracle 11g
By: X123455 on Mon, 01 December 2014
5 525 Sat, 06 December 2014 07:26
By: Solomon Yakobson
  number to char convertion
oracle 10g
By: vivek_rol on Fri, 05 December 2014
8 815 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 628 Thu, 04 December 2014 09:39
By: Michel Cadot
  Updating Specified Fields
By: Rajesh Reddy on Wed, 03 December 2014
5 391 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 3052 Wed, 03 December 2014 10:50
By: gazzag
  Procedure for counting rows in a table
By: internship on Tue, 02 December 2014
7 573 Wed, 03 December 2014 08:37
By: cookiemonster
  Order by clause
Oracle 10g
By: sss111ind on Wed, 03 December 2014
20 538 Wed, 03 December 2014 04:57
By: sss111ind
  Job Scheduing
Oracle 10g R2
By: Mayuresh Kumar on Wed, 03 December 2014
16 445 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 481 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 416 Tue, 02 December 2014 19:34
By: buggleboy007
  Date function
By: dineshchowdary532 on Mon, 17 November 2014
14 670 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 286 Tue, 02 December 2014 05:51
By: Lalit Kumar B
  Merge BLOB
By: Rafeek on Fri, 24 December 2010
9 2381 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 505 Mon, 01 December 2014 06:04
By: Michel Cadot
  Concate 2 table columns
oracle 11
By: ajay.r1982 on Sat, 29 November 2014
24 1110 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 314 Sun, 30 November 2014 04:05
By: Michel Cadot
  Trigger on before delete
By: altaffdba on Fri, 28 November 2014
8 379 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 340 Fri, 28 November 2014 16:29
By: buggleboy007
  FORALL and Associative Arrays
Oracle 10g2
By: mjm22 on Fri, 28 November 2014
6 435 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 805 Fri, 28 November 2014 10:52
By: Michel Cadot
  using VIEW in procedures
Oracle 9i
By: live4learn on Fri, 28 November 2014
2 255 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 247 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 512 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 365 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 406 Thu, 27 November 2014 12:46
By: buggleboy007
  Return individuals most regular areas
Oracle 11g
By: asr77 on Thu, 27 November 2014
9 365 Thu, 27 November 2014 07:05
By: Solomon Yakobson
  number to character conversion
oracle 11g
By: b_chugh on Thu, 27 November 2014
4 276 Thu, 27 November 2014 03:01
By: b_chugh
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 Apr 28 05:32:18 CDT 2015

Total time taken to generate the page: 0.13886 seconds