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
  Row Movement disabled in Partitioned table
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sun, 19 August 2018
5 5160 Mon, 20 August 2018 06:30
By: Roachcoach
  Prevent Rounding when using Format Masking
Oracle 12.1.0.2.0, RHEL
By: abhi_orcl on Thu, 16 August 2018
6 5668 Fri, 17 August 2018 18:37
By: Solomon Yakobson
  Extracting just text from a Blob Column
11.2
By: dejah on Thu, 16 August 2018
5 4290 Fri, 17 August 2018 18:28
By: Solomon Yakobson
  SQL to Subtract X workdays from a date
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: ssmith001 on Wed, 15 August 2018
32 11725 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 4619 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 3200 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 4044 Thu, 16 August 2018 10:34
By: Michel Cadot
icon5.gif failing in Creation of PL/SQL function
PL SQL ORACLE
By: bench on Wed, 15 August 2018
14 6035 Thu, 16 August 2018 07:44
By: Bill B
  Last 7 days report
oracle 11g
By: akash123 on Wed, 15 August 2018
5 3323 Wed, 15 August 2018 06:24
By: akash123
  XML Special Character
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 14 August 2018
0 3425 Tue, 14 August 2018 15:07
By: vharish006
  Split Data in Column & Split Data in Excel (merged)
Excel 2016
By: vharish006 on Mon, 13 August 2018
7 4180 Mon, 13 August 2018 13:53
By: vharish006
  How to Convert Row to Column As Below
Oracle 11g
By: sonudev on Mon, 13 August 2018
11 4476 Mon, 13 August 2018 08:11
By: joy_division
  Dbms_metadat
12c
By: Kannan Oracle on Fri, 10 August 2018
2 3473 Fri, 10 August 2018 07:42
By: joy_division
  Spool Japanese Characters
Oracle 11g
By: pratyush_biswas on Thu, 09 August 2018
4 5644 Fri, 10 August 2018 07:05
By: Bill B
  PL/SQL Collection
Oracle 11G
By: RaShi.Raj on Thu, 09 August 2018
4 3744 Thu, 09 August 2018 06:43
By: poojagarg
  Get Record Count
Oracle 11g
By: lokimisc on Mon, 06 August 2018
9 5922 Thu, 09 August 2018 04:19
By: pablolee
  Back fill records
Oracle 11.2.0.3
By: pointers on Wed, 08 August 2018
4 3497 Wed, 08 August 2018 14:26
By: Solomon Yakobson
  Create JSON from SQL 12C R1
By: Manoj.Gupta.91 on Mon, 30 July 2018
10 7363 Tue, 31 July 2018 12:36
By: Solomon Yakobson
  OR clause degrades performance of a query?
Oracle database, any, Linux
By: raresn on Mon, 30 July 2018
2 3780 Mon, 30 July 2018 08:31
By: raresn
  Performance of Stored Programs
Oracle 12c , Linux
By: ninan on Sun, 29 July 2018
14 5864 Mon, 30 July 2018 03:02
By: Michel Cadot
  return top 10 records based on dynamic count of prev records results
oracle 11
By: greenwaldliron on Sun, 29 July 2018
7 5323 Sun, 29 July 2018 09:23
By: greenwaldliron
  Possibility of Name
Oracle 11G
By: Genesys on Mon, 16 July 2018
7 7666 Fri, 27 July 2018 20:13
By: Barbara Boehmer
  How to ensure uniqueness on RAISE_APPLICATION_ERROR
By: ramya29p on Mon, 23 July 2018
14 8406 Thu, 26 July 2018 03:27
By: cookiemonster
  passing date value to the query from sql*plus
By: shrinika on Mon, 23 July 2018
3 4283 Tue, 24 July 2018 12:08
By: shrinika
  PL/SQL: ORA-04053: error occurred when validating remote object
oracle12c
By: shrinika on Thu, 11 May 2017
3 6048 Mon, 23 July 2018 11:10
By: Michel Cadot
  Oracle materialized views workflow
By: camillelola on Fri, 20 July 2018
3 4030 Fri, 20 July 2018 13:19
By: Lalit Kumar B
  ORA-04091: table Table_Name is mutating, trigger/function may not see it
Oracle 11g With Apex 5.1
By: Mukul Ahmed on Fri, 13 July 2018
7 7836 Fri, 20 July 2018 04:16
By: elmomagalona
icon1.gif Get last record from another table
11g
By: ritaman on Mon, 16 July 2018
17 8220 Wed, 18 July 2018 05:26
By: cookiemonster
  Need Help on Pl/Sql
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 17 July 2018
11 5417 Tue, 17 July 2018 12:19
By: Lalit Kumar B
  query performance
11g
By: annu-agi on Sat, 14 July 2018
3 5284 Tue, 17 July 2018 06:29
By: Bill B
  how to work around the substitution variables in plsql
Oracle 12c
By: mgag on Mon, 02 July 2018
3 5477 Tue, 17 July 2018 06:26
By: ajaychinna
  Generate New Excel format (XLSX) files using Oracle PLSQL
Oracle 11.2.0.4
By: nickz on Fri, 13 July 2018
3 12660 Mon, 16 July 2018 06:52
By: Bill B
  Need Help on Creating FUNCTION
By: vharish006 on Tue, 10 July 2018
13 6647 Wed, 11 July 2018 03:43
By: cookiemonster
  SELECT QUERY
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Tue, 10 July 2018
6 5020 Wed, 11 July 2018 03:38
By: flyboy
  rownum from table
By: suji6281 on Mon, 09 July 2018
7 4806 Tue, 10 July 2018 06:06
By: Bill B
  How can bulk insert into the parent , child tables
Oracle Linux 6.7, Oracle 12.1.0.2.0
By: fabi88 on Sun, 08 July 2018
10 7067 Tue, 10 July 2018 05:30
By: fabi88
  Report query
Oracle 12CR2
By: srinivas.k2005 on Wed, 04 July 2018
10 5769 Mon, 09 July 2018 12:38
By: joy_division
  type of constraints
By: diana365 on Wed, 16 January 2002
4 4657 Mon, 09 July 2018 07:41
By: Bill B
  problem with concatenation and group by functions
11g
By: achraf87 on Wed, 04 July 2018
11 6173 Thu, 05 July 2018 07:51
By: achraf87
  Stored Procedure / Deletion Conflict
Oracle 12C
By: dba_vijay on Tue, 03 July 2018
13 5636 Thu, 05 July 2018 03:40
By: cookiemonster
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: Wed Dec 01 02:55:04 CST 2021