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
  ORA-00979: not a GROUP BY expression
Oracle 11g
By: na.dharma@gmail.com on Tue, 06 May 2014
3 246 Tue, 06 May 2014 07:33
By: Michel Cadot
  webservices
11g
By: usmanelahi on Tue, 06 May 2014
3 223 Tue, 06 May 2014 06:21
By: Michel Cadot
  Time Out Or Kill the Session
Oracle 11 g Release 2
By: azeem87 on Wed, 30 April 2014
5 332 Tue, 06 May 2014 02:00
By: Michel Cadot
  Oracle Alphanumeric Sequence
Oracle 11g,win7
By: Xandot on Sun, 04 May 2014
13 663 Tue, 06 May 2014 00:02
By: Michel Cadot
  Creating Table in plsql
By: pratikshamehra on Sat, 03 May 2014
9 402 Sat, 03 May 2014 14:03
By: BlackSwan
  Simple Stored Procedure help...
11g Enterprise Edition Release 11.2.0.2.0 - 64bit
By: rappaj on Fri, 02 May 2014
6 410 Fri, 02 May 2014 08:28
By: Lalit Kumar B
  Why we cannot use procedure in select statement?
By: aaditya321 on Tue, 29 April 2014
11 868 Fri, 02 May 2014 08:01
By: Lalit Kumar B
  How to avoid trigger
By: aaditya321 on Thu, 01 May 2014
8 393 Fri, 02 May 2014 05:32
By: aaditya321
  Update statement where update exists.
Oracle 12.1.0.1.0 Window
By: tmcallister on Thu, 01 May 2014
5 349 Fri, 02 May 2014 00:25
By: Michel Cadot
  PLS-00306: wrong number or types of arguments in call to 'PR_4552'
Oralce 11g
By: na.dharma@gmail.com on Wed, 30 April 2014
7 311 Thu, 01 May 2014 13:03
By: Lalit Kumar B
  need function convert time digit to analog
By: hassan08 on Thu, 01 May 2014
13 440 Thu, 01 May 2014 12:29
By: EdStevens
  Dimension Mapping For Data Continuity - using Oracle SQL/PL/SQL
Oracle 11gR2, RHL 5 EE
By: suresh1985xp on Wed, 30 April 2014
1 279 Thu, 01 May 2014 04:21
By: Lalit Kumar B
  Instead of trigger not supporting blob
Oracle 11g
By: srinivas.k2005 on Wed, 30 April 2014
4 350 Thu, 01 May 2014 03:36
By: srinivas.k2005
  Oracle Roles -- Users -- Grant Privileges
By: praveenramaswamy on Wed, 30 April 2014
11 302 Wed, 30 April 2014 16:41
By: BlackSwan
  Impact of Using Same Alias Twice in Huge SQL Statement
SQL
By: smedvid on Wed, 30 April 2014
12 398 Wed, 30 April 2014 12:32
By: smedvid
  HSODBC.EXE, unable to find corresponding oracle session
By: praveenramaswamy on Wed, 30 April 2014
2 181 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 350 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 575 Wed, 30 April 2014 08:38
By: Kevin Meade
  oracle sql query
oracle 10g
By: karthik.m1988 on Wed, 30 April 2014
7 326 Wed, 30 April 2014 08:18
By: Michel Cadot
  Merge statement
11g ,window7
By: maheshkumar93 on Tue, 29 April 2014
3 361 Tue, 29 April 2014 08:04
By: cookiemonster
  Oracle View doubt
Oracle 11g
By: Oracle_Walker on Mon, 28 April 2014
4 304 Tue, 29 April 2014 00:13
By: Michel Cadot
  Multi Array - MultiSet - or other??
10.2
By: lott42 on Mon, 28 April 2014
5 293 Mon, 28 April 2014 16:42
By: Barbara Boehmer
  logic Required
Oracle 11g
By: jason346 on Sat, 26 April 2014
4 727 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 768 Mon, 28 April 2014 05:13
By: jason346
  spotting errors (merged 2)
win7 oracle 11g
By: ishan2ma on Mon, 28 April 2014
16 472 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 395 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 883 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 320 Sat, 26 April 2014 08:18
By: Solomon Yakobson
  Nested table
By: VladGab on Fri, 25 April 2014
8 527 Fri, 25 April 2014 10:06
By: Solomon Yakobson
  Comma separated
Oracle 11g
By: srinivas.k2005 on Fri, 25 April 2014
5 454 Fri, 25 April 2014 09:53
By: Michel Cadot
  Find out last four digits
Oracle
By: Shyam.reddy141 on Thu, 24 April 2014
3 329 Thu, 24 April 2014 13:13
By: Solomon Yakobson
  Get information from LDAP
By: srivardhan on Wed, 08 July 2009
24 7645 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 256 Thu, 24 April 2014 10:12
By: smedvid
  ORA-28002 error while connecting DB LINK
By: Bikash.p on Wed, 23 April 2014
9 498 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 788 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 408 Wed, 23 April 2014 09:06
By: Solomon Yakobson
  oracle pl/sql procedure
oracle 10g
By: karthik.m1988 on Fri, 11 April 2014
24 1081 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 694 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 372 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 308 Tue, 22 April 2014 01:36
By: Michel Cadot
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 Jul 24 20:40:51 CDT 2014

Total time taken to generate the page: 0.10598 seconds