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
  source does not have runnable target
sql developer, oracle 11g
By: zenthil86 on Tue, 23 December 2014
4 2636 Wed, 24 December 2014 01:38
By: Michel Cadot
  sql query for employees based on Org hierarchy
R12.1.3, 11g
By: afzaa2yahoocom on Tue, 23 December 2014
1 2661 Wed, 24 December 2014 01:36
By: Michel Cadot
  Dynamic PL/SQL which reads table and transposes rows to columns
oracle 11g R2, windows
By: zulu69 on Tue, 23 December 2014
3 3645 Wed, 24 December 2014 01:35
By: Michel Cadot
  Re:- how to check column value in particular format
windows7
By: ajamitjain129@gmail.com on Mon, 22 December 2014
4 2320 Tue, 23 December 2014 02:50
By: ajamitjain129@gmail.com
  Procedure to traverse the table based on fk constraints
oracle 11g sql developer
By: zenthil86 on Sat, 20 December 2014
12 3167 Mon, 22 December 2014 13:22
By: BlackSwan
  A question about using nested decode
Oracle 11.2.0.4 on Linux
By: orausern on Mon, 22 December 2014
5 860 Mon, 22 December 2014 12:39
By: orausern
  How to Delete Parent table record
Oracle 10g,11g
By: amitsukte on Tue, 10 July 2012
9 3373 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 3318 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2554 Sun, 21 December 2014 02:24
By: tamzidulamin
  Connect by Prior parent-child into string of values
10.2
By: lott42 on Fri, 07 February 2014
16 2671 Sun, 21 December 2014 01:32
By: Michel Cadot
  generic queries
11.2.0.3
By: Amine on Fri, 19 December 2014
7 2600 Sat, 20 December 2014 14:27
By: Michel Cadot
icon5.gif DatatypeConverter
Database 11.2
By: ziad-al on Sat, 20 December 2014
9 2471 Sat, 20 December 2014 11:46
By: ziad-al
  Open cursor for select, based on another cursor
11.2.0.1.0
By: OraFerro on Thu, 18 December 2014
12 2912 Sat, 20 December 2014 07:39
By: Michel Cadot
  I tried , adn tried, and tried, and for that reason, I'm notgoint to give up...
windows 7, oracle 11g toad
By: xebec on Fri, 19 December 2014
11 3379 Sat, 20 December 2014 00:52
By: Michel Cadot
  How to fetch a single record in an array/nested table
O/S:Windows 7 PRO; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Thu, 18 December 2014
37 770 Thu, 18 December 2014 15:34
By: buggleboy007
  utl_request ORA-29049 error when request salesforce.com
By: junkai.niu on Thu, 18 December 2014
1 825 Thu, 18 December 2014 09:55
By: BlackSwan
  plsql table partitions
By: palpali on Tue, 16 December 2014
17 1999 Thu, 18 December 2014 09:22
By: cookiemonster
  Issue with DBMS_LOB.SubStr
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Tue, 16 December 2014
7 2604 Thu, 18 December 2014 06:42
By: Michel Cadot
  table type indexed by binary integer
By: mist598 on Wed, 17 December 2014
4 937 Thu, 18 December 2014 01:45
By: sss111ind
  ORA-00907 : Formatting Error
Oracle 10g
By: abhayman on Wed, 17 December 2014
2 1716 Wed, 17 December 2014 01:56
By: abhayman
  Replacing wrong ID values with calculated ID
11.2.0.1.0
By: OraFerro on Mon, 15 December 2014
9 1174 Tue, 16 December 2014 22:04
By: OraFerro
  Concatenating an array output into one single string
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Mon, 15 December 2014
10 975 Tue, 16 December 2014 16:48
By: buggleboy007
  Program never get completed
11i
By: nishantranjan00787 on Sat, 13 December 2014
10 2406 Tue, 16 December 2014 04:46
By: cookiemonster
  Re:Assigning priviledge to all tables
By: morrism35 on Sun, 14 December 2014
5 1176 Tue, 16 December 2014 03:03
By: cookiemonster
  dynamic sql column concat
11g
By: orsoghu on Mon, 15 December 2014
12 953 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 690 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 304 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 436 Mon, 15 December 2014 14:30
By: Michel Cadot
  NOVALIDATE Constraint Using Index
Oracle 11g
By: azeem87 on Mon, 15 December 2014
2 356 Mon, 15 December 2014 12:31
By: azeem87
  Updating a column in many tables
By: rak123 on Mon, 08 December 2014
19 2898 Mon, 15 December 2014 04:21
By: rak123
  Re:Confused by these two questions
By: morrism35 on Sat, 13 December 2014
12 2019 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 1362 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 930 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 714 Fri, 12 December 2014 12:50
By: BlackSwan
  Sorting of Data
Oracle 10g
By: Mayur Shinde on Fri, 12 December 2014
3 924 Fri, 12 December 2014 07:17
By: EdStevens
  Getting a word which contains some strings
Oracle
By: jaggy on Mon, 08 December 2014
5 2113 Fri, 12 December 2014 03:29
By: Shreya Aggarwal
  RAW TO HEX
11G
By: sajeeshts on Thu, 11 December 2014
2 764 Thu, 11 December 2014 08:22
By: Michel Cadot
  Maker-Checker in Oracle
Oracle 10g
By: sss111ind on Wed, 10 December 2014
5 1659 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 1349 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 1111 Thu, 11 December 2014 04:34
By: lstrn
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 Mar 31 05:14:58 CDT 2015

Total time taken to generate the page: 0.11481 seconds