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
  Announcement: How to use [code] tags and make your code easier to read
By: Michel Cadot on Thu, 01 November 2018
1 23203 Tue, 30 June 2020 11:23
By: Michel Cadot
  sticky: Row generator ( 1 2)
By: Michel Cadot on Thu, 03 January 2008
43 268628 Tue, 06 November 2018 14:17
By: Solomon Yakobson
  Who call me
all versions from 11g to 19c
By: Michel Cadot on Fri, 22 October 2021
11 3502 Sun, 24 October 2021 03:26
By: Michel Cadot
  transpose rows into columns
oracle
By: suji6281 on Thu, 30 September 2021
33 16378 Sat, 23 October 2021 12:26
By: Michel Cadot
  Prefix data into an existing clob
19.2
By: Unclefool on Sat, 23 October 2021
1 348 Sat, 23 October 2021 12:03
By: Solomon Yakobson
  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
1 5944 Thu, 21 October 2021 14:34
By: Andrey_R
  Long query with WITH not responding
Ora 11.2.0.3.0
By: Reversi72 on Mon, 11 October 2021
22 12645 Mon, 18 October 2021 12:04
By: Michel Cadot
  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 9407 Mon, 18 October 2021 03:12
By: saipradyumn
  Select Query suggestion
Oracle 12c
By: akssre on Sun, 17 October 2021
5 6353 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 5677 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 6546 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 3779 Mon, 04 October 2021 06:27
By: vippysharma
  SQL Query- Connect By (merged)
11g
By: sayan13 on Tue, 28 September 2021
3 6941 Tue, 28 September 2021 01:28
By: Michel Cadot
  Extract string between 2 text
11gr2
By: guddu_12 on Sun, 26 September 2021
6 4831 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 2734 Tue, 21 September 2021 20:12
By: EdStevens
  member and collection type
oracle 12.1
By: pointers on Wed, 08 September 2021
4 11057 Sat, 11 September 2021 01:57
By: pointers
  Slab Level query (merged)
Oracle 11
By: annu-agi on Mon, 06 September 2021
6 10510 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 6964 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 7421 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 5616 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 17259 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 20689 Mon, 30 August 2021 16:24
By: eleny
  Fire triggers on a nested_table
By: ryouga82 on Fri, 27 August 2021
2 10374 Sun, 29 August 2021 11:33
By: Solomon Yakobson
  Oracle Invalid hint
19c
By: Unclefool on Fri, 27 August 2021
1 11660 Sat, 28 August 2021 01:27
By: John Watson
  Generate Unique Grouping ID
Oracle 12c
By: Manoj.Gupta.91 on Thu, 26 August 2021
3 8862 Fri, 27 August 2021 01:13
By: _jum
  About REF datatype
10.2 to 19
By: Michel Cadot on Fri, 20 August 2021
11 11814 Mon, 23 August 2021 01:15
By: Michel Cadot
  Oracle INSERT, SELECT, NOT EXISTS primary key
19c
By: Unclefool on Sat, 21 August 2021
3 8559 Sun, 22 August 2021 14:21
By: Andrey_R
  Oracle cte multiple rows (3 merged)
19c
By: Unclefool on Thu, 19 August 2021
2 7969 Thu, 19 August 2021 07:51
By: Unclefool
  Oracle procedure passing NULL in DATE parameters
19c
By: Unclefool on Wed, 18 August 2021
2 7332 Wed, 18 August 2021 13:18
By: Unclefool
  Creating time rows that doesn't cross midnight
19c
By: Unclefool on Tue, 17 August 2021
4 5915 Wed, 18 August 2021 08:36
By: Unclefool
  How to execute dynamically the permission grant using AWS RDS custom procedure (merged)
Oracle rds 12.1.0.v1
By: kesavansundaram on Tue, 17 August 2021
2 5530 Wed, 18 August 2021 00:05
By: Michel Cadot
icon1.gif SYSAUX IMPACT ON PERFORMANCE
12c ENT Edition 12.2.0.1.0
By: vippysharma on Mon, 16 August 2021
1 1421 Tue, 17 August 2021 00:17
By: Michel Cadot
  Creating rows every 5 minutes without overlap
19c
By: Unclefool on Mon, 16 August 2021
2 2507 Mon, 16 August 2021 19:53
By: Unclefool
  Table type collection in SELECT
Oracle 11g
By: sinpeak on Thu, 05 August 2021
2 8965 Wed, 11 August 2021 01:20
By: sinpeak
  BMP not correctly formated with UTF8 Characterset
Database 12c
By: Usman Tabassum on Thu, 05 August 2021
3 10898 Fri, 06 August 2021 04:16
By: Michel Cadot
  Question about databses
By: itmasterw on Wed, 04 August 2021
4 9598 Wed, 04 August 2021 11:04
By: itmasterw
  QUERY TO DISPLAY EDUCATION
11g
By: glmjoy on Wed, 28 July 2021
10 12865 Wed, 28 July 2021 09:14
By: EdStevens
  Execution Plan of query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 27 July 2021
2 13147 Tue, 27 July 2021 07:03
By: saipradyumn
  Prime Generation Logic using in single Query
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Thu, 22 July 2021
3 5346 Thu, 22 July 2021 14:13
By: Michel Cadot
  Statement Level trigger - After Insert/Update
11g
By: revathitirun on Wed, 07 July 2021
4 16964 Thu, 22 July 2021 11:42
By: Michel Cadot
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: Sun Oct 24 23:12:34 CDT 2021