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
icon7.gif Number Conversion
Oracle 10g
By: maanosajnabi on Wed, 06 December 2017
2 3180 Wed, 06 December 2017 03:58
By: maanosajnabi
  Term Match with Jaro-Winkler logic
11
By: OracleUser2017 on Fri, 01 December 2017
14 10403 Tue, 05 December 2017 10:48
By: Barbara Boehmer
  remove duplicate values by date
all
By: laredoeneko on Tue, 28 November 2017
8 8012 Tue, 05 December 2017 07:10
By: Bill B
  SQL Query
11g
By: LKT on Fri, 01 December 2017
11 7958 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 13424 Fri, 01 December 2017 10:27
By: Michel Cadot
  regexp_replace() function help
By: wtolentino on Thu, 30 November 2017
9 5610 Fri, 01 December 2017 08:57
By: wtolentino
  Function Creation
By: WhoAmI on Wed, 29 November 2017
5 4653 Thu, 30 November 2017 03:31
By: cookiemonster
  switch data positions
By: wtolentino on Tue, 28 November 2017
4 4640 Wed, 29 November 2017 11:06
By: wtolentino
  trigger impacting performance
11g32 linux(RHEL)
By: dba4oracle on Tue, 28 November 2017
14 6201 Wed, 29 November 2017 06:05
By: dba4oracle
  Packages
By: rkapex on Sat, 25 November 2017
6 5146 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 27078 Mon, 27 November 2017 06:01
By: ssyr
  Procedure
By: rkapex on Sat, 25 November 2017
3 4791 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 3875 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 6036 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 34017 Sat, 25 November 2017 23:01
By: OraFerro
  Oracle Sub-query and AND clause behaviour
11g
By: LKT on Sun, 19 November 2017
3 4341 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 5246 Fri, 24 November 2017 02:20
By: Littlefoot
  Drop Function gives error
oracle 12c Windows 2012
By: muthukrish104 on Fri, 17 November 2017
6 5951 Wed, 22 November 2017 07:05
By: BlackSwan
  how can get Three consecutive days
By: hassan08 on Fri, 17 November 2017
5 5298 Mon, 20 November 2017 05:21
By: Solomon Yakobson
  grouping in matrix
12c
By: m.abdulhaq on Sun, 19 November 2017
3 4226 Mon, 20 November 2017 05:02
By: Solomon Yakobson
  Query Analysis
Oracle 12c
By: srinivas.k2005 on Mon, 20 November 2017
7 4745 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 4365 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 17608 Sun, 19 November 2017 14:23
By: ashisheck
  REGEXP_SUBSTR
ORACLE,12C,UNIX
By: pstanand on Fri, 17 November 2017
4 4350 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 39056 Fri, 17 November 2017 05:35
By: malflowers
  oracle external table issue
oracle 11g
By: POGAKU_SANTHOSH on Sun, 12 November 2017
6 4865 Sun, 12 November 2017 11:51
By: POGAKU_SANTHOSH
  update query
11.2.0.4
By: grpatwari on Wed, 08 November 2017
9 46818 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 34458 Thu, 09 November 2017 07:10
By: EdStevens
  query datewise howmany records
oracle 12c
By: mvrkr44 on Thu, 09 November 2017
4 14039 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 34004 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 28173 Tue, 07 November 2017 08:18
By: Bill B
  how can get five days
By: hassan08 on Fri, 03 November 2017
11 216894 Mon, 06 November 2017 02:02
By: quirks
  Prevent deletion
12c
By: m.abdulhaq on Fri, 03 November 2017
8 7242 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 9316 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 65774 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 180729 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 443049 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 271960 Thu, 02 November 2017 04:15
By: cookiemonster
  NO_CPU_COSTING hint
Oracle 12c
By: srinivas.k2005 on Mon, 30 October 2017
3 119858 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 76578 Sat, 28 October 2017 19:19
By: Barbara Boehmer
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: Fri Sep 27 11:33:27 CDT 2024