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
  Validate an IP Range
PL/SQL
By: praveenramaswamy on Wed, 07 May 2014
10 373 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 478 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 367 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 280 Wed, 07 May 2014 07:08
By: Solomon Yakobson
  ORA-00905 error
oracle 10g
By: laxmi.oracle on Tue, 06 May 2014
3 368 Wed, 07 May 2014 06:24
By: laxmi.oracle
  Date format in PL/SQL vs. PSP
By: agarfin on Tue, 06 May 2014
6 361 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 572 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 275 Tue, 06 May 2014 07:33
By: Michel Cadot
  webservices
11g
By: usmanelahi on Tue, 06 May 2014
3 245 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 355 Tue, 06 May 2014 02:00
By: Michel Cadot
  Oracle Alphanumeric Sequence
Oracle 11g,win7
By: Xandot on Sun, 04 May 2014
13 718 Tue, 06 May 2014 00:02
By: Michel Cadot
  Creating Table in plsql
By: pratikshamehra on Sat, 03 May 2014
9 437 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 458 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 936 Fri, 02 May 2014 08:01
By: Lalit Kumar B
  How to avoid trigger
By: aaditya321 on Thu, 01 May 2014
8 429 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 383 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 369 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 486 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 291 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 378 Thu, 01 May 2014 03:36
By: srinivas.k2005
  Oracle Roles -- Users -- Grant Privileges
By: praveenramaswamy on Wed, 30 April 2014
11 363 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 460 Wed, 30 April 2014 12:32
By: smedvid
  HSODBC.EXE, unable to find corresponding oracle session
By: praveenramaswamy on Wed, 30 April 2014
2 215 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 377 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 611 Wed, 30 April 2014 08:38
By: Kevin Meade
  oracle sql query
oracle 10g
By: karthik.m1988 on Wed, 30 April 2014
7 348 Wed, 30 April 2014 08:18
By: Michel Cadot
  Merge statement
11g ,window7
By: maheshkumar93 on Tue, 29 April 2014
3 389 Tue, 29 April 2014 08:04
By: cookiemonster
  Oracle View doubt
Oracle 11g
By: Oracle_Walker on Mon, 28 April 2014
4 342 Tue, 29 April 2014 00:13
By: Michel Cadot
  Multi Array - MultiSet - or other??
10.2
By: lott42 on Mon, 28 April 2014
5 321 Mon, 28 April 2014 16:42
By: Barbara Boehmer
  logic Required
Oracle 11g
By: jason346 on Sat, 26 April 2014
4 776 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 803 Mon, 28 April 2014 05:13
By: jason346
  spotting errors (merged 2)
win7 oracle 11g
By: ishan2ma on Mon, 28 April 2014
16 501 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 437 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 950 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 347 Sat, 26 April 2014 08:18
By: Solomon Yakobson
  Nested table
By: VladGab on Fri, 25 April 2014
8 560 Fri, 25 April 2014 10:06
By: Solomon Yakobson
  Comma separated
Oracle 11g
By: srinivas.k2005 on Fri, 25 April 2014
5 479 Fri, 25 April 2014 09:53
By: Michel Cadot
  Find out last four digits
Oracle
By: Shyam.reddy141 on Thu, 24 April 2014
3 352 Thu, 24 April 2014 13:13
By: Solomon Yakobson
  Get information from LDAP
By: srivardhan on Wed, 08 July 2009
24 7883 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 293 Thu, 24 April 2014 10:12
By: smedvid
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: Tue Sep 02 09:26:13 CDT 2014

Total time taken to generate the page: 0.16334 seconds