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
  Fire triggers on a nested_table
By: ryouga82 on Fri, 27 August 2021
2 12718 Sun, 29 August 2021 11:33
By: Solomon Yakobson
  Oracle Invalid hint
19c
By: Unclefool on Fri, 27 August 2021
1 13564 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 11192 Fri, 27 August 2021 01:13
By: _jum
  About REF datatype
10.2 to 19
By: Michel Cadot on Fri, 20 August 2021
11 17047 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 10643 Sun, 22 August 2021 14:21
By: Andrey_R
  Oracle cte multiple rows (3 merged)
19c
By: Unclefool on Thu, 19 August 2021
2 9660 Thu, 19 August 2021 07:51
By: Unclefool
  Oracle procedure passing NULL in DATE parameters
19c
By: Unclefool on Wed, 18 August 2021
2 9885 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 8060 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 7820 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 3300 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 4327 Mon, 16 August 2021 19:53
By: Unclefool
  Table type collection in SELECT
Oracle 11g
By: sinpeak on Thu, 05 August 2021
2 11010 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 13844 Fri, 06 August 2021 04:16
By: Michel Cadot
  Question about databses
By: itmasterw on Wed, 04 August 2021
4 12116 Wed, 04 August 2021 11:04
By: itmasterw
  QUERY TO DISPLAY EDUCATION
11g
By: glmjoy on Wed, 28 July 2021
10 16299 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 16086 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 8159 Thu, 22 July 2021 14:13
By: Michel Cadot
  Statement Level trigger - After Insert/Update
11g
By: revathitirun on Wed, 07 July 2021
4 19359 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 12518 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 8876 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 10171 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 10502 Sat, 17 July 2021 12:26
By: buggleboy007
  CASE in where Clause (4 merged)
SQL
By: Sekhar6617 on Fri, 16 July 2021
5 11911 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 11460 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 15838 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 7953 Thu, 01 July 2021 00:25
By: kamaluv234
  two different counts in select
By: Sekhar6617 on Mon, 28 June 2021
11 10613 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 13550 Mon, 21 June 2021 21:55
By: sekharsomu
  Automate repartitions
11.2.0.3
By: Amine on Fri, 11 June 2021
1 10872 Mon, 21 June 2021 17:42
By: Amine
  Help improve SQL Query
12c Linux
By: deepa_balu on Tue, 15 June 2021
1 11198 Tue, 15 June 2021 14:05
By: Michel Cadot
  ANSI vs Oracle Join Syntax
By: dancko on Sat, 12 June 2021
7 13892 Tue, 15 June 2021 12:04
By: Littlefoot
  dbms_scheduler.create_job() throws error ORA-27362
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: wtolentino on Fri, 11 June 2021
2 11512 Mon, 14 June 2021 08:29
By: wtolentino
  Data masking in oracle
Oracle
By: bkbora on Fri, 11 June 2021
4 9267 Fri, 11 June 2021 21:59
By: bkbora
  CHR(n) equivalent function for double-byte characters
Oracle 12.1.0.2.0
By: Andrey_R on Thu, 10 June 2021
5 5771 Thu, 10 June 2021 12:17
By: Solomon Yakobson
  Compare rows
11.2.0.3
By: Amine on Tue, 06 October 2015
5 7641 Tue, 08 June 2021 09:39
By: Michel Cadot
  View creation
12c and 11g
By: BunnyWorld123 on Tue, 08 June 2021
1 6257 Tue, 08 June 2021 07:39
By: John Watson
  How to spead up query that calls the save view multiple times
12
By: helixpoint on Tue, 01 June 2021
3 8837 Wed, 02 June 2021 05:55
By: Solomon Yakobson
  Nested Queries with Select Statement
Oracle 12 c, 12.1.0.1
By: a_naq on Mon, 10 May 2021
13 31423 Wed, 26 May 2021 10:02
By: BlackSwan
  Present value calculations in Oracle
12.1.0.1
By: OraFerro on Mon, 24 May 2021
2 16752 Mon, 24 May 2021 04:34
By: John Watson
  SUM of parent and child records
11.2
By: mist598 on Sun, 23 May 2021
1 13926 Mon, 24 May 2021 00:36
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: Thu Mar 28 11:53:28 CDT 2024