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
icon5.gif Unable to grant Admin privileges on SQL Developer 12c
Oracle SQL Developer 12c
By: Dave0001 on Fri, 24 November 2017
6 4930 Fri, 24 November 2017 02:20
By: Littlefoot
  Drop Function gives error
oracle 12c Windows 2012
By: muthukrish104 on Fri, 17 November 2017
6 5547 Wed, 22 November 2017 07:05
By: BlackSwan
  how can get Three consecutive days
By: hassan08 on Fri, 17 November 2017
5 4932 Mon, 20 November 2017 05:21
By: Solomon Yakobson
  grouping in matrix
12c
By: m.abdulhaq on Sun, 19 November 2017
3 3875 Mon, 20 November 2017 05:02
By: Solomon Yakobson
  Query Analysis
Oracle 12c
By: srinivas.k2005 on Mon, 20 November 2017
7 4348 Mon, 20 November 2017 04:53
By: srinivas.k2005
  Passing warning collection from PL/SQL
11.0.2.10
By: OraFerro on Sun, 19 November 2017
2 4050 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 16824 Sun, 19 November 2017 14:23
By: ashisheck
  REGEXP_SUBSTR
ORACLE,12C,UNIX
By: pstanand on Fri, 17 November 2017
4 3971 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 36969 Fri, 17 November 2017 05:35
By: malflowers
  oracle external table issue
oracle 11g
By: POGAKU_SANTHOSH on Sun, 12 November 2017
6 4444 Sun, 12 November 2017 11:51
By: POGAKU_SANTHOSH
  update query
11.2.0.4
By: grpatwari on Wed, 08 November 2017
9 46245 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 34093 Thu, 09 November 2017 07:10
By: EdStevens
  query datewise howmany records
oracle 12c
By: mvrkr44 on Thu, 09 November 2017
4 13600 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 33533 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 27732 Tue, 07 November 2017 08:18
By: Bill B
  how can get five days
By: hassan08 on Fri, 03 November 2017
11 216356 Mon, 06 November 2017 02:02
By: quirks
  Prevent deletion
12c
By: m.abdulhaq on Fri, 03 November 2017
8 6768 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 8989 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 65421 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 180365 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 442603 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 271614 Thu, 02 November 2017 04:15
By: cookiemonster
  NO_CPU_COSTING hint
Oracle 12c
By: srinivas.k2005 on Mon, 30 October 2017
3 119439 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 75952 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 4475 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 40629 Tue, 24 October 2017 11:57
By: srinivas.k2005
  Using Oracle Parallel hint
By: martjosh on Tue, 17 October 2017
9 69577 Tue, 24 October 2017 08:07
By: BlackSwan
  Changing the date format on a specific field
By: amandasmile on Wed, 18 October 2017
10 44808 Mon, 23 October 2017 07:41
By: Bill B
  virtual private database
oracle database 12c
By: smaher on Fri, 20 October 2017
4 5149 Sat, 21 October 2017 04:16
By: Michel Cadot
  REPLACE Function
Oracle,12c,Unix
By: pstanand on Fri, 20 October 2017
6 87307 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 40711 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 140078 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 59000 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 63588 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 48722 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 72243 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 74710 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 122479 Tue, 10 October 2017 09:28
By: cookiemonster
  row-to-row navigation query
By: martjosh on Thu, 05 October 2017
11 312286 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 161409 Tue, 10 October 2017 09:17
By: quirks
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: Wed May 01 16:04:19 CDT 2024