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
  anything better than substr comparison?
By: lijok on Thu, 05 December 2013
4 464 Fri, 06 December 2013 08:48
By: Solomon Yakobson
  Difference in the execution plans
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: gupta27 on Thu, 05 December 2013
3 338 Fri, 06 December 2013 04:55
By: John Watson
  update
oracle 10g
By: thelearner on Thu, 05 December 2013
4 378 Fri, 06 December 2013 02:32
By: pablolee
icon5.gif gettin ip addres and user name
database oracle 11g
By: otto_paiz@hotmail.com on Thu, 05 December 2013
5 392 Fri, 06 December 2013 01:53
By: Michel Cadot
  Retrieve font name available in OS using sql plus
Windows 7, Oracle 10g XE
By: lock_heart on Wed, 04 December 2013
16 798 Fri, 06 December 2013 01:07
By: karthik7narla
  Excel attachment by utl_smtp
Oracle 11g, windows xp 32 bit
By: sudeshna_bio08 on Wed, 04 December 2013
12 972 Thu, 05 December 2013 23:15
By: BlackSwan
  How to populate data from an Excel file to Oracle table's LOB column
Oracle 9i, Linux 9
By: sonudev on Wed, 27 November 2013
2 312 Thu, 05 December 2013 11:55
By: shahzad-ul-hasan
  PL/SQL Package/Procedure Question
11g Release 2 Windows
By: Duane on Wed, 04 December 2013
5 325 Thu, 05 December 2013 09:25
By: Duane
  Need Fuzzy logic with Regular expression query
oracle 11g
By: mvrkr44 on Thu, 05 December 2013
1 260 Thu, 05 December 2013 09:15
By: BlackSwan
icon4.gif What is SELECT?
Oracle
By: nskrishnab on Wed, 04 December 2013
11 692 Wed, 04 December 2013 10:32
By: ThomasG
  priority along with overlapping dates query
11.2.0.3
By: sasisan09 on Tue, 03 December 2013
1 338 Wed, 04 December 2013 10:10
By: sasisan09
  DBMS_CDC find only the columns that are changed along with the primary key in the table
oracle 10.2.0.4
By: novice1 on Wed, 04 December 2013
6 340 Wed, 04 December 2013 07:49
By: John Watson
  Order by some columns
11g
By: yuvipoy on Thu, 21 November 2013
12 809 Wed, 04 December 2013 07:13
By: EdStevens
  Query Help
By: mist598 on Mon, 02 December 2013
10 687 Wed, 04 December 2013 02:56
By: cookiemonster
  How to Refresh User_tables
oracle 11gR1 OEL 5.5
By: 9390512774 on Tue, 03 December 2013
2 323 Wed, 04 December 2013 00:48
By: pablolee
  Reading Particular Line in UTL_FILE
oracle 11.2.0.3.0 - Windows server 2003 R2
By: muktha_22 on Mon, 02 December 2013
7 662 Wed, 04 December 2013 00:30
By: Michel Cadot
  How to use list of selected values on the body of procedure
Oracle 10g, PL/SQL
By: lemune on Sat, 30 November 2013
9 676 Tue, 03 December 2013 05:41
By: lemune
  split long string
sql 11g
By: mahnazzz on Tue, 19 February 2013
13 1504 Tue, 03 December 2013 04:18
By: mahnazzz
  query to work fast
oracle 9i
By: DUTTA@TARUN on Mon, 02 December 2013
8 579 Mon, 02 December 2013 17:35
By: pablolee
  How to get ddls for objects in DB and write them to a file
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: gupta27 on Mon, 25 November 2013
15 779 Mon, 02 December 2013 16:07
By: gupta27
  Comma Delimited String
PL SQL
By: yesh on Mon, 02 December 2013
10 594 Mon, 02 December 2013 07:35
By: dariyoosh
  ORGANIZATION_CODE must be declared
By: mist598 on Mon, 02 December 2013
2 333 Mon, 02 December 2013 02:11
By: mist598
  ORA-00935: group function is nested too deeply
Oracle Acadamy
By: mjpowers01606 on Sat, 30 November 2013
2 432 Sun, 01 December 2013 10:20
By: mjpowers01606
  Please help with multiple update
By: envision2005 on Thu, 28 November 2013
23 998 Sun, 01 December 2013 09:22
By: envision2005
  Error in reading XML message and inserting data into another DB using DB link
Oracle 11g
By: ramya_162 on Fri, 29 November 2013
4 381 Sat, 30 November 2013 10:58
By: ramya_162
  Multiple groupings in SQL
Oracle 11.2.0.3, Linux
By: sspn2010 on Wed, 20 November 2013
13 863 Sat, 30 November 2013 04:09
By: Lalit Kumar B
  Query to PIVOT
oracle 11g
By: srinivas.k2005 on Fri, 29 November 2013
3 366 Sat, 30 November 2013 02:43
By: pablolee
  how to write this update query?
By: jalal-rasooly on Fri, 29 November 2013
3 325 Fri, 29 November 2013 15:41
By: Littlefoot
  Run same procedure parallely in different sessions with diff parameter value
Oracle 11g
By: srinivas.k2005 on Fri, 29 November 2013
1 208 Fri, 29 November 2013 14:06
By: Michel Cadot
  not able to execute the explain plan in development in TOAD
Oracle 11g
By: na.dharma@gmail.com on Fri, 29 November 2013
2 297 Fri, 29 November 2013 13:12
By: Lalit Kumar B
  translate
Oracle 10g
By: m.abdulhaq on Tue, 26 November 2013
3 444 Fri, 29 November 2013 11:28
By: m.abdulhaq
  Fetching results using intermediate table
Oracle 10g
By: sss111ind on Fri, 29 November 2013
8 404 Fri, 29 November 2013 06:11
By: cookiemonster
  Need code
By: megamind on Fri, 29 November 2013
6 461 Fri, 29 November 2013 05:05
By: pablolee
  need to understand syntax
Oracle R12,SQL developer
By: megamind on Fri, 29 November 2013
3 539 Fri, 29 November 2013 03:24
By: megamind
  Using oracle wallets to move data from Oracle to teradata
By: Ankita06666 on Fri, 29 November 2013
0 694 Fri, 29 November 2013 01:40
By: Ankita06666
  Insert Script for Inserting values from Excel file
Oracle 10g Forms, WinXP
By: stalin4d on Thu, 28 November 2013
2 338 Thu, 28 November 2013 23:45
By: stalin4d
  Please help me to implement this procedure
Oracle 11g
By: ajaykumarkona on Tue, 26 November 2013
8 659 Thu, 28 November 2013 06:04
By: ajaykumarkona
  trim or remove data and spaces
Oracle 10 and 11g
By: imransi17@gmail.com on Wed, 27 November 2013
13 736 Thu, 28 November 2013 04:51
By: pablolee
  constraints error
sql command line
By: aravindreddy.akiti on Wed, 27 November 2013
7 408 Thu, 28 November 2013 01:03
By: Lalit Kumar B
  Error In Function
Oracle 10g
By: Rasol_57 on Wed, 27 November 2013
2 200 Wed, 27 November 2013 14:34
By: John Watson
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 Apr 23 21:04:29 CDT 2014

Total time taken to generate the page: 0.16818 seconds