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
  Re:Confused by these two questions
By: morrism35 on Sat, 13 December 2014
12 2332 Sun, 14 December 2014 13:29
By: Michel Cadot
  oracle procedure compile syntax check
oracle 11.2.0.3 rac Enterprise Linux Server release 5.10
By: zxx2403 on Sun, 14 December 2014
2 1476 Sun, 14 December 2014 05:28
By: Michel Cadot
  Table partitioning & Saving Partition to different database.
By: raj_te on Fri, 12 December 2014
7 1098 Fri, 12 December 2014 16:30
By: Bill B
  PL/SQL Script execution metics in Oracle
By: praveenr.kumar on Fri, 12 December 2014
3 867 Fri, 12 December 2014 12:50
By: BlackSwan
  Sorting of Data
Oracle 10g
By: Mayur Shinde on Fri, 12 December 2014
3 1067 Fri, 12 December 2014 07:17
By: EdStevens
  Getting a word which contains some strings
Oracle
By: jaggy on Mon, 08 December 2014
5 2253 Fri, 12 December 2014 03:29
By: Shreya Aggarwal
  RAW TO HEX
11G
By: sajeeshts on Thu, 11 December 2014
2 879 Thu, 11 December 2014 08:22
By: Michel Cadot
  Maker-Checker in Oracle
Oracle 10g
By: sss111ind on Wed, 10 December 2014
5 1827 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 1534 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 1210 Thu, 11 December 2014 04:34
By: lstrn
  Scenario:
Oracle
By: mohammed.mca09@gmail.com on Wed, 10 December 2014
3 1233 Thu, 11 December 2014 00:35
By: Michel Cadot
  ora-06550
plsql
By: sanodani on Tue, 09 December 2014
14 1315 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 2018 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 787 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 814 Tue, 09 December 2014 00:49
By: OraFerro
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
12 700 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 524 Mon, 08 December 2014 08:23
By: Roachcoach
  Getting data from data dictionary
By: internship on Mon, 08 December 2014
6 776 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 1172 Mon, 08 December 2014 07:23
By: Lalit Kumar B
  how to update values using trigger
By: mist598 on Mon, 08 December 2014
12 1117 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 610 Sun, 07 December 2014 22:28
By: OraFerro
  UNPIVOT mutiple columns with different conditions
oracle 11g
By: X123455 on Mon, 01 December 2014
5 597 Sat, 06 December 2014 07:26
By: Solomon Yakobson
  number to char convertion
oracle 10g
By: vivek_rol on Fri, 05 December 2014
8 977 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 836 Thu, 04 December 2014 09:39
By: Michel Cadot
  Updating Specified Fields
By: Rajesh Reddy on Wed, 03 December 2014
5 472 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 3504 Wed, 03 December 2014 10:50
By: gazzag
  Procedure for counting rows in a table
By: internship on Tue, 02 December 2014
7 651 Wed, 03 December 2014 08:37
By: cookiemonster
  Order by clause
Oracle 10g
By: sss111ind on Wed, 03 December 2014
20 623 Wed, 03 December 2014 04:57
By: sss111ind
  Job Scheduing
Oracle 10g R2
By: Mayuresh Kumar on Wed, 03 December 2014
16 518 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 671 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 504 Tue, 02 December 2014 19:34
By: buggleboy007
  Date function
By: dineshchowdary532 on Mon, 17 November 2014
14 743 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 349 Tue, 02 December 2014 05:51
By: Lalit Kumar B
  Merge BLOB
By: Rafeek on Fri, 24 December 2010
9 2549 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 604 Mon, 01 December 2014 06:04
By: Michel Cadot
  Concate 2 table columns
oracle 11
By: ajay.r1982 on Sat, 29 November 2014
24 1425 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 375 Sun, 30 November 2014 04:05
By: Michel Cadot
  Trigger on before delete
By: altaffdba on Fri, 28 November 2014
8 449 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 422 Fri, 28 November 2014 16:29
By: buggleboy007
  FORALL and Associative Arrays
Oracle 10g2
By: mjm22 on Fri, 28 November 2014
6 560 Fri, 28 November 2014 15:28
By: Solomon Yakobson
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 Aug 29 14:48:24 CDT 2015

Total time taken to generate the page: 0.13233 seconds