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
  Oracle PLSQL validate a row and insert each cell value of row as a new row with validation results i
oracle
By: hareesh996 on Sat, 17 February 2018
10 3410 Mon, 19 February 2018 05:24
By: quirks
  Need help with insert in Oracle
Oracle SQL Developer
By: victor_pulga on Sat, 17 February 2018
11 3762 Mon, 19 February 2018 04:12
By: quirks
  BULK COLLECT ISSUE
Oracle 12C, Unix
By: bahubcd on Wed, 14 February 2018
4 1712 Thu, 15 February 2018 00:09
By: Michel Cadot
  How to get the functions name used by a column in the whole database
oracle 11g
By: POGAKU_SANTHOSH on Thu, 01 February 2018
38 7777 Wed, 14 February 2018 10:14
By: Michel Cadot
  schedule job for multi threading
oracle 10g
By: simplesanju on Sat, 10 February 2018
3 1938 Mon, 12 February 2018 00:32
By: simplesanju
  difference between date
By: hassan08 on Mon, 05 February 2018
5 1909 Tue, 06 February 2018 03:45
By: John Watson
  recursive query
12c
By: m.abdulhaq on Sat, 03 February 2018
11 3291 Sat, 03 February 2018 12:55
By: BlackSwan
  dba_dependencies_columns
12.2.0.1.0
By: Bill B on Thu, 01 February 2018
5 2176 Fri, 02 February 2018 07:48
By: Bill B
  Websocket connection through Oracle PL SQL
Oracle 12c
By: santoshvgotur@gmail.com on Thu, 01 February 2018
3 2676 Fri, 02 February 2018 06:54
By: EdStevens
  need two token matching query
oracle 11.2.0.4
By: mvrkr44 on Thu, 07 December 2017
38 11312 Wed, 31 January 2018 18:50
By: Barbara Boehmer
  Is there a way to do a rollup on only one dimension
11.2.0.4, Windows 2012 R2
By: juniordbanewbie on Thu, 23 November 2017
3 2537 Thu, 25 January 2018 18:10
By: juniordbanewbie
  load script for loading data from oracle table to excel
By: sshree12 on Wed, 24 January 2018
3 1939 Thu, 25 January 2018 11:50
By: Bill B
  Alternate to DECODE function to be used in elsif statment in PLSQL procedure
By: oracbeg on Thu, 25 January 2018
2 1753 Thu, 25 January 2018 08:17
By: Michel Cadot
  how can don't use column in group by
By: hassan08 on Tue, 23 January 2018
7 3854 Thu, 25 January 2018 04:14
By: cookiemonster
  Special grouping with SQL
Oracle 12C R2
By: OlafCologne on Sat, 20 January 2018
5 2379 Sat, 20 January 2018 09:25
By: Littlefoot
  Material view auto refresh DBMS_SCHEDULER
oracle 11g
By: POGAKU_SANTHOSH on Thu, 18 January 2018
2 2388 Thu, 18 January 2018 04:42
By: POGAKU_SANTHOSH
  How to replace with null for non alphanumeric characters in Varchar2 field.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: msol25 on Tue, 09 January 2018
6 2352 Tue, 16 January 2018 02:57
By: msol25
  Problem with Data display
Oracle11g
By: ssyr on Fri, 12 January 2018
6 3116 Fri, 12 January 2018 08:14
By: joy_division
  duplicate records with different date_from and date_to
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: naga.oracle on Wed, 10 January 2018
3 2309 Fri, 12 January 2018 02:57
By: quirks
  malformed cursor
oracle 12c
By: desmond30 on Thu, 11 January 2018
8 1937 Thu, 11 January 2018 09:10
By: cookiemonster
  PL/SQL procedure issue
Windows
By: nicolewells on Sun, 07 January 2018
12 4941 Thu, 11 January 2018 00:17
By: Littlefoot
  Change the order of records in some variables
By: habitusantos on Mon, 08 January 2018
6 2454 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 1926 Sun, 07 January 2018 22:33
By: oracbeg
  SQL query
oracle xe 11g
By: hudo on Fri, 05 January 2018
4 2053 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 2883 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 2273 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 3223 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 1752 Tue, 02 January 2018 21:00
By: vincenttic
  Function or filter in hierarchy query
12c
By: m.abdulhaq on Tue, 26 December 2017
4 2333 Tue, 02 January 2018 02:09
By: quirks
  dense_rank performance
By: shahzad-ul-hasan on Sat, 30 December 2017
1 1845 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 1873 Sat, 30 December 2017 02:17
By: Littlefoot
  regexp_substr
12c
By: m.abdulhaq on Tue, 26 December 2017
6 2101 Fri, 29 December 2017 10:57
By: Littlefoot
  mysql and oracle issue using dblink
By: nicolewells on Fri, 29 December 2017
2 1696 Fri, 29 December 2017 07:54
By: EdStevens
  last date of the year
By: sshree12 on Wed, 27 December 2017
3 1842 Thu, 28 December 2017 07:40
By: joy_division
  current date - preovious date calculations
By: sshree12 on Tue, 26 December 2017
18 5455 Wed, 27 December 2017 21:59
By: Barbara Boehmer
  over partition by
By: sshree12 on Wed, 27 December 2017
14 4548 Wed, 27 December 2017 09:02
By: sshree12
  Open cursor
11g32 linux(RHEL)
By: dba4oracle on Wed, 27 December 2017
2 1283 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 1561 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 2031 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 5107 Sun, 24 December 2017 03:46
By: SmithXu
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: Mon Jun 17 14:03:03 CDT 2019