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
  malformed cursor
oracle 12c
By: desmond30 on Thu, 11 January 2018
8 5204 Thu, 11 January 2018 09:10
By: cookiemonster
  PL/SQL procedure issue
Windows
By: nicolewells on Sun, 07 January 2018
12 11361 Thu, 11 January 2018 00:17
By: Littlefoot
  Change the order of records in some variables
By: habitusantos on Mon, 08 January 2018
6 6327 Tue, 09 January 2018 06:36
By: Littlefoot
  Recording Update through trigger based on csv file upload
By: oracbeg on Thu, 04 January 2018
3 4877 Sun, 07 January 2018 22:33
By: oracbeg
  SQL query
oracle xe 11g
By: hudo on Fri, 05 January 2018
4 4701 Fri, 05 January 2018 10:54
By: Michel Cadot
  printing first day of every month
oracle 10g
By: kumarravik on Mon, 01 January 2018
8 10577 Fri, 05 January 2018 07:16
By: Solomon Yakobson
  Procedure with multiple search filter
Oracle 10g
By: Danny Freeman on Wed, 03 January 2018
6 5540 Thu, 04 January 2018 13:50
By: EdStevens
  Why does Oracle rename the bind variable?
Oracle 11.2.0.3
By: SmithXu on Sun, 31 December 2017
7 7187 Thu, 04 January 2018 05:56
By: _jum
  Query contain MODEL cause "column not allowed here" in select statement
By: vincenttic on Mon, 01 January 2018
4 5373 Tue, 02 January 2018 21:00
By: vincenttic
  Function or filter in hierarchy query
12c
By: m.abdulhaq on Tue, 26 December 2017
4 5315 Tue, 02 January 2018 02:09
By: quirks
  dense_rank performance
By: shahzad-ul-hasan on Sat, 30 December 2017
1 4215 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 4643 Sat, 30 December 2017 02:17
By: Littlefoot
  regexp_substr
12c
By: m.abdulhaq on Tue, 26 December 2017
6 6314 Fri, 29 December 2017 10:57
By: Littlefoot
  mysql and oracle issue using dblink
By: nicolewells on Fri, 29 December 2017
2 4732 Fri, 29 December 2017 07:54
By: EdStevens
  last date of the year
By: sshree12 on Wed, 27 December 2017
3 4751 Thu, 28 December 2017 07:40
By: joy_division
  current date - preovious date calculations
By: sshree12 on Tue, 26 December 2017
18 11452 Wed, 27 December 2017 21:59
By: Barbara Boehmer
  over partition by
By: sshree12 on Wed, 27 December 2017
14 10864 Wed, 27 December 2017 09:02
By: sshree12
  Open cursor
11g32 linux(RHEL)
By: dba4oracle on Wed, 27 December 2017
2 3328 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 7148 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 4982 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 9608 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 5463 Fri, 22 December 2017 02:50
By: pavan_mrt
  How to cast collection in table
By: purnima1 on Wed, 20 December 2017
4 6311 Thu, 21 December 2017 22:29
By: BlackSwan
  CLOB to file
Oracle 11g, Win 7
By: rajivn786 on Thu, 21 December 2017
1 3964 Thu, 21 December 2017 11:49
By: BlackSwan
  LIKE Operator in MERGE
Oracle,12c,Unix
By: pstanand on Thu, 21 December 2017
6 4509 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 6482 Wed, 20 December 2017 08:18
By: joy_division
  create table in another schema
By: malu on Wed, 13 December 2017
6 8261 Wed, 20 December 2017 07:56
By: BlackSwan
  Help regarding regexp_substr
oracle 11g
By: POGAKU_SANTHOSH on Wed, 20 December 2017
3 4281 Wed, 20 December 2017 07:13
By: Solomon Yakobson
  Oracle 12c injection
Oracle 12c
By: SoratoMan on Mon, 18 December 2017
1 3405 Tue, 19 December 2017 00:43
By: Littlefoot
  Error When Refreshing Materialized View
Oracle 10g
By: ANU_IN on Sun, 17 December 2017
2 3937 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 6899 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 7898 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 3637 Thu, 14 December 2017 01:36
By: msol25
  Retrieve column names with aliases
Oracle 10g
By: ananya.saphira on Tue, 12 December 2017
7 4685 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 4436 Tue, 12 December 2017 05:09
By: John Watson
  i need to know hows this happening?
By: amul on Wed, 19 July 2006
8 5381 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 5038 Fri, 08 December 2017 11:53
By: Michel Cadot
  sequence problem?
forms 6i , 11g db
By: Amjad_1975 on Sat, 02 December 2017
23 13716 Fri, 08 December 2017 06:18
By: EdStevens
  How to convert column to rows
Oracle 11g
By: sss111ind on Fri, 08 December 2017
1 3714 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 9181 Wed, 06 December 2017 09:30
By: shawaj
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 09:07:36 CDT 2024