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
  Import data from excel to oracle Db
By: malu on Mon, 12 March 2018
3 4347 Tue, 13 March 2018 13:06
By: EdStevens
  select more rows and insert less
oracle 11gr2
By: guddu_12 on Tue, 06 March 2018
6 3197 Tue, 13 March 2018 09:16
By: msol25
  DBMS_CRYPTO package
By: adovgan on Tue, 13 March 2018
2 2901 Tue, 13 March 2018 07:09
By: adovgan
  steps to create dynamic join query in oracle sql
By: asheolik on Mon, 12 March 2018
1 2555 Mon, 12 March 2018 08:04
By: John Watson
  Get Current & Previous Quarter Data from table
By: ramya29p on Fri, 09 March 2018
5 3287 Fri, 09 March 2018 05:03
By: flyboy
  Oracle Partitioned Table get values
11G
By: elixir86 on Tue, 06 March 2018
1 2523 Tue, 06 March 2018 13:12
By: BlackSwan
  help with error executing a view
oracle 12c
By: laredoeneko on Sat, 03 March 2018
14 6665 Sun, 04 March 2018 11:36
By: Michel Cadot
  comma separated string to column dynamically
By: ramya29p on Tue, 27 February 2018
10 5466 Wed, 28 February 2018 07:35
By: Bill B
  Compare row & column data
11G
By: bond_8801 on Tue, 27 February 2018
8 4390 Tue, 27 February 2018 17:33
By: BlackSwan
  Count occurrences of String in field
Oracle 11g, Win 10
By: rajivn786 on Mon, 26 February 2018
2 2496 Tue, 27 February 2018 10:52
By: rajivn786
  Table Archive and Purge
11.2
By: gopikrish_6 on Sun, 25 February 2018
6 3462 Mon, 26 February 2018 15:30
By: Bill B
  Commit after deletion of every 5000 rows
Oracle11g
By: ssyr on Mon, 08 January 2018
17 7276 Mon, 26 February 2018 15:23
By: Bill B
  string format
By: suji6281 on Mon, 26 February 2018
3 2322 Mon, 26 February 2018 10:08
By: Bill B
  Interval Clause in Date
Oracle11g
By: ssyr on Mon, 26 February 2018
2 2766 Mon, 26 February 2018 04:10
By: cookiemonster
  Character set Conversion
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Mon, 26 February 2018
2 2385 Mon, 26 February 2018 03:30
By: saipradyumn
  Query help
12.2
By: kapilavastu on Thu, 22 February 2018
15 6202 Fri, 23 February 2018 11:51
By: Littlefoot
  User variable to decide which in statement to use in query
By: bobghw on Tue, 13 February 2018
5 3623 Wed, 21 February 2018 12:46
By: bobghw
  SQL Query
Oracle 12 c
By: Deep_80 on Mon, 19 February 2018
20 5738 Wed, 21 February 2018 07:48
By: joy_division
  Grouping of records in a table with a group id
11G, Unix
By: bahubcd on Sat, 03 February 2018
11 5656 Wed, 21 February 2018 06:51
By: Bill B
  NVL Vs OR condition
PL/SQL Release 11.2.0.4.0 - Production
By: saipradyumn on Thu, 15 February 2018
9 5605 Mon, 19 February 2018 07:00
By: cookiemonster
icon2.gif Finding exact row in case of matching
Oracle 10g
By: maanosajnabi on Mon, 15 January 2018
6 4498 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 4888 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 5418 Mon, 19 February 2018 04:12
By: quirks
  BULK COLLECT ISSUE
Oracle 12C, Unix
By: bahubcd on Wed, 14 February 2018
4 3224 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 10726 Wed, 14 February 2018 10:14
By: Michel Cadot
  schedule job for multi threading
oracle 10g
By: simplesanju on Sat, 10 February 2018
3 2902 Mon, 12 February 2018 00:32
By: simplesanju
  difference between date
By: hassan08 on Mon, 05 February 2018
5 2960 Tue, 06 February 2018 03:45
By: John Watson
  recursive query
12c
By: m.abdulhaq on Sat, 03 February 2018
11 5070 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 3583 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 4632 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 14123 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 3731 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 2980 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 2838 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 5058 Thu, 25 January 2018 04:14
By: cookiemonster
  Special grouping with SQL
Oracle 12C R2
By: OlafCologne on Sat, 20 January 2018
5 3419 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 4680 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 3510 Tue, 16 January 2018 02:57
By: msol25
  Problem with Data display
Oracle11g
By: ssyr on Fri, 12 January 2018
6 4271 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 3314 Fri, 12 January 2018 02:57
By: quirks
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: Sun Sep 27 13:01:33 CDT 2020