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
  Running settlement of inward vs outward quantity
Oracle 11g
By: chintan.patel on Mon, 20 August 2018
11 275 Mon, 20 August 2018 18:49
By: Solomon Yakobson
  SQLException encounter while executing data trigger.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: vharish006 on Mon, 20 August 2018
2 84 Mon, 20 August 2018 14:31
By: vharish006
  Strange Issue in executing procedure
Oracle 11g
By: manikandan23 on Wed, 15 August 2018
22 868 Mon, 20 August 2018 10:01
By: JPBoileau
  Joining multiple rows and creating multiple columns
By: purnima1 on Mon, 20 August 2018
2 139 Mon, 20 August 2018 08:27
By: Michel Cadot
  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 424 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 848 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 493 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 993 Fri, 17 August 2018 07:53
By: Michel Cadot
  FIND MONTHS
11.2.0.4.0
By: megha25 on Thu, 16 August 2018
11 398 Fri, 17 August 2018 07:53
By: Bill B
  Teradata To Oracle MOD Function
By: kawi6rr on Thu, 16 August 2018
2 380 Fri, 17 August 2018 03:30
By: cookiemonster
  Put data from one field to another.
PLSQL
By: twardybidon on Thu, 16 August 2018
5 324 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 626 Thu, 16 August 2018 07:44
By: Bill B
  Last 7 days report
oracle 11g
By: akash123 on Wed, 15 August 2018
5 367 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 561 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 674 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 637 Mon, 13 August 2018 08:11
By: joy_division
  Dbms_metadat
12c
By: Kannan Oracle on Fri, 10 August 2018
2 608 Fri, 10 August 2018 07:42
By: joy_division
  Spool Japanese Characters
Oracle 11g
By: pratyush_biswas on Thu, 09 August 2018
4 854 Fri, 10 August 2018 07:05
By: Bill B
  PL/SQL Collection
Oracle 11G
By: RaShi.Raj on Thu, 09 August 2018
4 604 Thu, 09 August 2018 06:43
By: poojagarg
  Get Record Count
Oracle 11g
By: lokimisc on Mon, 06 August 2018
9 2319 Thu, 09 August 2018 04:19
By: pablolee
  Back fill records
Oracle 11.2.0.3
By: pointers on Wed, 08 August 2018
4 658 Wed, 08 August 2018 14:26
By: Solomon Yakobson
  Urgent : SQL Queries
SQL
By: akriti on Mon, 07 December 2015
12 1841 Thu, 02 August 2018 06:35
By: Bill B
  Create JSON from SQL 12C R1
By: Manoj.Gupta.91 on Mon, 30 July 2018
10 1491 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 887 Mon, 30 July 2018 08:31
By: raresn
  Performance of Stored Programs
Oracle 12c , Linux
By: ninan on Sun, 29 July 2018
14 1615 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 1061 Sun, 29 July 2018 09:23
By: greenwaldliron
  Possibility of Name
Oracle 11G
By: Genesys on Mon, 16 July 2018
7 3172 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 2012 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 893 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 1697 Mon, 23 July 2018 11:10
By: Michel Cadot
  Oracle materialized views workflow
By: camillelola on Fri, 20 July 2018
3 944 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 1696 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 2739 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 1409 Tue, 17 July 2018 12:19
By: Lalit Kumar B
  query performance
11g
By: annu-agi on Sat, 14 July 2018
3 2511 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 2085 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 2861 Mon, 16 July 2018 06:52
By: Bill B
  Need Help on Creating FUNCTION
By: vharish006 on Tue, 10 July 2018
13 2608 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 2071 Wed, 11 July 2018 03:38
By: flyboy
  rownum from table
By: suji6281 on Mon, 09 July 2018
7 1944 Tue, 10 July 2018 06:06
By: Bill B
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 Aug 20 19:39:51 CDT 2018