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
  How To Delete older data less than 10 years
Oracle11g
By: ssyr on Fri, 15 December 2017
18 9104 Sun, 24 December 2017 03:46
By: SmithXu
  Find where exception occurred in oracle procedure
Oracle Plsql, Oracle 12C, Unix/Linux
By: pavan_mrt on Thu, 21 December 2017
6 5128 Fri, 22 December 2017 02:50
By: pavan_mrt
  How to cast collection in table
By: purnima1 on Wed, 20 December 2017
4 5896 Thu, 21 December 2017 22:29
By: BlackSwan
  CLOB to file
Oracle 11g, Win 7
By: rajivn786 on Thu, 21 December 2017
1 3589 Thu, 21 December 2017 11:49
By: BlackSwan
  LIKE Operator in MERGE
Oracle,12c,Unix
By: pstanand on Thu, 21 December 2017
6 4081 Thu, 21 December 2017 07:10
By: cookiemonster
  How to execute a result of another table.
By: pmreddy.mahi@gmail.com on Tue, 19 December 2017
10 5898 Wed, 20 December 2017 08:18
By: joy_division
  create table in another schema
By: malu on Wed, 13 December 2017
6 7667 Wed, 20 December 2017 07:56
By: BlackSwan
  Help regarding regexp_substr
oracle 11g
By: POGAKU_SANTHOSH on Wed, 20 December 2017
3 3900 Wed, 20 December 2017 07:13
By: Solomon Yakobson
  Oracle 12c injection
Oracle 12c
By: SoratoMan on Mon, 18 December 2017
1 3049 Tue, 19 December 2017 00:43
By: Littlefoot
  Error When Refreshing Materialized View
Oracle 10g
By: ANU_IN on Sun, 17 December 2017
2 3561 Mon, 18 December 2017 06:33
By: Bill B
  CREATE VIEW with "SELECT * FROM" several tables
Oracle 11 / Oracle 12
By: Rumak18 on Tue, 12 December 2017
12 6247 Fri, 15 December 2017 07:40
By: BlackSwan
  Need to Retrieve data from JSON file in Oracle sql select query
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Thu, 11 August 2016
10 7280 Thu, 14 December 2017 08:39
By: Michel Cadot
  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 3278 Thu, 14 December 2017 01:36
By: msol25
  Retrieve column names with aliases
Oracle 10g
By: ananya.saphira on Tue, 12 December 2017
7 4194 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 4036 Tue, 12 December 2017 05:09
By: John Watson
  i need to know hows this happening?
By: amul on Wed, 19 July 2006
8 4855 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 4599 Fri, 08 December 2017 11:53
By: Michel Cadot
  sequence problem?
forms 6i , 11g db
By: Amjad_1975 on Sat, 02 December 2017
23 12779 Fri, 08 December 2017 06:18
By: EdStevens
  How to convert column to rows
Oracle 11g
By: sss111ind on Fri, 08 December 2017
1 3355 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 8486 Wed, 06 December 2017 09:30
By: shawaj
icon7.gif Number Conversion
Oracle 10g
By: maanosajnabi on Wed, 06 December 2017
2 2839 Wed, 06 December 2017 03:58
By: maanosajnabi
  Term Match with Jaro-Winkler logic
11
By: OracleUser2017 on Fri, 01 December 2017
14 9808 Tue, 05 December 2017 10:48
By: Barbara Boehmer
  remove duplicate values by date
all
By: laredoeneko on Tue, 28 November 2017
8 7563 Tue, 05 December 2017 07:10
By: Bill B
  SQL Query
11g
By: LKT on Fri, 01 December 2017
11 7436 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 12656 Fri, 01 December 2017 10:27
By: Michel Cadot
  regexp_replace() function help
By: wtolentino on Thu, 30 November 2017
9 5181 Fri, 01 December 2017 08:57
By: wtolentino
  Function Creation
By: WhoAmI on Wed, 29 November 2017
5 4269 Thu, 30 November 2017 03:31
By: cookiemonster
  switch data positions
By: wtolentino on Tue, 28 November 2017
4 4319 Wed, 29 November 2017 11:06
By: wtolentino
  trigger impacting performance
11g32 linux(RHEL)
By: dba4oracle on Tue, 28 November 2017
14 5708 Wed, 29 November 2017 06:05
By: dba4oracle
  Packages
By: rkapex on Sat, 25 November 2017
6 4774 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 26030 Mon, 27 November 2017 06:01
By: ssyr
  Procedure
By: rkapex on Sat, 25 November 2017
3 4512 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 3561 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 5604 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 32493 Sat, 25 November 2017 23:01
By: OraFerro
  Oracle Sub-query and AND clause behaviour
11g
By: LKT on Sun, 19 November 2017
3 4033 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 4900 Fri, 24 November 2017 02:20
By: Littlefoot
  Drop Function gives error
oracle 12c Windows 2012
By: muthukrish104 on Fri, 17 November 2017
6 5512 Wed, 22 November 2017 07:05
By: BlackSwan
  how can get Three consecutive days
By: hassan08 on Fri, 17 November 2017
5 4905 Mon, 20 November 2017 05:21
By: Solomon Yakobson
  grouping in matrix
12c
By: m.abdulhaq on Sun, 19 November 2017
3 3841 Mon, 20 November 2017 05:02
By: Solomon Yakobson
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 Apr 19 09:54:17 CDT 2024