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
  Help Needed in Date Variable
By: born2achieve on Mon, 21 February 2022
1 11284 Tue, 22 February 2022 00:34
By: Michel Cadot
  Getting ORA-24374 , when using function in with query (merged)
PLSQL 12.1.0.2.0
By: gopalMisra on Tue, 15 February 2022
13 8677 Mon, 21 February 2022 07:16
By: gopalMisra
  SQL -Report missing string when running a query
Oracle 11 windows 10
By: Kevin1967 on Wed, 16 February 2022
4 5359 Sat, 19 February 2022 00:26
By: Michel Cadot
  Facing issie in 19c
By: nishant87 on Thu, 17 February 2022
5 5814 Thu, 17 February 2022 08:16
By: EdStevens
  Putting a row with a particular value on top of a sort
Oracle 21, Windows 10
By: orHooha on Wed, 09 February 2022
3 6890 Wed, 09 February 2022 20:59
By: orHooha
  query
oracle11g
By: Norfree on Wed, 02 February 2022
4 12469 Tue, 08 February 2022 06:49
By: Solomon Yakobson
  record count between one hour
Oracle 19c
By: bkbora on Fri, 04 February 2022
3 6545 Sun, 06 February 2022 06:21
By: Solomon Yakobson
  Oracle case INSERT statement
19.2
By: Unclefool on Fri, 04 February 2022
6 6289 Sat, 05 February 2022 09:14
By: EdStevens
  Print value in table columns dynamically
By: dancko on Sun, 30 January 2022
5 15478 Wed, 02 February 2022 13:10
By: Michel Cadot
  ORA-04068: existing state of packages has been discarded
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, Linux Redhat
By: fixxxer on Fri, 30 August 2019
7 12386 Wed, 02 February 2022 03:38
By: fixxxer
  transpose logic
oracle
By: suji6281 on Tue, 25 January 2022
6 12514 Sat, 29 January 2022 18:31
By: Solomon Yakobson
  ORA 00922 MISSING OR INVALID OPTION
ORACLE 12C , ORACLE FORMS AND REPORTS 12C
By: lacchhii on Mon, 24 January 2022
2 5657 Tue, 25 January 2022 21:50
By: lacchhii
  Hex Value to Base64 Value Convertion
SQL PL/SQL
By: Khader Hussain on Mon, 24 January 2022
2 3252 Mon, 24 January 2022 03:30
By: Khader Hussain
  Dynamically pass table name in PLSQL
Oracle client 18.0
By: 345678 on Sat, 22 January 2022
6 4868 Mon, 24 January 2022 03:16
By: 345678
  PL/SQL escaping variable with a single quote
19.2
By: Unclefool on Tue, 18 January 2022
2 9489 Wed, 19 January 2022 06:28
By: Unclefool
  Unexpected Grants To Public
By: Gogetter on Wed, 12 January 2022
3 13705 Wed, 12 January 2022 03:21
By: Gogetter
  Oracle generate from-to DATE ranges and group by
19.2
By: Unclefool on Fri, 07 January 2022
2 16323 Fri, 07 January 2022 06:52
By: Unclefool
  Defining Variables in the Package Spec
Oracle, 12.2, Unix
By: Duane on Thu, 06 January 2022
3 15097 Fri, 07 January 2022 06:36
By: Frank
  Query Performance
Orcale 12-c
By: RGFJ on Thu, 06 January 2022
3 13652 Fri, 07 January 2022 06:34
By: Frank
  Two MAX Functions in a Single SELECT
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
By: whdyck on Thu, 23 December 2021
12 22643 Wed, 05 January 2022 07:33
By: Frank
  Oracle porting a natural join
19.2
By: Unclefool on Sun, 26 December 2021
2 13982 Tue, 28 December 2021 02:27
By: John Watson
  How to update the nested array in json clob column data using plsql..?
By: jeevetha on Thu, 23 December 2021
2 13755 Fri, 24 December 2021 08:10
By: Solomon Yakobson
  Split a row into multiple rows
Oracle
By: syam09 on Thu, 23 December 2021
1 10421 Thu, 23 December 2021 08:08
By: Michel Cadot
  SENDGRID | Curl
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: vippysharma on Thu, 16 December 2021
9 13096 Tue, 21 December 2021 01:53
By: vippysharma
  Flatten table to get unique VALUES
19.2
By: Unclefool on Thu, 16 December 2021
9 12184 Mon, 20 December 2021 11:22
By: John Watson
icon1.gif ORA 12545 | UTL_HTTP
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
By: vippysharma on Wed, 15 December 2021
4 8153 Mon, 20 December 2021 03:32
By: vippysharma
  UTL_FILE
Oracle 19c
By: rajivn786 on Fri, 17 December 2021
7 9462 Fri, 17 December 2021 13:06
By: Michel Cadot
  XMLtype throwing an error ORA-00932
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Thu, 09 December 2021
3 5110 Thu, 09 December 2021 09:50
By: wtolentino
  Using Procedure Update Date day -1
oracle sql
By: Rap19 on Tue, 07 December 2021
3 5235 Thu, 09 December 2021 09:00
By: EdStevens
  Oracle Display parent, child, grandchild hierarchy
19.2
By: Unclefool on Sat, 04 December 2021
4 5233 Sun, 05 December 2021 11:05
By: Unclefool
  to_date in where clause
By: shahzad-ul-hasan on Fri, 26 November 2021
15 12643 Sun, 05 December 2021 02:19
By: OraFerro
  DBA_HIST_SQLTEXT string buffer too small
Oracle 12.1
By: db_senior on Sat, 27 November 2021
1 8131 Sat, 27 November 2021 04:20
By: Michel Cadot
  Oracle regex_substr parsing a clob
19.2
By: Unclefool on Tue, 23 November 2021
1 5537 Tue, 23 November 2021 11:32
By: Solomon Yakobson
  Data history
11.2.0.3
By: Amine on Thu, 04 November 2021
20 17882 Tue, 09 November 2021 18:14
By: Solomon Yakobson
  Dates integrity
11.2.0.3
By: Amine on Mon, 08 November 2021
4 18793 Tue, 09 November 2021 03:09
By: Amine
  Sequence number to be entered by a user
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Fri, 05 November 2021
2 17126 Sat, 06 November 2021 09:26
By: buggleboy007
  Select value from multiple dates
Oracle 10g
By: shahzad-ul-hasan on Thu, 04 November 2021
4 6138 Thu, 04 November 2021 13:49
By: EdStevens
  Days Query
11G
By: glmjoy on Wed, 27 October 2021
4 7845 Thu, 04 November 2021 11:23
By: Michel Cadot
  How to get monthly average sum
By: Lim on Mon, 01 November 2021
15 6236 Tue, 02 November 2021 04:27
By: Michel Cadot
  Oracle stored procedure with complex conditions
By: sud_oracle on Sun, 31 October 2021
4 3847 Mon, 01 November 2021 10:25
By: sud_oracle
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 Jun 29 01:06:25 CDT 2022