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
  sql query for employees based on Org hierarchy
R12.1.3, 11g
By: afzaa2yahoocom on Tue, 23 December 2014
1 2678 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 3660 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 2334 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 3183 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 868 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 3431 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 3347 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2582 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 2686 Sun, 21 December 2014 01:32
By: Michel Cadot
  generic queries
11.2.0.3
By: Amine on Fri, 19 December 2014
7 2616 Sat, 20 December 2014 14:27
By: Michel Cadot
icon5.gif DatatypeConverter
Database 11.2
By: ziad-al on Sat, 20 December 2014
9 2497 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 2939 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 3415 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 798 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 908 Thu, 18 December 2014 09:55
By: BlackSwan
  plsql table partitions
By: palpali on Tue, 16 December 2014
17 2022 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 2657 Thu, 18 December 2014 06:42
By: Michel Cadot
  table type indexed by binary integer
By: mist598 on Wed, 17 December 2014
4 953 Thu, 18 December 2014 01:45
By: sss111ind
  ORA-00907 : Formatting Error
Oracle 10g
By: abhayman on Wed, 17 December 2014
2 1728 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 1194 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 1029 Tue, 16 December 2014 16:48
By: buggleboy007
  Program never get completed
11i
By: nishantranjan00787 on Sat, 13 December 2014
10 2438 Tue, 16 December 2014 04:46
By: cookiemonster
  Re:Assigning priviledge to all tables
By: morrism35 on Sun, 14 December 2014
5 1193 Tue, 16 December 2014 03:03
By: cookiemonster
  dynamic sql column concat
11g
By: orsoghu on Mon, 15 December 2014
12 978 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 712 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 318 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 447 Mon, 15 December 2014 14:30
By: Michel Cadot
  NOVALIDATE Constraint Using Index
Oracle 11g
By: azeem87 on Mon, 15 December 2014
2 367 Mon, 15 December 2014 12:31
By: azeem87
  Updating a column in many tables
By: rak123 on Mon, 08 December 2014
19 2962 Mon, 15 December 2014 04:21
By: rak123
  Re:Confused by these two questions
By: morrism35 on Sat, 13 December 2014
12 2044 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 1377 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 946 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 732 Fri, 12 December 2014 12:50
By: BlackSwan
  Sorting of Data
Oracle 10g
By: Mayur Shinde on Fri, 12 December 2014
3 945 Fri, 12 December 2014 07:17
By: EdStevens
  Getting a word which contains some strings
Oracle
By: jaggy on Mon, 08 December 2014
5 2145 Fri, 12 December 2014 03:29
By: Shreya Aggarwal
  RAW TO HEX
11G
By: sajeeshts on Thu, 11 December 2014
2 779 Thu, 11 December 2014 08:22
By: Michel Cadot
  Maker-Checker in Oracle
Oracle 10g
By: sss111ind on Wed, 10 December 2014
5 1702 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 1370 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 1125 Thu, 11 December 2014 04:34
By: lstrn
  Scenario:
Oracle
By: mohammed.mca09@gmail.com on Wed, 10 December 2014
3 1157 Thu, 11 December 2014 00:35
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: Sat Apr 25 06:34:57 CDT 2015

Total time taken to generate the page: 0.07492 seconds