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
  Query contain MODEL cause "column not allowed here" in select statement
By: vincenttic on Mon, 01 January 2018
4 824 Tue, 02 January 2018 21:00
By: vincenttic
  Function or filter in hierarchy query
12c
By: m.abdulhaq on Tue, 26 December 2017
4 1260 Tue, 02 January 2018 02:09
By: quirks
  dense_rank performance
By: shahzad-ul-hasan on Sat, 30 December 2017
1 1116 Sat, 30 December 2017 08:07
By: BlackSwan
  Cant use replication from SQL Server 2008 to Sybase?
sql-server 2008
By: luveshan on Sat, 30 December 2017
1 1038 Sat, 30 December 2017 02:17
By: Littlefoot
  regexp_substr
12c
By: m.abdulhaq on Tue, 26 December 2017
6 1190 Fri, 29 December 2017 10:57
By: Littlefoot
  mysql and oracle issue using dblink
By: nicolewells on Fri, 29 December 2017
2 912 Fri, 29 December 2017 07:54
By: EdStevens
  last date of the year
By: sshree12 on Wed, 27 December 2017
3 940 Thu, 28 December 2017 07:40
By: joy_division
  current date - preovious date calculations
By: sshree12 on Tue, 26 December 2017
18 1885 Wed, 27 December 2017 21:59
By: Barbara Boehmer
  over partition by
By: sshree12 on Wed, 27 December 2017
14 1231 Wed, 27 December 2017 09:02
By: sshree12
  Open cursor
11g32 linux(RHEL)
By: dba4oracle on Wed, 27 December 2017
2 619 Wed, 27 December 2017 06:20
By: dba4oracle
  Set timestamp with milliseconds to default to 0 milliseconds
Oracle 11g
By: pallaviprakash on Tue, 26 December 2017
2 637 Wed, 27 December 2017 00:44
By: Littlefoot
  Create a combination DML Trigger
Oracle 11gr2, multiple OS platform
By: trantuananh24hg on Sun, 24 December 2017
5 1109 Tue, 26 December 2017 12:22
By: joy_division
  How To Delete older data less than 10 years
Oracle11g
By: ssyr on Fri, 15 December 2017
18 2322 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 1132 Fri, 22 December 2017 02:50
By: pavan_mrt
  How to cast collection in table
By: purnima1 on Wed, 20 December 2017
4 1085 Thu, 21 December 2017 22:29
By: BlackSwan
  CLOB to file
Oracle 11g, Win 7
By: rajivn786 on Thu, 21 December 2017
1 615 Thu, 21 December 2017 11:49
By: BlackSwan
  LIKE Operator in MERGE
Oracle,12c,Unix
By: pstanand on Thu, 21 December 2017
6 611 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 1086 Wed, 20 December 2017 08:18
By: joy_division
  create table in another schema
By: malu on Wed, 13 December 2017
6 1034 Wed, 20 December 2017 07:56
By: BlackSwan
  Help regarding regexp_substr
oracle 11g
By: POGAKU_SANTHOSH on Wed, 20 December 2017
3 552 Wed, 20 December 2017 07:13
By: Solomon Yakobson
  Oracle 12c injection
Oracle 12c
By: SoratoMan on Mon, 18 December 2017
1 499 Tue, 19 December 2017 00:43
By: Littlefoot
  Error When Refreshing Materialized View
Oracle 10g
By: ANU_IN on Sun, 17 December 2017
2 811 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 1527 Fri, 15 December 2017 07:40
By: BlackSwan
  existing state of package - Invalidated
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 14 December 2017
6 980 Fri, 15 December 2017 01:00
By: Michel Cadot
  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 1700 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 571 Thu, 14 December 2017 01:36
By: msol25
  Retrieve column names with aliases
Oracle 10g
By: ananya.saphira on Tue, 12 December 2017
7 794 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 684 Tue, 12 December 2017 05:09
By: John Watson
  i need to know hows this happening?
By: amul on Wed, 19 July 2006
8 1161 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 1017 Fri, 08 December 2017 11:53
By: Michel Cadot
  sequence problem?
forms 6i , 11g db
By: Amjad_1975 on Sat, 02 December 2017
23 2571 Fri, 08 December 2017 06:18
By: EdStevens
  How to convert column to rows
Oracle 11g
By: sss111ind on Fri, 08 December 2017
1 659 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 1322 Wed, 06 December 2017 09:30
By: shawaj
icon7.gif Number Conversion
Oracle 10g
By: maanosajnabi on Wed, 06 December 2017
2 461 Wed, 06 December 2017 03:58
By: maanosajnabi
  Term Match with Jaro-Winkler logic
11
By: OracleUser2017 on Fri, 01 December 2017
14 2256 Tue, 05 December 2017 10:48
By: Barbara Boehmer
  remove duplicate values by date
all
By: laredoeneko on Tue, 28 November 2017
8 1586 Tue, 05 December 2017 07:10
By: Bill B
  SQL Query
11g
By: LKT on Fri, 01 December 2017
11 1751 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 2288 Fri, 01 December 2017 10:27
By: Michel Cadot
  regexp_replace() function help
By: wtolentino on Thu, 30 November 2017
9 1348 Fri, 01 December 2017 08:57
By: wtolentino
  Function Creation
By: WhoAmI on Wed, 29 November 2017
5 893 Thu, 30 November 2017 03:31
By: cookiemonster
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: Sat May 26 14:38:18 CDT 2018