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
  QEP and Query Reconstruction Technique
11.2.0.3
By: Kevin Meade on Fri, 25 April 2014
8 681 Wed, 30 April 2014 08:38
By: Kevin Meade
  oracle sql query
oracle 10g
By: karthik.m1988 on Wed, 30 April 2014
7 385 Wed, 30 April 2014 08:18
By: Michel Cadot
  Merge statement
11g ,window7
By: maheshkumar93 on Tue, 29 April 2014
3 438 Tue, 29 April 2014 08:04
By: cookiemonster
  Oracle View doubt
Oracle 11g
By: Oracle_Walker on Mon, 28 April 2014
4 397 Tue, 29 April 2014 00:13
By: Michel Cadot
  Multi Array - MultiSet - or other??
10.2
By: lott42 on Mon, 28 April 2014
5 394 Mon, 28 April 2014 16:42
By: Barbara Boehmer
  logic Required
Oracle 11g
By: jason346 on Sat, 26 April 2014
4 817 Mon, 28 April 2014 06:23
By: jason346
  count the searched criteria and contact with those counted creitera
Oracle 11g
By: jason346 on Sat, 26 April 2014
5 840 Mon, 28 April 2014 05:13
By: jason346
  spotting errors (merged 2)
win7 oracle 11g
By: ishan2ma on Mon, 28 April 2014
16 551 Mon, 28 April 2014 04:27
By: Littlefoot
  ORA-00942:Table or View does not exist-Store procedure
Oracle 10g
By: rvsri on Sun, 27 April 2014
8 511 Sun, 27 April 2014 18:07
By: BlackSwan
  Cannot refresh Materialized View with Join in Oracle 12c 12.1.0.1.0 after Create
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production, Windows Server 2012
By: appsystems on Thu, 24 April 2014
17 1080 Sat, 26 April 2014 16:40
By: appsystems
  how to update hierarchical query
11g,toad 12.1
By: ashwanth77 on Sat, 26 April 2014
3 372 Sat, 26 April 2014 08:18
By: Solomon Yakobson
  Nested table
By: VladGab on Fri, 25 April 2014
8 614 Fri, 25 April 2014 10:06
By: Solomon Yakobson
  Comma separated
Oracle 11g
By: srinivas.k2005 on Fri, 25 April 2014
5 539 Fri, 25 April 2014 09:53
By: Michel Cadot
  Find out last four digits
Oracle
By: Shyam.reddy141 on Thu, 24 April 2014
3 384 Thu, 24 April 2014 13:13
By: Solomon Yakobson
  Get information from LDAP
By: srivardhan on Wed, 08 July 2009
24 8321 Thu, 24 April 2014 11:10
By: EdStevens
  Case Statement - Best Practice - Close with Else Null?
SQL
By: smedvid on Thu, 24 April 2014
2 337 Thu, 24 April 2014 10:12
By: smedvid
  ORA-28002 error while connecting DB LINK
By: Bikash.p on Wed, 23 April 2014
9 711 Thu, 24 April 2014 09:47
By: EdStevens
  New to sql and need some help please (merged)
SQL Plus
By: om357 on Wed, 23 April 2014
15 844 Thu, 24 April 2014 00:58
By: Michel Cadot
  Unable to display contents of CHARARR;
SQL Developer
By: plsqlnewbie on Tue, 22 April 2014
12 480 Wed, 23 April 2014 09:06
By: Solomon Yakobson
  oracle pl/sql procedure
oracle 10g
By: karthik.m1988 on Fri, 11 April 2014
24 1198 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 801 Wed, 23 April 2014 05:56
By: Michel Cadot
  join field depending on condition
DB Visualizer SQL ORACLE
By: epr55 on Tue, 22 April 2014
8 458 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 370 Tue, 22 April 2014 01:36
By: Michel Cadot
  How to join two table with no duplicate
By: ocpsujon on Sun, 20 April 2014
17 1130 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 446 Sun, 20 April 2014 09:19
By: Lalit Kumar B
  Transpose query help
Oracle 11.2.0.4, Linux
By: sspn2010 on Wed, 16 April 2014
13 1238 Fri, 18 April 2014 11:59
By: sspn2010
  for loop
11g
By: ggggg on Sun, 02 March 2014
12 833 Fri, 18 April 2014 07:32
By: Solomon Yakobson
  sp_log_entry
By: thelearner on Thu, 17 April 2014
2 320 Thu, 17 April 2014 17:06
By: BlackSwan
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
12 898 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 407 Thu, 17 April 2014 12:52
By: Littlefoot
  Missing right paren... subquery trouble
Oracle 11g
By: pagoo on Wed, 16 April 2014
3 698 Wed, 16 April 2014 09:36
By: Michel Cadot
  query of status changed
11g
By: usmanelahi on Tue, 15 April 2014
8 670 Wed, 16 April 2014 06:17
By: Solomon Yakobson
  Date in Words
By: vipul.gupta2 on Wed, 16 April 2014
5 656 Wed, 16 April 2014 02:09
By: vipul.gupta2
  Help with PL Packages
Oracle SQL
By: cman348powah on Tue, 15 April 2014
2 489 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 443 Tue, 15 April 2014 20:20
By: EdStevens
  how to use joins in hierarchical queries
11g
By: ashwanth77 on Tue, 15 April 2014
2 267 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 1249 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 1026 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 805 Tue, 15 April 2014 03:37
By: ashwanth77
  select query
10g
By: foopaloop on Mon, 14 April 2014
1 331 Mon, 14 April 2014 22:40
By: BlackSwan
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 Nov 01 01:53:41 CDT 2014

Total time taken to generate the page: 0.12775 seconds