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 36968 Mon, 05 September 2011 02:20
By: Littlefoot
  Get information from LDAP
By: srivardhan on Wed, 08 July 2009
18 6713 Thu, 24 April 2014 08:39
By: ThomasG
  ORA-28002 error while connecting DB LINK
By: Bikash.p on Wed, 23 April 2014
8 254 Thu, 24 April 2014 07:43
By: Michel Cadot
  New to sql and need some help please (merged)
SQL Plus
By: om357 on Wed, 23 April 2014
15 622 Thu, 24 April 2014 00:58
By: Michel Cadot
Need to Understand Explain plan has been moved to Performance Tuning by the moderator.
  Unable to display contents of CHARARR;
SQL Developer
By: plsqlnewbie on Tue, 22 April 2014
12 300 Wed, 23 April 2014 09:06
By: Solomon Yakobson
  oracle pl/sql procedure
oracle 10g
By: karthik.m1988 on Fri, 11 April 2014
24 867 Wed, 23 April 2014 07:44
By: Michel Cadot
  Job not being executed on time
Oracle 11g r2 , Linux OEM 5.9
By: Andrey_R on Mon, 07 April 2014
12 572 Wed, 23 April 2014 05:56
By: Michel Cadot
How to save time format to 24 hour while importing data from xls file has been moved to Client Tools by the moderator.
  join field depending on condition
DB Visualizer SQL ORACLE
By: epr55 on Tue, 22 April 2014
8 239 Tue, 22 April 2014 13:12
By: Michel Cadot
  Data Type Number
Oracle 11g
By: teck_lee80@yahoo.com on Mon, 21 April 2014
5 225 Tue, 22 April 2014 01:36
By: Michel Cadot
performance Tuning has been moved to Performance Tuning by the moderator.
  How to join two table with no duplicate
By: ocpsujon on Sun, 20 April 2014
17 838 Sun, 20 April 2014 22:34
By: ocpsujon
  case insensitive search UPPER/LOWER() vs. NLSSORT
Oracle 10g
By: rc3d on Sun, 20 April 2014
2 254 Sun, 20 April 2014 09:19
By: Lalit Kumar B
  Searching a string and replacing with value
Oracle 10g
By: sss111ind on Fri, 11 April 2014
13 920 Sat, 19 April 2014 01:55
By: sss111ind
  Transpose query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Wed, 16 April 2014
13 987 Fri, 18 April 2014 11:59
By: sspn2010
  for loop
11g
By: ggggg on Sun, 02 March 2014
12 647 Fri, 18 April 2014 07:32
By: Solomon Yakobson
  sp_log_entry
By: thelearner on Thu, 17 April 2014
2 138 Thu, 17 April 2014 17:06
By: BlackSwan
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
12 519 Thu, 17 April 2014 16:21
By: dariyoosh
  Need to get max update date time last 7 days
11
By: cplusplus1 on Thu, 17 April 2014
3 270 Thu, 17 April 2014 12:52
By: Littlefoot
  Missing right paren... subquery trouble
Oracle 11g
By: pagoo on Wed, 16 April 2014
3 447 Wed, 16 April 2014 09:36
By: Michel Cadot
  query of status changed
11g
By: usmanelahi on Tue, 15 April 2014
8 480 Wed, 16 April 2014 06:17
By: Solomon Yakobson
  Date in Words
By: vipul.gupta2 on Wed, 16 April 2014
5 471 Wed, 16 April 2014 02:09
By: vipul.gupta2
  Help with PL Packages
Oracle SQL
By: cman348powah on Tue, 15 April 2014
2 285 Wed, 16 April 2014 01:13
By: vslabs
  Create table in sqlplus script
oracle 11g, windows os
By: anncao on Tue, 15 April 2014
4 245 Tue, 15 April 2014 20:20
By: EdStevens
  how to use joins in hierarchical queries
11g
By: ashwanth77 on Tue, 15 April 2014
2 126 Tue, 15 April 2014 11:31
By: Michel Cadot
  ORA-29283: invalid file operation
Oracle 10g Enterprise, HPUX-B.11.11
By: bryant1003 on Tue, 15 April 2014
18 695 Tue, 15 April 2014 08:49
By: Solomon Yakobson
  How to check row count of sys_refcursor
Oracle11g
By: na.dharma@gmail.com on Tue, 15 April 2014
11 665 Tue, 15 April 2014 08:38
By: pointers
  how to remove columns not ending with leaf nodes in hierarchical queries
11g,toad 12.1
By: ashwanth77 on Sat, 12 April 2014
9 626 Tue, 15 April 2014 03:37
By: ashwanth77
  select query
10g
By: foopaloop on Mon, 14 April 2014
1 211 Mon, 14 April 2014 22:40
By: BlackSwan
  (non)Matching nulls
By: tmcallister on Mon, 14 April 2014
2 128 Mon, 14 April 2014 10:48
By: tmcallister
  how can i insert 00-jan-2014 into a date column
By: ramadurga on Mon, 14 April 2014
20 688 Mon, 14 April 2014 10:28
By: Michel Cadot
  Delete all levels of employees those who are under BLAKE?
By: kiranrathodkr916 on Mon, 14 April 2014
4 281 Mon, 14 April 2014 09:15
By: Solomon Yakobson
  Remove the department in dept table where dept does not have any employees?
By: kiranrathodkr916 on Mon, 14 April 2014
4 204 Mon, 14 April 2014 06:26
By: cookiemonster
  Remove all entries except last one
Oracle Database 11.2.0.3 Enterprise Edition
By: manubatham20 on Sun, 13 April 2014
16 773 Mon, 14 April 2014 06:26
By: Michel Cadot
  can any one help me in forming the below requested query
By: karthik7narla on Mon, 14 April 2014
3 308 Mon, 14 April 2014 03:23
By: Michel Cadot
  Distinct & Group By when used Analytic Function
By: mist598 on Mon, 14 April 2014
2 246 Mon, 14 April 2014 02:20
By: mist598
  Historical Data Delete Query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
By: ArjunK on Sun, 13 April 2014
2 238 Mon, 14 April 2014 00:12
By: Littlefoot
  how to overcome mutating table error
11g,toad 12.1
By: ashwanth77 on Fri, 11 April 2014
5 397 Sun, 13 April 2014 23:22
By: flyboy
  arrange
By: ghosh898 on Sun, 13 April 2014
2 143 Sun, 13 April 2014 18:38
By: Solomon Yakobson
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: Thu Apr 24 09:38:47 CDT 2014

Total time taken to generate the page: 0.08727 seconds