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
  Flatten table to get unique VALUES
19.2
By: Unclefool on Thu, 16 December 2021
9 14967 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 11623 Mon, 20 December 2021 03:32
By: vippysharma
  UTL_FILE
Oracle 19c
By: rajivn786 on Fri, 17 December 2021
7 11461 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 7340 Thu, 09 December 2021 09:50
By: wtolentino
  Using Procedure Update Date day -1
oracle sql
By: Rap19 on Tue, 07 December 2021
3 6801 Thu, 09 December 2021 09:00
By: EdStevens
  Oracle Display parent, child, grandchild hierarchy
19.2
By: Unclefool on Sat, 04 December 2021
4 7886 Sun, 05 December 2021 11:05
By: Unclefool
  to_date in where clause
By: shahzad-ul-hasan on Fri, 26 November 2021
15 15546 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 9783 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 7179 Tue, 23 November 2021 11:32
By: Solomon Yakobson
  Data history
11.2.0.3
By: Amine on Thu, 04 November 2021
20 21414 Tue, 09 November 2021 18:14
By: Solomon Yakobson
  Dates integrity
11.2.0.3
By: Amine on Mon, 08 November 2021
4 20242 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 18198 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 7856 Thu, 04 November 2021 13:49
By: EdStevens
  Days Query
11G
By: glmjoy on Wed, 27 October 2021
4 9313 Thu, 04 November 2021 11:23
By: Michel Cadot
  How to get monthly average sum
By: Lim on Mon, 01 November 2021
15 9811 Tue, 02 November 2021 04:27
By: Michel Cadot
  Oracle stored procedure with complex conditions
By: sud_oracle on Sun, 31 October 2021
4 5600 Mon, 01 November 2021 10:25
By: sud_oracle
  Parsing query
Oracle 11g
By: akull on Mon, 01 November 2021
2 3859 Mon, 01 November 2021 08:35
By: akull
  Data Dictionary for Collection Bind variables
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: saipradyumn on Tue, 19 October 2021
9 16260 Fri, 29 October 2021 15:35
By: Andrey_R
  Oracle SQL a=b and b=a
Oracle 12C
By: rahul1982 on Fri, 29 October 2021
3 6483 Fri, 29 October 2021 14:25
By: EdStevens
  Long query with WITH not responding
Ora 11.2.0.3.0
By: Reversi72 on Mon, 11 October 2021
23 22278 Fri, 29 October 2021 04:44
By: Reversi72
  Unable to take backup of a table
Oracle, 18.0.0.0.0, CentOS Linux release 7.8.2003 (Core)
By: BalajiDBA on Thu, 28 October 2021
8 9366 Fri, 29 October 2021 00:43
By: Michel Cadot
  transpose rows into columns
oracle
By: suji6281 on Thu, 30 September 2021
37 29900 Thu, 28 October 2021 22:03
By: Sekhar6617
  How to substract 2 varchar2 dates (YYYYMMDDHH24MMSS) in oracle?
By: mmm286 on Tue, 26 October 2021
5 5345 Wed, 27 October 2021 08:51
By: Andrey_R
  Who call me
all versions from 11g to 19c
By: Michel Cadot on Fri, 22 October 2021
11 12453 Sun, 24 October 2021 03:26
By: Michel Cadot
  Prefix data into an existing clob
19.2
By: Unclefool on Sat, 23 October 2021
1 4906 Sat, 23 October 2021 12:03
By: Solomon Yakobson
  DBMS_JOB.SUBMIT not appearing
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: saipradyumn on Mon, 04 October 2021
6 13703 Mon, 18 October 2021 03:12
By: saipradyumn
  Select Query suggestion
Oracle 12c
By: akssre on Sun, 17 October 2021
5 9496 Mon, 18 October 2021 00:33
By: Michel Cadot
  Is there a way to create a materialized view with datatype and length?
By: joy_division on Fri, 08 October 2021
7 10780 Fri, 08 October 2021 15:37
By: Solomon Yakobson
  Retrieve font name available in OS using sql plus
Windows 7, Oracle 10g XE
By: lock_heart on Wed, 04 December 2013
16 11050 Wed, 06 October 2021 23:28
By: MaaM
icon1.gif REGEXP_LIKE
12c ENT Edition 12.2.0.1.0
By: vippysharma on Mon, 04 October 2021
2 6059 Mon, 04 October 2021 06:27
By: vippysharma
  SQL Query- Connect By (merged)
11g
By: sayan13 on Tue, 28 September 2021
3 9530 Tue, 28 September 2021 01:28
By: Michel Cadot
  Extract string between 2 text
11gr2
By: guddu_12 on Sun, 26 September 2021
6 10586 Sun, 26 September 2021 10:22
By: guddu_12
  Oracle R12 query to retrieve a list of AP invoices and the corresponding file name/path
Oracle R12
By: kjnf505 on Mon, 20 September 2021
1 4711 Tue, 21 September 2021 20:12
By: EdStevens
  member and collection type
oracle 12.1
By: pointers on Wed, 08 September 2021
4 14091 Sat, 11 September 2021 01:57
By: pointers
  Slab Level query (merged)
Oracle 11
By: annu-agi on Mon, 06 September 2021
6 13803 Tue, 07 September 2021 03:00
By: annu-agi
  Function Finding multiple occurrences of a string
19c
By: Unclefool on Mon, 06 September 2021
4 9801 Mon, 06 September 2021 21:23
By: Unclefool
  query to display employee whose code is 03 is not inserted
11g
By: glmjoy on Sat, 04 September 2021
6 10397 Sat, 04 September 2021 13:46
By: glmjoy
  Write an SQL query to report the students (student_id, student_name) being “quiet” in ALL exams. A “
By: vritik on Fri, 03 September 2021
1 7926 Fri, 03 September 2021 11:54
By: Michel Cadot
  Error ocurred calling a Web Service using UTL_HTTP
Oracle Database, 10g Enterprise Edition Release 10.2.0.4.0, HP-UX
By: gusmenp on Thu, 27 June 2013
6 21487 Tue, 31 August 2021 07:37
By: mohsin0012
  Duplicating Excel "RATE" function in Oracle
Oracle 11.2
By: Primordial on Wed, 18 February 2015
19 29993 Mon, 30 August 2021 16:24
By: eleny
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: Thu Mar 28 16:18:09 CDT 2024