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
  dbms_output.put_line
By: nataliafoster26 on Tue, 10 December 2013
2 254 Tue, 10 December 2013 12:30
By: nataliafoster26
  object type
sql command line
By: aravindreddy.akiti on Tue, 10 December 2013
8 336 Tue, 10 December 2013 10:14
By: cookiemonster
  need Regular expression query
oracle 11g
By: mvrkr44 on Mon, 09 December 2013
12 626 Tue, 10 December 2013 09:10
By: Michel Cadot
  Pipe Separated Child record Query
Oracle10gR2
By: weekend79 on Tue, 10 December 2013
3 417 Tue, 10 December 2013 07:31
By: Solomon Yakobson
  Find number of consecutive days from a table
By: pratik4891 on Mon, 09 December 2013
15 952 Tue, 10 December 2013 02:51
By: pratik4891
  Sql Help
Oracle 11g, Xp
By: bharathi89 on Mon, 09 December 2013
6 307 Mon, 09 December 2013 12:12
By: Lalit Kumar B
  Please help me how concatenate all the error messages and display using OUT parameter value.
Oracle 11g
By: ramya_162 on Mon, 09 December 2013
1 343 Mon, 09 December 2013 08:18
By: EdStevens
  getting last logon datetime
Oracle 10g
By: sss111ind on Mon, 09 December 2013
13 756 Mon, 09 December 2013 05:54
By: Lalit Kumar B
  Missing employees table
Oracle 11g
By: Robs58 on Sun, 08 December 2013
5 513 Mon, 09 December 2013 04:49
By: martijn
  Insert value from one table to 2nd table
By: haider_1pk on Mon, 09 December 2013
4 415 Mon, 09 December 2013 01:49
By: pablolee
  What should be the XML format for this code.
Oracle 11g
By: ramya_162 on Fri, 06 December 2013
7 465 Mon, 09 December 2013 01:26
By: _jum
  Mutating Error
By: chat2raj.s on Sun, 08 December 2013
1 264 Sun, 08 December 2013 07:58
By: ThomasG
  Need package
By: mvrkr44 on Sun, 08 December 2013
1 209 Sun, 08 December 2013 04:52
By: cookiemonster
  Retrieve data from string column
Oracle 11g
By: srinivas.k2005 on Sun, 08 December 2013
2 266 Sun, 08 December 2013 03:19
By: srinivas.k2005
  need sql query
oracle 11g
By: mvrkr44 on Fri, 06 December 2013
5 423 Fri, 06 December 2013 10:49
By: manubatham20
  anything better than substr comparison?
By: lijok on Thu, 05 December 2013
4 511 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 418 Fri, 06 December 2013 04:55
By: John Watson
  update
oracle 10g
By: thelearner on Thu, 05 December 2013
4 418 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 458 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 856 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 1334 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 386 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 362 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 299 Thu, 05 December 2013 09:15
By: BlackSwan
icon4.gif What is SELECT?
Oracle
By: nskrishnab on Wed, 04 December 2013
11 750 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 391 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 403 Wed, 04 December 2013 07:49
By: John Watson
  Order by some columns
11g
By: yuvipoy on Thu, 21 November 2013
12 877 Wed, 04 December 2013 07:13
By: EdStevens
  Query Help
By: mist598 on Mon, 02 December 2013
10 728 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 379 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 758 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 758 Tue, 03 December 2013 05:41
By: lemune
  split long string
sql 11g
By: mahnazzz on Tue, 19 February 2013
13 8330 Tue, 03 December 2013 04:18
By: mahnazzz
  query to work fast
oracle 9i
By: DUTTA@TARUN on Mon, 02 December 2013
8 626 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 986 Mon, 02 December 2013 16:07
By: gupta27
  Comma Delimited String
PL SQL
By: yesh on Mon, 02 December 2013
10 632 Mon, 02 December 2013 07:35
By: dariyoosh
  ORGANIZATION_CODE must be declared
By: mist598 on Mon, 02 December 2013
2 374 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 631 Sun, 01 December 2013 10:20
By: mjpowers01606
  Please help with multiple update
By: envision2005 on Thu, 28 November 2013
23 1055 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 445 Sat, 30 November 2013 10:58
By: ramya_162
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 23 21:35:22 CDT 2014

Total time taken to generate the page: 0.06306 seconds