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
  Emp Code Searching Issue
Oracle DB 12C
By: wasimK on Tue, 21 April 2020
6 1309 Tue, 21 April 2020 11:52
By: Michel Cadot
  Extracting specific portion of a string using REGEX
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0, Windows 10 Professiona
By: buggleboy007 on Mon, 06 April 2020
3 1355 Mon, 20 April 2020 17:31
By: buggleboy007
  PL/SQL Stored Procedure Showing Oracle Error 27476 (Job Doesn't Exist)
Oracle 12c
By: bmccollum on Mon, 20 April 2020
2 626 Mon, 20 April 2020 14:43
By: bmccollum
  RAISE_APPLICATION_ERROR not invoked by Logon trigger
Oracle 11.2.0.3.0 SE , Oracle 12.1.0.2.0 SE
By: Andrey_R on Sun, 19 April 2020
10 1176 Mon, 20 April 2020 11:28
By: Michel Cadot
  Hierarchy again and again
11.2.0.3.0
By: Amine on Sun, 19 April 2020
5 1223 Mon, 20 April 2020 08:42
By: Amine
  Text to number conversion
Oracle SQL Developer
By: dorustd on Tue, 10 March 2020
15 4770 Sat, 18 April 2020 07:14
By: Jamesconnor
icon4.gif Function call in ref cursor
Oracle 11gR2
By: Bhushan.Mahajan on Tue, 14 April 2020
7 2813 Wed, 15 April 2020 10:07
By: Michel Cadot
  Create Materialized View throws "ORA-01031: insufficient privileges"
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Tue, 14 April 2020
2 2648 Wed, 15 April 2020 07:23
By: Michel Cadot
  Fine Grain Access control disabled but still prevents to create Materialized View
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Tue, 14 April 2020
6 2543 Wed, 15 April 2020 07:21
By: Michel Cadot
  Calculating the Difference of Timestamp in Min, Sec
Windows 2012, 11g, 12c
By: Giles02 on Mon, 13 April 2020
9 2123 Tue, 14 April 2020 07:45
By: Michel Cadot
  create materialized view log with explicit constraint (merged)
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Mon, 13 April 2020
3 1421 Mon, 13 April 2020 14:16
By: wtolentino
  Filtering result from 2 PL/SQL UNION queries
PL/SQL 9.0
By: gbuck on Thu, 09 April 2020
1 2322 Thu, 09 April 2020 15:45
By: Michel Cadot
  Subquery returns more than one row - where clause -decode
oracle 12c
By: New50 on Wed, 08 April 2020
11 2634 Thu, 09 April 2020 14:40
By: Michel Cadot
  Adding a from () to a query made it so slow
11.2.0.1.0
By: OraFerro on Mon, 06 April 2020
6 1800 Wed, 08 April 2020 08:13
By: OraFerro
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
15 9621 Sun, 05 April 2020 11:16
By: danielarias
  How To Add Full Email Body Text from File to CLOB Column?
Oracle 12c
By: bmccollum on Wed, 01 April 2020
1 2621 Thu, 02 April 2020 00:11
By: Michel Cadot
icon5.gif Fill in records where date missing in sequence
Oracle 12c, Querying with SQL Developer v3.2.20.10
By: sqlafterdark on Tue, 31 March 2020
1 1659 Tue, 31 March 2020 23:43
By: Michel Cadot
  Alter Regex to validate email Domain on RFC 5322 from Java to Oracle sql
Oracle 11g, windows 10
By: Nicha on Fri, 27 March 2020
2 4090 Mon, 30 March 2020 12:41
By: Nicha
  Joined two tables on one row
By: Gin min on Wed, 25 March 2020
9 4792 Thu, 26 March 2020 05:02
By: Michel Cadot
icon5.gif Cursored FOR loops, PLS-00103 compile error
12.1.0.2.0
By: thegerman on Sat, 21 March 2020
2 2542 Sun, 22 March 2020 18:27
By: thegerman
  Moving sequences from one schema to other with the next value.
12c , Solaris 10
By: daulat01 on Wed, 18 March 2020
14 2972 Sat, 21 March 2020 06:34
By: Solomon Yakobson
  XS entity with this name already exists.
Oracle form 12c
By: Shiv93 on Wed, 18 March 2020
7 2717 Thu, 19 March 2020 04:18
By: Shiv93
  ORACLE :::Is there any other way to drop the column with out uncompression table in oracle database
oracle 12c
By: sivaraman.pvi@gmail.com on Thu, 12 March 2020
6 4367 Tue, 17 March 2020 12:41
By: Bill B
  different rows in set of data (using lead or alternative)
11.2.0.1.0
By: OraFerro on Tue, 17 March 2020
3 1315 Tue, 17 March 2020 04:20
By: OraFerro
  Import CSV data from CLOB
Oracle 12c, Unix
By: Rayam69 on Fri, 06 March 2020
32 7946 Wed, 11 March 2020 09:07
By: cookiemonster
  log ORA-01013: user requested cancel of current operation tips
11g
By: vioricamilea on Wed, 22 June 2011
20 14338 Wed, 11 March 2020 08:58
By: shthed@gmail.com
  ORA-02069
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: s4.ora on Tue, 10 March 2020
2 1528 Wed, 11 March 2020 08:34
By: s4.ora
  Locking issue while MATERIALIZED VIEW REFRESH
PL/SQL Release 12.1.0.2.0
By: Manoj.Gupta.91 on Fri, 06 March 2020
6 4577 Wed, 11 March 2020 07:28
By: Bill B
  MATERIALIZED VIEW REFRESH HISTORY
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: Manoj.Gupta.91 on Tue, 10 March 2020
1 1394 Wed, 11 March 2020 07:18
By: Bill B
  multiple inserts without Loops
By: ghostman on Tue, 10 March 2020
2 1084 Tue, 10 March 2020 06:10
By: _jum
  Analytic Function: How to Partition Hierarchical Data
By: whdyck on Mon, 09 March 2020
1 726 Mon, 09 March 2020 13:03
By: Michel Cadot
  exit when cursor%notfound is giving buffer overflow if not being used in anonymous block (merged)
By: sfksuperman on Tue, 03 March 2020
18 4233 Thu, 05 March 2020 10:19
By: Michel Cadot
  Select statement inside IF statement for comparing a given string with records in table
By: sfksuperman on Fri, 28 February 2020
27 5193 Tue, 03 March 2020 02:43
By: cookiemonster
  convert rows to column in SQL
12C
By: NeetuMishraIsBack on Fri, 28 February 2020
1 3138 Sat, 29 February 2020 00:58
By: Michel Cadot
  embedded implicit cursors in SQL
Oracle, Win 10
By: Calvin_007 on Fri, 28 February 2020
1 2987 Sat, 29 February 2020 00:54
By: Michel Cadot
  query-assistance
Oracle 11g
By: winfire on Fri, 28 February 2020
4 2996 Fri, 28 February 2020 08:26
By: winfire
  Time Between Consecutive Locations
Oracle 12c
By: run400 on Mon, 24 February 2020
4 2700 Fri, 28 February 2020 03:21
By: _jum
  Oracle 11g Sequence(merged)
11g
By: moyida on Thu, 27 February 2020
7 1486 Thu, 27 February 2020 12:27
By: Bill B
  How to Fetch merged rows back !
By: ramya29p on Thu, 27 February 2020
2 925 Thu, 27 February 2020 05:21
By: ramya29p
  regexp_replace (merged 2)
By: akarra on Wed, 26 February 2020
8 1496 Wed, 26 February 2020 15:04
By: akarra
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: Fri Sep 25 13:05:38 CDT 2020