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
  Announcement: How to use [code] tags and make your code easier to read?
Other people will appreciate it
By: Littlefoot on Mon, 05 September 2011
0 43005 Mon, 05 September 2011 02:20
By: Littlefoot
  Procedure to traverse the table based on fk constraints
oracle 11g sql developer
By: zenthil86 on Sat, 20 December 2014
12 2765 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 513 Mon, 22 December 2014 12:39
By: orausern
  ASCII in oracle 11g
By: swati.pale on Mon, 22 December 2014
1 489 Mon, 22 December 2014 10:59
By: BlackSwan
  Re:- how to check column value in particular format
windows7
By: ajamitjain129@gmail.com on Mon, 22 December 2014
2 765 Mon, 22 December 2014 08:11
By: Michel Cadot
  How to Delete Parent table record
Oracle 10g,11g
By: amitsukte on Tue, 10 July 2012
9 2853 Mon, 22 December 2014 02:51
By: Michel Cadot
  Use of set in Oracle
Oracle 10g
By: sss111ind on Sat, 20 December 2014
8 2937 Mon, 22 December 2014 00:30
By: sss111ind
  SQL Query
Oracle 10g,Win 7
By: Xandot on Wed, 10 December 2014
3 2274 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 2502 Sun, 21 December 2014 01:32
By: Michel Cadot
  generic queries
11.2.0.3
By: Amine on Fri, 19 December 2014
7 2421 Sat, 20 December 2014 14:27
By: Michel Cadot
icon5.gif DatatypeConverter
Database 11.2
By: ziad-al on Sat, 20 December 2014
9 2180 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 2650 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 3020 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 649 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 275 Thu, 18 December 2014 09:55
By: BlackSwan
  plsql table partitions
By: palpali on Tue, 16 December 2014
17 1836 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 2367 Thu, 18 December 2014 06:42
By: Michel Cadot
  table type indexed by binary integer
By: mist598 on Wed, 17 December 2014
4 858 Thu, 18 December 2014 01:45
By: sss111ind
  ORA-00907 : Formatting Error
Oracle 10g
By: abhayman on Wed, 17 December 2014
2 1661 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 1024 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 516 Tue, 16 December 2014 16:48
By: buggleboy007
  Program never get completed
11i
By: nishantranjan00787 on Sat, 13 December 2014
10 2116 Tue, 16 December 2014 04:46
By: cookiemonster
  Re:Assigning priviledge to all tables
By: morrism35 on Sun, 14 December 2014
5 1091 Tue, 16 December 2014 03:03
By: cookiemonster
  dynamic sql column concat
11g
By: orsoghu on Mon, 15 December 2014
12 720 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 546 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 199 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 277 Mon, 15 December 2014 14:30
By: Michel Cadot
  NOVALIDATE Constraint Using Index
Oracle 11g
By: azeem87 on Mon, 15 December 2014
2 278 Mon, 15 December 2014 12:31
By: azeem87
  Updating a column in many tables
By: rak123 on Mon, 08 December 2014
19 2309 Mon, 15 December 2014 04:21
By: rak123
  E-Mail sending issue from Oracle Database
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
By: Manoj.Gupta.91 on Fri, 12 December 2014
7 1318 Mon, 15 December 2014 01:26
By: Manoj.Gupta.91
  Re:Confused by these two questions
By: morrism35 on Sat, 13 December 2014
12 1664 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 1197 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 685 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 535 Fri, 12 December 2014 12:50
By: BlackSwan
  Sorting of Data
Oracle 10g
By: Mayur Shinde on Fri, 12 December 2014
3 752 Fri, 12 December 2014 07:17
By: EdStevens
  Getting a word which contains some strings
Oracle
By: jaggy on Mon, 08 December 2014
5 1890 Fri, 12 December 2014 03:29
By: Shreya Aggarwal
  RAW TO HEX
11G
By: sajeeshts on Thu, 11 December 2014
2 630 Thu, 11 December 2014 08:22
By: Michel Cadot
  Maker-Checker in Oracle
Oracle 10g
By: sss111ind on Wed, 10 December 2014
5 1529 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 1157 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 1008 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: Mon Dec 22 20:38:05 CST 2014

Total time taken to generate the page: 0.09193 seconds