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
icon2.gif Finding exact row in case of matching
Oracle 10g
By: maanosajnabi on Mon, 15 January 2018
6 1753 Mon, 19 February 2018 06:22
By: quirks
  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 1631 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 1780 Mon, 19 February 2018 04:12
By: quirks
  BULK COLLECT ISSUE
Oracle 12C, Unix
By: bahubcd on Wed, 14 February 2018
4 1028 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 3414 Wed, 14 February 2018 10:14
By: Michel Cadot
  schedule job for multi threading
oracle 10g
By: simplesanju on Sat, 10 February 2018
3 1217 Mon, 12 February 2018 00:32
By: simplesanju
  difference between date
By: hassan08 on Mon, 05 February 2018
5 1232 Tue, 06 February 2018 03:45
By: John Watson
  recursive query
12c
By: m.abdulhaq on Sat, 03 February 2018
11 1738 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 1212 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 1276 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 7307 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 1716 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 1217 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 1005 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 2613 Thu, 25 January 2018 04:14
By: cookiemonster
  Special grouping with SQL
Oracle 12C R2
By: OlafCologne on Sat, 20 January 2018
5 1539 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 1287 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 1545 Tue, 16 January 2018 02:57
By: msol25
  Problem with Data display
Oracle11g
By: ssyr on Fri, 12 January 2018
6 1917 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 1527 Fri, 12 January 2018 02:57
By: quirks
  malformed cursor
oracle 12c
By: desmond30 on Thu, 11 January 2018
8 1193 Thu, 11 January 2018 09:10
By: cookiemonster
  PL/SQL procedure issue
Windows
By: nicolewells on Sun, 07 January 2018
12 2489 Thu, 11 January 2018 00:17
By: Littlefoot
  Change the order of records in some variables
By: habitusantos on Mon, 08 January 2018
6 1510 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 1217 Sun, 07 January 2018 22:33
By: oracbeg
  SQL query
oracle xe 11g
By: hudo on Fri, 05 January 2018
4 1373 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 1725 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 1346 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 1850 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 1027 Tue, 02 January 2018 21:00
By: vincenttic
  Function or filter in hierarchy query
12c
By: m.abdulhaq on Tue, 26 December 2017
4 1472 Tue, 02 January 2018 02:09
By: quirks
  dense_rank performance
By: shahzad-ul-hasan on Sat, 30 December 2017
1 1265 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 1189 Sat, 30 December 2017 02:17
By: Littlefoot
  regexp_substr
12c
By: m.abdulhaq on Tue, 26 December 2017
6 1389 Fri, 29 December 2017 10:57
By: Littlefoot
  mysql and oracle issue using dblink
By: nicolewells on Fri, 29 December 2017
2 1083 Fri, 29 December 2017 07:54
By: EdStevens
  last date of the year
By: sshree12 on Wed, 27 December 2017
3 1120 Thu, 28 December 2017 07:40
By: joy_division
  current date - preovious date calculations
By: sshree12 on Tue, 26 December 2017
18 2620 Wed, 27 December 2017 21:59
By: Barbara Boehmer
  over partition by
By: sshree12 on Wed, 27 December 2017
14 1818 Wed, 27 December 2017 09:02
By: sshree12
  Open cursor
11g32 linux(RHEL)
By: dba4oracle on Wed, 27 December 2017
2 767 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 792 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 1286 Tue, 26 December 2017 12:22
By: joy_division
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 Aug 18 13:12:27 CDT 2018