OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Validate an IP Range PL/SQL By: praveenramaswamy on Wed, 07 May 2014	10	330	Wed, 07 May 2014 13:55 By: Littlefoot
how to get the values from the another table if the table has null By: mist598 on Wed, 07 May 2014	22	432	Wed, 07 May 2014 11:31 By: Michel Cadot
unable truncate table in plsql block 11g,toad 12.1 By: ashwanth77 on Wed, 07 May 2014	5	308	Wed, 07 May 2014 08:15 By: Solomon Yakobson
MV creation error PLS-512: Cannot directly access remote package variable or cursor Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi By: Buchas on Wed, 07 May 2014	7	251	Wed, 07 May 2014 07:08 By: Solomon Yakobson
ORA-00905 error oracle 10g By: laxmi.oracle on Tue, 06 May 2014	3	337	Wed, 07 May 2014 06:24 By: laxmi.oracle
Date format in PL/SQL vs. PSP By: agarfin on Tue, 06 May 2014	6	329	Tue, 06 May 2014 13:57 By: Lalit Kumar B
How to define range in where clause? Windows 7 By: indrarai on Tue, 06 May 2014	14	540	Tue, 06 May 2014 07:56 By: Lalit Kumar B
ORA-00979: not a GROUP BY expression Oracle 11g By: na.dharma@gmail.com on Tue, 06 May 2014	3	248	Tue, 06 May 2014 07:33 By: Michel Cadot
webservices 11g By: usmanelahi on Tue, 06 May 2014	3	225	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	666	Tue, 06 May 2014 00:02 By: Michel Cadot
Creating Table in plsql By: pratikshamehra on Sat, 03 May 2014	9	403	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	413	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	871	Fri, 02 May 2014 08:01 By: Lalit Kumar B
How to avoid trigger By: aaditya321 on Thu, 01 May 2014	8	396	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	350	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	315	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	280	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	304	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	401	Wed, 30 April 2014 12:32 By: smedvid
HSODBC.EXE, unable to find corresponding oracle session By: praveenramaswamy on Wed, 30 April 2014	2	182	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	353	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	577	Wed, 30 April 2014 08:38 By: Kevin Meade
oracle sql query oracle 10g By: karthik.m1988 on Wed, 30 April 2014	7	330	Wed, 30 April 2014 08:18 By: Michel Cadot
Merge statement 11g ,window7 By: maheshkumar93 on Tue, 29 April 2014	3	362	Tue, 29 April 2014 08:04 By: cookiemonster
Oracle View doubt Oracle 11g By: Oracle_Walker on Mon, 28 April 2014	4	308	Tue, 29 April 2014 00:13 By: Michel Cadot
Multi Array - MultiSet - or other?? 10.2 By: lott42 on Mon, 28 April 2014	5	296	Mon, 28 April 2014 16:42 By: Barbara Boehmer
logic Required Oracle 11g By: jason346 on Sat, 26 April 2014	4	728	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	770	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	398	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	889	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	323	Sat, 26 April 2014 08:18 By: Solomon Yakobson
Nested table By: VladGab on Fri, 25 April 2014	8	528	Fri, 25 April 2014 10:06 By: Solomon Yakobson
Comma separated Oracle 11g By: srinivas.k2005 on Fri, 25 April 2014	5	455	Fri, 25 April 2014 09:53 By: Michel Cadot
Find out last four digits Oracle By: Shyam.reddy141 on Thu, 24 April 2014	3	330	Thu, 24 April 2014 13:13 By: Solomon Yakobson
Get information from LDAP By: srivardhan on Wed, 08 July 2009	24	7653	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	257	Thu, 24 April 2014 10:12 By: smedvid