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
  dynamic sql column concat
11g
By: orsoghu on Mon, 15 December 2014
12 1121 Tue, 16 December 2014 01:31
By: Michel Cadot
  Can someone point me in the right direction
By: morrism35 on Mon, 15 December 2014
6 768 Tue, 16 December 2014 00:29
By: Michel Cadot
  Returning a sys_refcursor from an explicit cursor
11.2
By: tmcallister on Mon, 15 December 2014
1 381 Mon, 15 December 2014 14:40
By: Michel Cadot
  Using "&" in the password is recommended ??
Oracle 11.2.0.4.3 Linux 6.3 ( AWS RDS Oracle )
By: kesavansundaram on Mon, 15 December 2014
4 505 Mon, 15 December 2014 14:30
By: Michel Cadot
  NOVALIDATE Constraint Using Index
Oracle 11g
By: azeem87 on Mon, 15 December 2014
2 425 Mon, 15 December 2014 12:31
By: azeem87
  Updating a column in many tables
By: rak123 on Mon, 08 December 2014
19 3224 Mon, 15 December 2014 04:21
By: rak123
  Re:Confused by these two questions
By: morrism35 on Sat, 13 December 2014
12 2182 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 1430 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 1015 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 795 Fri, 12 December 2014 12:50
By: BlackSwan
  Sorting of Data
Oracle 10g
By: Mayur Shinde on Fri, 12 December 2014
3 1000 Fri, 12 December 2014 07:17
By: EdStevens
  Getting a word which contains some strings
Oracle
By: jaggy on Mon, 08 December 2014
5 2187 Fri, 12 December 2014 03:29
By: Shreya Aggarwal
  RAW TO HEX
11G
By: sajeeshts on Thu, 11 December 2014
2 833 Thu, 11 December 2014 08:22
By: Michel Cadot
  Maker-Checker in Oracle
Oracle 10g
By: sss111ind on Wed, 10 December 2014
5 1770 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 1446 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 1175 Thu, 11 December 2014 04:34
By: lstrn
  Scenario:
Oracle
By: mohammed.mca09@gmail.com on Wed, 10 December 2014
3 1194 Thu, 11 December 2014 00:35
By: Michel Cadot
  ora-06550
plsql
By: sanodani on Tue, 09 December 2014
14 1259 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 1850 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 717 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 764 Tue, 09 December 2014 00:49
By: OraFerro
  Perhaps a stupid query
11.2.0.3
By: Amine on Mon, 24 November 2014
12 652 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 473 Mon, 08 December 2014 08:23
By: Roachcoach
  Getting data from data dictionary
By: internship on Mon, 08 December 2014
6 709 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 1068 Mon, 08 December 2014 07:23
By: Lalit Kumar B
  how to update values using trigger
By: mist598 on Mon, 08 December 2014
12 998 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 564 Sun, 07 December 2014 22:28
By: OraFerro
  UNPIVOT mutiple columns with different conditions
oracle 11g
By: X123455 on Mon, 01 December 2014
5 554 Sat, 06 December 2014 07:26
By: Solomon Yakobson
  number to char convertion
oracle 10g
By: vivek_rol on Fri, 05 December 2014
8 898 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 736 Thu, 04 December 2014 09:39
By: Michel Cadot
  Updating Specified Fields
By: Rajesh Reddy on Wed, 03 December 2014
5 431 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 3281 Wed, 03 December 2014 10:50
By: gazzag
  Procedure for counting rows in a table
By: internship on Tue, 02 December 2014
7 613 Wed, 03 December 2014 08:37
By: cookiemonster
  Order by clause
Oracle 10g
By: sss111ind on Wed, 03 December 2014
20 587 Wed, 03 December 2014 04:57
By: sss111ind
  Job Scheduing
Oracle 10g R2
By: Mayuresh Kumar on Wed, 03 December 2014
16 482 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 576 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 460 Tue, 02 December 2014 19:34
By: buggleboy007
  Date function
By: dineshchowdary532 on Mon, 17 November 2014
14 697 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 317 Tue, 02 December 2014 05:51
By: Lalit Kumar B
  Merge BLOB
By: Rafeek on Fri, 24 December 2010
9 2458 Tue, 02 December 2014 01:09
By: Michel Cadot
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: Wed Jul 01 16:50:56 CDT 2015

Total time taken to generate the page: 0.23500 seconds