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
  ORA-21561: OID generation failed !!
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Redhat 6
By: fixxxer on Wed, 07 March 2018
12 24330 Wed, 20 May 2020 08:06
By: fixxxer
  Using SELECT to display various totals
12.2.0.2
By: johnw66 on Mon, 18 May 2020
4 5190 Tue, 19 May 2020 00:08
By: Michel Cadot
  Transposing data in single row
Oracle 12 c
By: OracleDBA_beginner on Fri, 15 May 2020
11 9854 Mon, 18 May 2020 04:58
By: Lalit Kumar B
  Procedure creation help
By: chavva.kiru@gmail.com on Wed, 13 May 2020
8 7175 Thu, 14 May 2020 10:55
By: Michel Cadot
  Creation of new partitions by increasing the sequence number
oracle 12C
By: chavva.kiru@gmail.com on Wed, 13 May 2020
5 5587 Wed, 13 May 2020 23:32
By: chavva.kiru@gmail.com
  Stored Procedure - not able to display no data found message
By: subash_141 on Wed, 13 May 2020
2 4146 Wed, 13 May 2020 07:13
By: Solomon Yakobson
  Displaying select results in double columns
11.2.0.1.0
By: OraFerro on Sat, 09 May 2020
25 11742 Tue, 12 May 2020 08:17
By: Michel Cadot
  Date Column
By: deepakdot on Wed, 06 May 2020
25 10379 Sat, 09 May 2020 13:31
By: Michel Cadot
  Configuring Scripts
Windows 7
By: Premananda on Sun, 26 April 2020
6 6234 Sat, 09 May 2020 12:33
By: EdStevens
  Looping Chain of Synonyms
Oracle Database 12
By: mushy.khan1985 on Wed, 06 May 2020
14 10854 Wed, 06 May 2020 14:21
By: mushy.khan1985
  Query needs to be tune
12.2.0.2
By: bha_96 on Wed, 06 May 2020
4 5927 Wed, 06 May 2020 12:21
By: Michel Cadot
  Limit error on function
PL/SQL
By: ram43 on Mon, 04 May 2020
3 5260 Tue, 05 May 2020 01:24
By: _jum
  PL/SQL problem
Oracle SQL developer
By: nedislav on Fri, 01 May 2020
11 11427 Fri, 01 May 2020 12:29
By: EdStevens
  drithsx
By: glyph on Fri, 01 May 2020
2 5337 Fri, 01 May 2020 08:19
By: Michel Cadot
  ORA-04042 issue when trying to grant the access
Oracle
By: raghuguru on Mon, 27 April 2020
11 16598 Wed, 29 April 2020 08:02
By: EdStevens
  "ORA-00942: table or view does not exist" when creating view via role's privilege
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Thu, 23 April 2020
5 9234 Tue, 28 April 2020 14:28
By: wtolentino
  Query
12.0.2
By: bha_96 on Sat, 25 April 2020
22 18879 Mon, 27 April 2020 03:16
By: Michel Cadot
  How too convert rows into columns based on order hiredate month wise
oracle 12c
By: narendraenamala on Fri, 24 April 2020
1 4822 Fri, 24 April 2020 00:57
By: Michel Cadot
  Need age difference between warning and critical
Oracle
By: soubalaji on Wed, 22 April 2020
9 7223 Wed, 22 April 2020 12:10
By: Michel Cadot
  Duplicate returns from list of Values
Oracle APEX
By: WillJ on Fri, 17 April 2020
20 12312 Wed, 22 April 2020 10:26
By: WillJ
  Emp Code Searching Issue
Oracle DB 12C
By: wasimK on Tue, 21 April 2020
6 5335 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 4887 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 3308 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 7307 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 3935 Mon, 20 April 2020 08:42
By: Amine
  Text to number conversion
Oracle SQL Developer
By: dorustd on Tue, 10 March 2020
15 15394 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 7436 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 17817 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 7457 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 7091 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 4511 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 5515 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 10444 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 6569 Wed, 08 April 2020 08:13
By: OraFerro
  getting finacial week number
oracle 11gr2
By: guddu_12 on Thu, 17 April 2014
15 16592 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 5489 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 4827 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 9100 Mon, 30 March 2020 12:41
By: Nicha
  Joined two tables on one row
By: Gin min on Wed, 25 March 2020
9 12298 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 8614 Sun, 22 March 2020 18:27
By: thegerman
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 Mar 19 02:20:21 CDT 2024