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
  Impact of Using Same Alias Twice in Huge SQL Statement
SQL
By: smedvid on Wed, 30 April 2014
12 454 Wed, 30 April 2014 12:32
By: smedvid
  HSODBC.EXE, unable to find corresponding oracle session
By: praveenramaswamy on Wed, 30 April 2014
2 205 Wed, 30 April 2014 12:15
By: praveenramaswamy
  how to set FROM DATE with time in sql query
oracle 11gr2 linux 6.4
By: kesavansundaram on Wed, 30 April 2014
2 372 Wed, 30 April 2014 11:36
By: Michel Cadot
  QEP and Query Reconstruction Technique
11.2.0.3
By: Kevin Meade on Fri, 25 April 2014
8 604 Wed, 30 April 2014 08:38
By: Kevin Meade
  oracle sql query
oracle 10g
By: karthik.m1988 on Wed, 30 April 2014
7 344 Wed, 30 April 2014 08:18
By: Michel Cadot
  Merge statement
11g ,window7
By: maheshkumar93 on Tue, 29 April 2014
3 384 Tue, 29 April 2014 08:04
By: cookiemonster
  Oracle View doubt
Oracle 11g
By: Oracle_Walker on Mon, 28 April 2014
4 333 Tue, 29 April 2014 00:13
By: Michel Cadot
  Multi Array - MultiSet - or other??
10.2
By: lott42 on Mon, 28 April 2014
5 318 Mon, 28 April 2014 16:42
By: Barbara Boehmer
  logic Required
Oracle 11g
By: jason346 on Sat, 26 April 2014
4 770 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 798 Mon, 28 April 2014 05:13
By: jason346
  spotting errors (merged 2)
win7 oracle 11g
By: ishan2ma on Mon, 28 April 2014
16 496 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 434 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 937 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 345 Sat, 26 April 2014 08:18
By: Solomon Yakobson
  Nested table
By: VladGab on Fri, 25 April 2014
8 557 Fri, 25 April 2014 10:06
By: Solomon Yakobson
  Comma separated
Oracle 11g
By: srinivas.k2005 on Fri, 25 April 2014
5 477 Fri, 25 April 2014 09:53
By: Michel Cadot
  Find out last four digits
Oracle
By: Shyam.reddy141 on Thu, 24 April 2014
3 350 Thu, 24 April 2014 13:13
By: Solomon Yakobson
  Get information from LDAP
By: srivardhan on Wed, 08 July 2009
24 7837 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 291 Thu, 24 April 2014 10:12
By: smedvid
  ORA-28002 error while connecting DB LINK
By: Bikash.p on Wed, 23 April 2014
9 565 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 812 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 437 Wed, 23 April 2014 09:06
By: Solomon Yakobson
  oracle pl/sql procedure
oracle 10g
By: karthik.m1988 on Fri, 11 April 2014
24 1115 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 736 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 405 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 328 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 1045 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 394 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 1144 Fri, 18 April 2014 11:59
By: sspn2010
  for loop
11g
By: ggggg on Sun, 02 March 2014
12 775 Fri, 18 April 2014 07:32
By: Solomon Yakobson
  sp_log_entry
By: thelearner on Thu, 17 April 2014
2 267 Thu, 17 April 2014 17:06
By: BlackSwan
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
12 772 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 368 Thu, 17 April 2014 12:52
By: Littlefoot
  Missing right paren... subquery trouble
Oracle 11g
By: pagoo on Wed, 16 April 2014
3 620 Wed, 16 April 2014 09:36
By: Michel Cadot
  query of status changed
11g
By: usmanelahi on Tue, 15 April 2014
8 609 Wed, 16 April 2014 06:17
By: Solomon Yakobson
  Date in Words
By: vipul.gupta2 on Wed, 16 April 2014
5 599 Wed, 16 April 2014 02:09
By: vipul.gupta2
  Help with PL Packages
Oracle SQL
By: cman348powah on Tue, 15 April 2014
2 435 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 369 Tue, 15 April 2014 20:20
By: EdStevens
  how to use joins in hierarchical queries
11g
By: ashwanth77 on Tue, 15 April 2014
2 221 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 1082 Tue, 15 April 2014 08:49
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: Wed Aug 27 04:01:35 CDT 2014

Total time taken to generate the page: 0.14601 seconds