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
  Getting a word which contains some strings
Oracle
By: jaggy on Mon, 08 December 2014
5 2237 Fri, 12 December 2014 03:29
By: Shreya Aggarwal
  RAW TO HEX
11G
By: sajeeshts on Thu, 11 December 2014
2 865 Thu, 11 December 2014 08:22
By: Michel Cadot
  Maker-Checker in Oracle
Oracle 10g
By: sss111ind on Wed, 10 December 2014
5 1807 Thu, 11 December 2014 06:22
By: sss111ind
  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 1498 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 1192 Thu, 11 December 2014 04:34
By: lstrn
  Scenario:
Oracle
By: mohammed.mca09@gmail.com on Wed, 10 December 2014
3 1220 Thu, 11 December 2014 00:35
By: Michel Cadot
  ora-06550
plsql
By: sanodani on Tue, 09 December 2014
14 1300 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 1953 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 750 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 796 Tue, 09 December 2014 00:49
By: OraFerro
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
12 691 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 509 Mon, 08 December 2014 08:23
By: Roachcoach
  Getting data from data dictionary
By: internship on Mon, 08 December 2014
6 757 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 1138 Mon, 08 December 2014 07:23
By: Lalit Kumar B
  how to update values using trigger
By: mist598 on Mon, 08 December 2014
12 1080 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 588 Sun, 07 December 2014 22:28
By: OraFerro
  UNPIVOT mutiple columns with different conditions
oracle 11g
By: X123455 on Mon, 01 December 2014
5 587 Sat, 06 December 2014 07:26
By: Solomon Yakobson
  number to char convertion
oracle 10g
By: vivek_rol on Fri, 05 December 2014
8 951 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 791 Thu, 04 December 2014 09:39
By: Michel Cadot
  Updating Specified Fields
By: Rajesh Reddy on Wed, 03 December 2014
5 459 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 3433 Wed, 03 December 2014 10:50
By: gazzag
  Procedure for counting rows in a table
By: internship on Tue, 02 December 2014
7 640 Wed, 03 December 2014 08:37
By: cookiemonster
  Order by clause
Oracle 10g
By: sss111ind on Wed, 03 December 2014
20 612 Wed, 03 December 2014 04:57
By: sss111ind
  Job Scheduing
Oracle 10g R2
By: Mayuresh Kumar on Wed, 03 December 2014
16 510 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 617 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 489 Tue, 02 December 2014 19:34
By: buggleboy007
  Date function
By: dineshchowdary532 on Mon, 17 November 2014
14 731 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 336 Tue, 02 December 2014 05:51
By: Lalit Kumar B
  Merge BLOB
By: Rafeek on Fri, 24 December 2010
9 2517 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 591 Mon, 01 December 2014 06:04
By: Michel Cadot
  Concate 2 table columns
oracle 11
By: ajay.r1982 on Sat, 29 November 2014
24 1365 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 370 Sun, 30 November 2014 04:05
By: Michel Cadot
  Trigger on before delete
By: altaffdba on Fri, 28 November 2014
8 441 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 405 Fri, 28 November 2014 16:29
By: buggleboy007
  FORALL and Associative Arrays
Oracle 10g2
By: mjm22 on Fri, 28 November 2014
6 550 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 962 Fri, 28 November 2014 10:52
By: Michel Cadot
  using VIEW in procedures
Oracle 9i
By: live4learn on Fri, 28 November 2014
2 312 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 300 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 587 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 422 Fri, 28 November 2014 00:58
By: rahul1982
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: Mon Aug 03 06:06:17 CDT 2015

Total time taken to generate the page: 0.04791 seconds