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
  Retrieve font name available in OS using sql plus
Windows 7, Oracle 10g XE
By: lock_heart on Wed, 04 December 2013
16 11314 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 6324 Mon, 04 October 2021 06:27
By: vippysharma
  SQL Query- Connect By (merged)
11g
By: sayan13 on Tue, 28 September 2021
3 9786 Tue, 28 September 2021 01:28
By: Michel Cadot
  Extract string between 2 text
11gr2
By: guddu_12 on Sun, 26 September 2021
6 11013 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 4966 Tue, 21 September 2021 20:12
By: EdStevens
  member and collection type
oracle 12.1
By: pointers on Wed, 08 September 2021
4 14337 Sat, 11 September 2021 01:57
By: pointers
  Slab Level query (merged)
Oracle 11
By: annu-agi on Mon, 06 September 2021
6 14044 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 10082 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 10670 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 8174 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 21858 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 30403 Mon, 30 August 2021 16:24
By: eleny
  Fire triggers on a nested_table
By: ryouga82 on Fri, 27 August 2021
2 12998 Sun, 29 August 2021 11:33
By: Solomon Yakobson
  Oracle Invalid hint
19c
By: Unclefool on Fri, 27 August 2021
1 13853 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 11463 Fri, 27 August 2021 01:13
By: _jum
  About REF datatype
10.2 to 19
By: Michel Cadot on Fri, 20 August 2021
11 17321 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 10895 Sun, 22 August 2021 14:21
By: Andrey_R
  Oracle cte multiple rows (3 merged)
19c
By: Unclefool on Thu, 19 August 2021
2 9901 Thu, 19 August 2021 07:51
By: Unclefool
  Oracle procedure passing NULL in DATE parameters
19c
By: Unclefool on Wed, 18 August 2021
2 10183 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 8318 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 8117 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 3561 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 4576 Mon, 16 August 2021 19:53
By: Unclefool
  Table type collection in SELECT
Oracle 11g
By: sinpeak on Thu, 05 August 2021
2 11285 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 14127 Fri, 06 August 2021 04:16
By: Michel Cadot
  Question about databses
By: itmasterw on Wed, 04 August 2021
4 12391 Wed, 04 August 2021 11:04
By: itmasterw
  QUERY TO DISPLAY EDUCATION
11g
By: glmjoy on Wed, 28 July 2021
10 16573 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 16383 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 8478 Thu, 22 July 2021 14:13
By: Michel Cadot
  Statement Level trigger - After Insert/Update
11g
By: revathitirun on Wed, 07 July 2021
4 19619 Thu, 22 July 2021 11:42
By: Michel Cadot
  How to stop swapping in EXCHANGE PARTITION
PLSQL 12.1.0.2.0
By: gopalMisra on Fri, 16 July 2021
7 12813 Mon, 19 July 2021 02:24
By: Michel Cadot
  get the record where the amount columns are same in 2 tables
11.2
By: mist598 on Sun, 18 July 2021
3 9149 Sun, 18 July 2021 07:27
By: EdStevens
  Unable to get the PL/SQL block to work
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Fri, 16 July 2021
3 10449 Sat, 17 July 2021 12:29
By: buggleboy007
  Issues with my Associative Array inside a Package spec
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Thu, 15 July 2021
3 10741 Sat, 17 July 2021 12:26
By: buggleboy007
  CASE in where Clause (4 merged)
SQL
By: Sekhar6617 on Fri, 16 July 2021
5 12175 Sat, 17 July 2021 10:50
By: Sekhar6617
  How to convert multi_byte to single_byte character
Oracle 11g
By: Andrey_R on Thu, 10 June 2021
7 11803 Thu, 15 July 2021 05:22
By: Andrey_R
  Issues with my Associative Array
Oracle 12c, O/S: Windows 10 pro
By: buggleboy007 on Fri, 09 July 2021
4 16155 Sat, 10 July 2021 14:58
By: buggleboy007
  Getting PLS: 00306 wrong number or types of arguments in call to
11.2.0.4
By: kamaluv234 on Wed, 30 June 2021
3 8272 Thu, 01 July 2021 00:25
By: kamaluv234
  two different counts in select
By: Sekhar6617 on Mon, 28 June 2021
11 10897 Tue, 29 June 2021 06:33
By: Sekhar6617
  Listing table names,noofrows,noofcolumns primarkeyscol in a schema
oracle 12c
By: sekharsomu on Mon, 21 June 2021
5 13839 Mon, 21 June 2021 21:55
By: sekharsomu
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 May 21 17:12:02 CDT 2024