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
  Help for getting information where external table used in database
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: msol25 on Thu, 14 December 2017
2 2210 Thu, 14 December 2017 01:36
By: msol25
  Retrieve column names with aliases
Oracle 10g
By: ananya.saphira on Tue, 12 December 2017
7 2751 Tue, 12 December 2017 15:14
By: joy_division
  ORA-01502: index or partition of such index is in usable
Oracle 12C (12.1.0.2.0)
By: takwadin on Tue, 12 December 2017
3 2969 Tue, 12 December 2017 05:09
By: John Watson
  i need to know hows this happening?
By: amul on Wed, 19 July 2006
8 3530 Mon, 11 December 2017 09:30
By: appailoveyou
  Temporary LOBs, temp space, PGA
DB 12.x
By: John Watson on Fri, 08 December 2017
3 3142 Fri, 08 December 2017 11:53
By: Michel Cadot
  sequence problem?
forms 6i , 11g db
By: Amjad_1975 on Sat, 02 December 2017
23 9019 Fri, 08 December 2017 06:18
By: EdStevens
  How to convert column to rows
Oracle 11g
By: sss111ind on Fri, 08 December 2017
1 2347 Fri, 08 December 2017 01:49
By: sss111ind
  Help in Query for Required output
Oracle8i Enterprise Edition Release 8.1.7.0.0
By: shawaj on Tue, 05 December 2017
17 5904 Wed, 06 December 2017 09:30
By: shawaj
icon7.gif Number Conversion
Oracle 10g
By: maanosajnabi on Wed, 06 December 2017
2 2065 Wed, 06 December 2017 03:58
By: maanosajnabi
  Term Match with Jaro-Winkler logic
11
By: OracleUser2017 on Fri, 01 December 2017
14 7114 Tue, 05 December 2017 10:48
By: Barbara Boehmer
  remove duplicate values by date
all
By: laredoeneko on Tue, 28 November 2017
8 5702 Tue, 05 December 2017 07:10
By: Bill B
  SQL Query
11g
By: LKT on Fri, 01 December 2017
11 5342 Mon, 04 December 2017 03:02
By: Michel Cadot
  Difference in SQL 'order by' and MIN, MAX, LISTAGG results
oracle 12c, client 11G sous windows
By: moracles on Thu, 30 November 2017
25 9468 Fri, 01 December 2017 10:27
By: Michel Cadot
  regexp_replace() function help
By: wtolentino on Thu, 30 November 2017
9 3608 Fri, 01 December 2017 08:57
By: wtolentino
  Function Creation
By: WhoAmI on Wed, 29 November 2017
5 3256 Thu, 30 November 2017 03:31
By: cookiemonster
  switch data positions
By: wtolentino on Tue, 28 November 2017
4 3083 Wed, 29 November 2017 11:06
By: wtolentino
  trigger impacting performance
11g32 linux(RHEL)
By: dba4oracle on Tue, 28 November 2017
14 4330 Wed, 29 November 2017 06:05
By: dba4oracle
  Packages
By: rkapex on Sat, 25 November 2017
6 3569 Mon, 27 November 2017 08:04
By: Bill B
  How to Avoid ORA-01438: value larger than specified precision allowed for this column
Oracle11g
By: ssyr on Fri, 24 November 2017
23 19031 Mon, 27 November 2017 06:01
By: ssyr
  Procedure
By: rkapex on Sat, 25 November 2017
3 3092 Mon, 27 November 2017 03:25
By: cookiemonster
  Using views to summarise payment info
Oracle SQL 12
By: Rugad on Sun, 26 November 2017
1 2523 Sun, 26 November 2017 16:44
By: BlackSwan
  help convert mac address string to hex
oracle 12c
By: laredoeneko on Sun, 26 November 2017
7 3475 Sun, 26 November 2017 14:16
By: EdStevens
  Array ORA-06533: Subscript beyond count
11.0.2.10
By: OraFerro on Wed, 22 November 2017
8 18632 Sat, 25 November 2017 23:01
By: OraFerro
  Oracle Sub-query and AND clause behaviour
11g
By: LKT on Sun, 19 November 2017
3 2897 Fri, 24 November 2017 09:11
By: Bill B
icon5.gif Unable to grant Admin privileges on SQL Developer 12c
Oracle SQL Developer 12c
By: Dave0001 on Fri, 24 November 2017
6 3341 Fri, 24 November 2017 02:20
By: Littlefoot
  Drop Function gives error
oracle 12c Windows 2012
By: muthukrish104 on Fri, 17 November 2017
6 4067 Wed, 22 November 2017 07:05
By: BlackSwan
  how can get Three consecutive days
By: hassan08 on Fri, 17 November 2017
5 3596 Mon, 20 November 2017 05:21
By: Solomon Yakobson
  grouping in matrix
12c
By: m.abdulhaq on Sun, 19 November 2017
3 2753 Mon, 20 November 2017 05:02
By: Solomon Yakobson
  Query Analysis
Oracle 12c
By: srinivas.k2005 on Mon, 20 November 2017
7 3317 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 2896 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 12999 Sun, 19 November 2017 14:23
By: ashisheck
  REST API with DDOS protection
ORACLE 12c
By: mmation on Fri, 17 November 2017
2 2814 Sat, 18 November 2017 09:47
By: mmation
  REGEXP_SUBSTR
ORACLE,12C,UNIX
By: pstanand on Fri, 17 November 2017
4 2920 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 17540 Fri, 17 November 2017 05:35
By: malflowers
  oracle external table issue
oracle 11g
By: POGAKU_SANTHOSH on Sun, 12 November 2017
6 3205 Sun, 12 November 2017 11:51
By: POGAKU_SANTHOSH
  update query
11.2.0.4
By: grpatwari on Wed, 08 November 2017
9 44204 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 32514 Thu, 09 November 2017 07:10
By: EdStevens
  query datewise howmany records
oracle 12c
By: mvrkr44 on Thu, 09 November 2017
4 12611 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 31308 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 25972 Tue, 07 November 2017 08:18
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: Wed Nov 25 05:29:05 CST 2020