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
  display all numbers with like
11g
By: glmjoy on Wed, 28 December 2016
4 430 Wed, 28 December 2016 08:12
By: Michel Cadot
  ROLLBACK usingTRUNCATE
Oracle 11.2.0.3
By: pointers on Mon, 26 December 2016
5 598 Tue, 27 December 2016 10:01
By: Michel Cadot
icon5.gif ORA-01426 "Numeric Overflow"
By: challa384 on Tue, 27 December 2016
5 548 Tue, 27 December 2016 07:32
By: Bill B
  How to bypass the selective rows from SQL Analytic function
Oracle 11.2.0.1.0
By: jimit_shaili on Fri, 23 December 2016
4 669 Sat, 24 December 2016 08:41
By: Solomon Yakobson
  Order By Taking time
Oracle
By: mskphani on Thu, 22 December 2016
4 755 Fri, 23 December 2016 11:19
By: Michel Cadot
  DB-LINK to mysql
Oracle Database 11g Release 11.2.0.1.0
By: iliyan_84@abv.bg on Wed, 21 December 2016
20 1157 Fri, 23 December 2016 07:25
By: iliyan_84@abv.bg
  Quantity allocation to discount slabs
Oracle 11.2.0.1.0
By: jimit_shaili on Mon, 19 December 2016
4 709 Fri, 23 December 2016 03:07
By: jimit_shaili
  transforming rows to columns
oracle 10 G and 11 G
By: akash123 on Thu, 22 December 2016
10 618 Thu, 22 December 2016 23:56
By: akash123
  Convert a sys refcursor into table
11g R2
By: Sravz on Thu, 15 December 2016
18 1761 Wed, 21 December 2016 08:40
By: Solomon Yakobson
  sorting of an alphanumeric value through oracle pl/sql
By: PR22 on Mon, 19 December 2016
6 801 Tue, 20 December 2016 06:51
By: John Watson
  DEFAULT Value Behavior
Oracle 11
By: saipradyumn on Fri, 16 December 2016
10 1481 Tue, 20 December 2016 05:33
By: saipradyumn
  how to generate an email on a database event?
Oracle Database, 10g, Windows Server-2003
By: mazam on Sun, 15 May 2011
14 1849 Fri, 16 December 2016 06:41
By: EdStevens
  dynamic sql to grant privilege
11g
By: raj85844 on Wed, 30 November 2016
17 1627 Fri, 16 December 2016 05:24
By: raj85844
  Extract directory path from a datafile name
11.2.x and 12.x, Windows
By: John Watson on Thu, 15 December 2016
13 1058 Fri, 16 December 2016 04:41
By: cookiemonster
  Skipping code in a procedure?
SQL Developer 1.5.5
By: MyLastGamble on Thu, 15 December 2016
11 1103 Fri, 16 December 2016 03:12
By: cookiemonster
  Hierarchy Query Help
Oracle 11g
By: SADASIVAM on Thu, 15 December 2016
0 401 Thu, 15 December 2016 08:06
By: SADASIVAM
  ORA-01722: invalid number ORA-02063: preceding line from
By: mist598 on Thu, 15 December 2016
3 477 Thu, 15 December 2016 03:07
By: Michel Cadot
  Concatenating an array output into one single string
O/S:Windows 8; Product: Oracle; version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: buggleboy007 on Mon, 15 December 2014
12 1895 Thu, 15 December 2016 01:47
By: Michel Cadot
  Update Vs Delete&insertion
Oracle 11
By: saipradyumn on Mon, 12 December 2016
9 576 Thu, 15 December 2016 00:47
By: saipradyumn
  Bulk bind a single attribute of a collection
Oracle 11.2.0.3
By: pointers on Wed, 14 December 2016
2 295 Wed, 14 December 2016 21:11
By: Barbara Boehmer
  Comparing CAST (multiset) with Bulk Collect
11.0.2.10
By: OraFerro on Wed, 14 December 2016
4 539 Wed, 14 December 2016 06:59
By: Solomon Yakobson
  Sending a Password protected PDF using utl_smtp
By: dineshkumar18 on Mon, 12 December 2016
8 745 Tue, 13 December 2016 08:09
By: Michel Cadot
  Help in Listagg Query???
Oracle 11g
By: arifs3738 on Tue, 13 December 2016
3 385 Tue, 13 December 2016 03:14
By: pablolee
  AND criteria in where clause
By: blyzz on Wed, 07 December 2016
5 544 Mon, 12 December 2016 07:20
By: Solomon Yakobson
  Package Specification varaible
Oracle 11g
By: saipradyumn on Wed, 07 December 2016
14 944 Fri, 09 December 2016 10:39
By: Michel Cadot
  Long data type in oracle
Oracle 11
By: saipradyumn on Tue, 06 December 2016
20 1188 Fri, 09 December 2016 09:51
By: BlackSwan
  create trigger error in SQL
By: equa on Fri, 09 December 2016
2 447 Fri, 09 December 2016 03:00
By: Michel Cadot
  ORA-30006 Resource Busy, acquired with Wait timeout expired
Oracle 10g, Forms 6i
By: chat2raj.s on Thu, 08 December 2016
13 1227 Thu, 08 December 2016 06:35
By: chat2raj.s
icon3.gif Trigger on Materialized View Log tables
ORACLE 11G Version 11.2.0.3.0
By: arunrajv@yahoo.com on Wed, 07 December 2016
7 557 Wed, 07 December 2016 23:02
By: arunrajv@yahoo.com
  Outer Joins and To_Char
Oracle 9
By: nigelcg on Tue, 01 April 2008
2 6560 Wed, 07 December 2016 15:05
By: las911
  External tables (.csv)
Oracle 10g, Windows Server 2003 ( 1 2)
By: Rodrignra on Tue, 26 April 2011
53 21359 Wed, 07 December 2016 12:14
By: rizuane
  Correct order of data in Hierarchical Query
Oracle 12c
By: ramjss on Sat, 19 November 2016
13 1158 Tue, 06 December 2016 04:29
By: ramjss
  SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result
By: pcouas on Mon, 05 December 2016
7 489 Tue, 06 December 2016 01:03
By: Michel Cadot
  materialize view logs rfresh
oracle 11gr2
By: guddu_12 on Fri, 02 December 2016
5 949 Mon, 05 December 2016 08:29
By: Bill B
  Query For N number to top Sales in Region
oracle 10 g
By: annu-agi on Sun, 04 December 2016
6 424 Mon, 05 December 2016 01:18
By: Michel Cadot
  Element exists in a collection
Oracle 11.2.0.3
By: pointers on Fri, 02 December 2016
3 640 Fri, 02 December 2016 06:43
By: Solomon Yakobson
  How to check if time is attached with date?
10.2.0
By: bluetooth420 on Wed, 30 November 2016
11 944 Fri, 02 December 2016 03:14
By: cookiemonster
  ora-06504 PL/SQL: Return types of Result Set variables or query do not match
By: v4goel on Thu, 25 October 2007
11 11048 Thu, 01 December 2016 12:39
By: Michel Cadot
  Function MAX
Oracle 11g
By: tomekw on Thu, 01 December 2016
3 458 Thu, 01 December 2016 10:08
By: Michel Cadot
  how to search for two characters in any sequence, with or without alphanumeric characters in between
Oracle 11g, 12c
By: namitanamburi on Tue, 29 November 2016
13 720 Tue, 29 November 2016 15:36
By: Bill B
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 Jun 27 17:30:02 CDT 2017

Total time taken to generate the page: 0.19035 seconds