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
  Get Record Count
Oracle 11g
By: lokimisc on Mon, 06 August 2018
9 4652 Thu, 09 August 2018 04:19
By: pablolee
  Back fill records
Oracle 11.2.0.3
By: pointers on Wed, 08 August 2018
4 2515 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 4894 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 2767 Mon, 30 July 2018 08:31
By: raresn
  Performance of Stored Programs
Oracle 12c , Linux
By: ninan on Sun, 29 July 2018
14 4539 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 3874 Sun, 29 July 2018 09:23
By: greenwaldliron
  Possibility of Name
Oracle 11G
By: Genesys on Mon, 16 July 2018
7 6077 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 6549 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 3171 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 4458 Mon, 23 July 2018 11:10
By: Michel Cadot
  Oracle materialized views workflow
By: camillelola on Fri, 20 July 2018
3 3099 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 5807 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 6557 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 4015 Tue, 17 July 2018 12:19
By: Lalit Kumar B
  query performance
11g
By: annu-agi on Sat, 14 July 2018
3 4319 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 4379 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 8391 Mon, 16 July 2018 06:52
By: Bill B
  Need Help on Creating FUNCTION
By: vharish006 on Tue, 10 July 2018
13 5382 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 3933 Wed, 11 July 2018 03:38
By: flyboy
  rownum from table
By: suji6281 on Mon, 09 July 2018
7 3749 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 5274 Tue, 10 July 2018 05:30
By: fabi88
  Report query
Oracle 12CR2
By: srinivas.k2005 on Wed, 04 July 2018
10 4554 Mon, 09 July 2018 12:38
By: joy_division
  type of constraints
By: diana365 on Wed, 16 January 2002
4 3644 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 4898 Thu, 05 July 2018 07:51
By: achraf87
  Stored Procedure / Deletion Conflict
Oracle 12C
By: dba_vijay on Tue, 03 July 2018
13 4493 Thu, 05 July 2018 03:40
By: cookiemonster
  Help required on ranking logic
By: ramya29p on Mon, 02 July 2018
6 3671 Tue, 03 July 2018 23:11
By: ramya29p
  How to get decimal value from string and convert
11g
By: tikun on Thu, 28 June 2018
18 6956 Tue, 03 July 2018 06:19
By: Bill B
  Extract domain name from email address field
PS/SQL
By: heidibb on Tue, 29 November 2011
19 20566 Tue, 03 July 2018 06:15
By: Bill B
  Select using DBMS_SQL.EXECUTE (merged)
Oracle Linux 6.7, Oracle 12.1.0.2.0
By: fabi88 on Mon, 02 July 2018
6 4756 Mon, 02 July 2018 04:07
By: Michel Cadot
  Alter Table <<table name>> add partition by range does not work
Oracle 11g
By: manikandan23 on Thu, 28 June 2018
4 3552 Fri, 29 June 2018 06:52
By: Bill B
  How to replace the new line and line feed in a specific manner
oracle 11g
By: POGAKU_SANTHOSH on Wed, 20 June 2018
5 3779 Thu, 28 June 2018 01:43
By: POGAKU_SANTHOSH
  Fetching Unix Folder Name and Timestamp in SQL/PLSQL
Oracle 11.2.0.4
By: nickz on Fri, 08 June 2018
26 12125 Mon, 25 June 2018 14:05
By: nickz
  Difference between two dates
By: desmond30 on Tue, 19 June 2018
9 4379 Mon, 25 June 2018 06:48
By: Bill B
  Compare current and previous record
Oracle 10 g
By: Danny Freeman on Fri, 15 June 2018
13 5494 Wed, 20 June 2018 11:50
By: Bill B
icon5.gif SQL: Substring folder name based on numeric value
Oracle DB 11.2.0.4
By: nickz on Thu, 14 June 2018
11 6676 Wed, 20 June 2018 02:06
By: nickz
  Help Grouping by
By: akull on Mon, 18 June 2018
6 3238 Mon, 18 June 2018 11:33
By: akull
  divide text string into different columns
By: suji6281 on Mon, 28 May 2018
10 5021 Mon, 18 June 2018 10:33
By: suji6281
  problem of inserting a long string of characters :ORA-22835: Taille de tampon insuffisante pour la c
11g
By: achraf87 on Mon, 18 June 2018
2 3787 Mon, 18 June 2018 08:53
By: cookiemonster
  Use multi-threading in PL/SQL
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Manoj.Gupta.91 on Mon, 18 June 2018
1 4717 Mon, 18 June 2018 07:53
By: BlackSwan
  Commit Process
10g,WIndows 10
By: Satheeshkumar.P on Sun, 17 June 2018
2 3083 Mon, 18 June 2018 04:29
By: gazzag
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 Jun 01 12:30:14 CDT 2020