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
  Passing warning collection from PL/SQL
11.0.2.10
By: OraFerro on Sun, 19 November 2017
2 608 Sun, 19 November 2017 22:27
By: OraFerro
  ora 01882
Sql Developer, 1.5.1.54.40, Windows Server 2003
By: getritesh on Tue, 25 May 2010
24 8582 Sun, 19 November 2017 14:23
By: ashisheck
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
2 665 Sat, 18 November 2017 09:47
By: mmation
  REGEXP_SUBSTR
ORACLE,12C,UNIX
By: pstanand on Fri, 17 November 2017
4 643 Fri, 17 November 2017 10:21
By: pstanand
  PL/SQL: SQL Statement Ignored
ORACLE XE sql developer version 17.3.0.271
By: malflowers on Thu, 16 November 2017
9 906 Fri, 17 November 2017 05:35
By: malflowers
  oracle external table issue
oracle 11g
By: POGAKU_SANTHOSH on Sun, 12 November 2017
6 725 Sun, 12 November 2017 11:51
By: POGAKU_SANTHOSH
  update query
11.2.0.4
By: grpatwari on Wed, 08 November 2017
9 30454 Fri, 10 November 2017 01:43
By: Michel Cadot
  MATERIALIZED VIEW
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
By: shawaj on Wed, 08 November 2017
7 22196 Thu, 09 November 2017 07:10
By: EdStevens
  query datewise howmany records
oracle 12c
By: mvrkr44 on Thu, 09 November 2017
4 8296 Thu, 09 November 2017 04:14
By: mvrkr44
  Re: PL/SQL:How to use VARRAY in the USING clause of EXECUTE IMMEDIATE? split from http://www.orafaq.com/forum/t/161791/
By: moracles on Tue, 11 July 2017
10 22114 Thu, 09 November 2017 04:00
By: moracles
  Order of Trigger Types
11g Release 11.2.0.3.0
By: whdyck on Mon, 06 November 2017
4 17715 Tue, 07 November 2017 08:18
By: Bill B
  how can get five days
By: hassan08 on Fri, 03 November 2017
11 161114 Mon, 06 November 2017 02:02
By: quirks
  Prevent deletion
12c
By: m.abdulhaq on Fri, 03 November 2017
8 1889 Sat, 04 November 2017 10:39
By: m.abdulhaq
  ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
Oracle8i Enterprise Edition Release 8.1.7.0.0 /windows7
By: shawaj on Fri, 03 November 2017
3 1706 Sat, 04 November 2017 03:40
By: Littlefoot
  TABLE PARTITIONING
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
By: shawaj on Thu, 02 November 2017
3 39117 Fri, 03 November 2017 07:55
By: shawaj
  ORA-06502: PL/SQL: numeric or value error.
Oracle 4.0
By: WhoAmI on Wed, 01 November 2017
9 147392 Fri, 03 November 2017 07:35
By: BlackSwan
  Modify procedure calculation for readability
Oracle 11.2.0.4
By: veepee on Sun, 29 October 2017
17 304085 Thu, 02 November 2017 16:44
By: veepee
  to_char date conversion not working
oracle 11 for Windows 10
By: gunderj on Wed, 01 November 2017
8 188950 Thu, 02 November 2017 04:15
By: cookiemonster
  NO_CPU_COSTING hint
Oracle 12c
By: srinivas.k2005 on Mon, 30 October 2017
3 71471 Tue, 31 October 2017 03:09
By: John Watson
  Multiple Rows to a Single Row
oracle 10g
By: bond007 on Mon, 16 October 2017
20 46811 Sat, 28 October 2017 19:19
By: Barbara Boehmer
  Error 500--Internal Server Error while running oracle Reports to print the pdf in 11g R2[11.1.2.2.0]
Linux,11gR2 11.1.2.2.0 oracle forms and reports, oracle 11g database
By: Beginner_ora on Wed, 25 October 2017
1 605 Wed, 25 October 2017 07:14
By: John Watson
  SQL help on hierarchy data
Oracle 10g and DB2
By: srinivas.k2005 on Sun, 22 October 2017
3 22623 Tue, 24 October 2017 11:57
By: srinivas.k2005
  Using Oracle Parallel hint
By: martjosh on Tue, 17 October 2017
9 39193 Tue, 24 October 2017 08:07
By: BlackSwan
  Changing the date format on a specific field
By: amandasmile on Wed, 18 October 2017
10 22091 Mon, 23 October 2017 07:41
By: Bill B
  virtual private database
oracle database 12c
By: smaher on Fri, 20 October 2017
4 1682 Sat, 21 October 2017 04:16
By: Michel Cadot
  REPLACE Function
Oracle,12c,Unix
By: pstanand on Fri, 20 October 2017
6 60720 Fri, 20 October 2017 08:37
By: pstanand
  DBTime Zone&Off Set
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Revathi.orafaq on Wed, 18 October 2017
2 22833 Fri, 20 October 2017 00:46
By: Revathi.orafaq
  Restrictions on DDL-triggers in PL/SQL
Oracle XE 11.2.0.2 on Windows 10
By: Alien on Wed, 18 October 2017
3 79817 Thu, 19 October 2017 08:06
By: Alien
  Passing UDT as a SP parameter
11.0.2.10
By: OraFerro on Mon, 16 October 2017
4 33622 Tue, 17 October 2017 03:26
By: OraFerro
  How to extract out huge result set in xml format as .xml file
12.1.0.2
By: philipebe on Mon, 16 October 2017
1 36729 Mon, 16 October 2017 15:01
By: BlackSwan
  Composite Partitioning
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Revathi.orafaq on Mon, 16 October 2017
2 27732 Mon, 16 October 2017 07:02
By: Revathi.orafaq
  Combination of more/less and brackets cause TRUE or FALSE (merged 2)
Oracle DB 12c
By: isri on Thu, 12 October 2017
3 41871 Thu, 12 October 2017 04:57
By: isri
  returning collection from a loop and bulk collect
Oracle 11
By: roger6701 on Tue, 10 October 2017
10 51426 Tue, 10 October 2017 16:00
By: roger6701
  Heterogeneous DB error propagating past WHEN OTHERS
Oracle 11gR2, SQL Server 2008
By: EricS13 on Mon, 09 October 2017
6 68956 Tue, 10 October 2017 09:28
By: cookiemonster
  row-to-row navigation query
By: martjosh on Thu, 05 October 2017
11 36605 Tue, 10 October 2017 09:26
By: quirks
  Show multiple count in one result set
Oracle 12c
By: fabi88 on Mon, 09 October 2017
6 93351 Tue, 10 October 2017 09:17
By: quirks
  Left Outer Join with SubQuery
By: suji6281 on Fri, 22 September 2017
4 11911 Tue, 10 October 2017 07:12
By: suji6281
  Finding characters other than keyboard character
Oracle 10g
By: sss111ind on Wed, 20 September 2017
6 40086 Mon, 09 October 2017 05:38
By: sss111ind
  SQL Query Help
SQL Developer
By: reddy0422 on Sun, 08 October 2017
1 77606 Sun, 08 October 2017 08:41
By: BlackSwan
  Using WITH clause values as parameters in a TABLE function
Oracle 11.2.0.4 on Windows 7 64bit
By: orabert on Thu, 05 October 2017
2 16439 Thu, 05 October 2017 16:30
By: orabert
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: Sun Dec 17 06:24:38 CST 2017

Total time taken to generate the page: 0.01248 seconds