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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
0 2820 Thu, 01 November 2018 14:05
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 197187 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  Parallel DDL statements in a same table with different partitions
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 19 February 2019
2 40 Tue, 19 February 2019 10:50
By: Michel Cadot
  Using Window Function in a query Block - Count and Sum
Database - 12c
By: indianscout on Tue, 19 February 2019
1 66 Tue, 19 February 2019 08:17
By: Michel Cadot
  Retrun a limit set of rows
9i or 11g
By: torz on Sun, 17 February 2019
11 434 Tue, 19 February 2019 08:10
By: Michel Cadot
  Executing dynamic sql using forall
12c
By: gauravgautam135 on Mon, 18 February 2019
5 235 Tue, 19 February 2019 03:23
By: John Watson
  difference amount between 2 dates
By: suji6281 on Fri, 15 February 2019
20 797 Mon, 18 February 2019 11:59
By: Michel Cadot
  Get Window User Name and MAC address after insert in RFQ table in oracle application Transaction
12.2.6
By: ashokb21 on Sun, 17 February 2019
5 313 Mon, 18 February 2019 09:19
By: BlackSwan
  Displaying rows as columns and grouping data
11g
By: vaibhav15211 on Mon, 18 February 2019
1 222 Mon, 18 February 2019 02:31
By: Michel Cadot
  Need suggestion on code refactoring
oracle 11g
By: aditisanvikar on Thu, 14 February 2019
7 738 Fri, 15 February 2019 08:01
By: John Watson
  XMLType Column Comparison in Select Query
Oracle11g
By: sotu100 on Thu, 14 February 2019
3 897 Fri, 15 February 2019 01:06
By: Michel Cadot
  Add new columns and update to 600MB table online mode with zero downtime
Oracle 11gR2
By: srinivas.k2005 on Tue, 12 February 2019
5 756 Thu, 14 February 2019 07:44
By: John Watson
  Compare and contrast TRUNCATE and DELETE for a table
By: Meenakumari on Mon, 28 August 2017
6 7672 Wed, 13 February 2019 15:18
By: John Watson
  select Statement with CASE and month count
rdbms 12c
By: evoradba on Tue, 12 February 2019
6 354 Tue, 12 February 2019 17:32
By: BlackSwan
  Difference between sum(decode) and count
PL/SQL
By: klaartje on Tue, 12 February 2019
4 268 Tue, 12 February 2019 07:44
By: Bill B
  How to collate rows
PL/SQL
By: klaartje on Tue, 12 February 2019
6 259 Tue, 12 February 2019 07:19
By: Bill B
  Tree View, Connect by Prior on 100m records
Oracle 12c, RED HAT
By: sureshonly@hotmail.com on Sun, 10 February 2019
7 2166 Mon, 11 February 2019 16:05
By: sureshonly@hotmail.com
  Pull out string between two words in string column
Oracle 11g
By: spalato76 on Sat, 09 February 2019
3 752 Sat, 09 February 2019 23:50
By: spalato76
  Issue in dynamic sql.
Oracle 18c
By: rajeshsvnr on Wed, 06 February 2019
6 1008 Sat, 09 February 2019 06:37
By: Solomon Yakobson
  Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail
Unix
By: Akmmhto on Mon, 04 February 2019
2 806 Tue, 05 February 2019 06:06
By: Akmmhto
  Account number selection from 10 parallel session
Oracle 11gR2
By: srinivas.k2005 on Fri, 01 February 2019
9 1265 Mon, 04 February 2019 10:16
By: srinivas.k2005
  table export to excel
12c
By: m.abdulhaq on Mon, 04 February 2019
7 724 Mon, 04 February 2019 10:13
By: cookiemonster
  Do I have to use ID as a PK?
General
By: CatB on Mon, 28 January 2019
17 2101 Wed, 30 January 2019 15:23
By: Bill B
  MULTISET EXCEPT - COLLECTION
12C
By: shawaj on Sat, 26 January 2019
13 2360 Wed, 30 January 2019 05:13
By: _jum
  Identify data based on data in other tables
By: rrcr on Sun, 27 January 2019
14 2489 Tue, 29 January 2019 07:56
By: BlackSwan
  DataMapper - JSON -> XML - Add a colon in XML tag
By: tutu10 on Mon, 28 January 2019
1 885 Mon, 28 January 2019 03:27
By: _jum
  RETURNING BULK COLLECT INTO COLLECTION
12C
By: shawaj on Fri, 23 November 2018
9 2807 Sat, 26 January 2019 12:15
By: BlackSwan
  SQL Query execute more records in WHERE CLAUSE
Oracle Database 10g, Windows XP
By: rehmankhan on Wed, 23 January 2019
3 1120 Thu, 24 January 2019 04:10
By: cookiemonster
  changing telephone format
12c
By: m.abdulhaq on Thu, 24 January 2019
4 1084 Thu, 24 January 2019 03:45
By: m.abdulhaq
icon5.gif How to simulate crash database?
Oracle 12c Release 2
By: petar97 on Mon, 21 January 2019
8 1756 Mon, 21 January 2019 12:40
By: petar97
  ORA-01843 on a simple query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: Andrey_R on Thu, 17 January 2019
10 1686 Fri, 18 January 2019 10:22
By: Michel Cadot
  Why Do You Need to File a DBA and the Simplest Way of Filing It.
By: inshah2297@gmail.com on Wed, 16 January 2019
4 1587 Thu, 17 January 2019 00:34
By: Michel Cadot
  DBMS_REDACT with MERGE
Oracle 12.1
By: Michael.van.Uffelen on Mon, 14 January 2019
5 1506 Wed, 16 January 2019 09:00
By: Solomon Yakobson
  Spreadsheet-like Totals and Subtotals
11.2
By: lott42_gmail on Fri, 11 January 2019
12 2043 Tue, 15 January 2019 18:29
By: Solomon Yakobson
  Insert Statement taking more than 2 hrs for 4 million records
Oracle 11gR2
By: srinivas.k2005 on Tue, 18 December 2018
21 2774 Mon, 14 January 2019 03:41
By: anil_mk
  Determining a due date based on business hours
Otracle 12.1
By: TerryM on Tue, 08 January 2019
8 2904 Fri, 11 January 2019 11:26
By: Michel Cadot
  wm_concat to listagg
By: zxx2403 on Mon, 07 January 2019
1 1272 Mon, 07 January 2019 23:16
By: Barbara Boehmer
  Proxy Granted But Unable to Modified a Table owned by the Proxy Account
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: wtolentino on Fri, 04 January 2019
9 2149 Mon, 07 January 2019 09:04
By: wtolentino
  What does @! mean in SQL?
Oracle 11.2.0.3
By: SmithXu on Fri, 04 January 2019
1 1169 Fri, 04 January 2019 20:55
By: BlackSwan
  Login table connection to another table.
Oracle 10g
By: Danny Freeman on Fri, 04 January 2019
4 1258 Fri, 04 January 2019 05:43
By: Danny Freeman
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: Tue Feb 19 11:23:09 CST 2019