Database Ideas - Ideas

Discussion List

• 
  658

  Up Down
  SQL Assertions / Declarative multi-row constraints

  Under Review - Voting Still Open Toon_Koppelaars-Oracle 45.2K views 282 comments 658 points Most recent by connor_mc_d-Oracle Nov 14, 2022 1:32PM
• 
  280

  Up Down
  New type BOOLEAN

  Under Review - Voting Still Open Thomas U. 7K views 79 comments 280 points Most recent by Yevon Nov 12, 2022 9:24AM
• 
  208

  Up Down
  GRANT SELECT on all tables in a schema

  Under Review - Voting Still Open Tmicheli-Oracle 444.1K views 86 comments 208 points Most recent by User_7FSBV Nov 12, 2022 5:46AM
• 
  162
  Idea: have filter and access predicates populated by AWR snapshots

  Delivered Franck Pachot 3.1K views 17 comments 162 points Most recent by User_DGG74 Jun 3, 2021 5:20AM
• 
  150

  Up Down
  Need a command to rename a schema

  Active Tmicheli-Oracle 13.7K views 29 comments 150 points Most recent by PS_orclNerd Jul 16, 2019 3:47PM
• 
  97

  Up Down
  DBMS_SCHEDULER.CREATE_JOB Remove Implicit Commit

  Active gdanby 5K views 34 comments 97 points Most recent by Fernando Luna Dec 19, 2022 7:02PM
• 
  86

  Up Down
  Feature Usage - with and without lisence needed

  Active beckadr 1K views 14 comments 86 points Most recent by Rostislav Kushnirenko May 23, 2021 9:47PM
• 
  85

  Up Down
  COMMENTs for indexes

  Under Review - Voting Still Open Dear DBA Frank 1.7K views 24 comments 85 points Most recent by User_OY3HE Aug 11, 2022 10:55AM
• 
  82

  Up Down
  SUM on INTERVAL

  Under Review - Voting Still Open Sven W. 7.4K views 20 comments 82 points Most recent by connor_mc_d-Oracle Nov 12, 2022 4:49AM
• 
  81

  Up Down
  Replace LONG columns in Data Dictionary views

  Active Chris Hunt 1.2K views 14 comments 81 points Most recent by Thorsten Kettner Jun 29, 2021 8:01AM
• 
  80
  SQL*Plus command line history completion

  Delivered SPA09 9.7K views 27 comments 80 points Most recent by thatJeffSmith-Oracle Oct 22, 2015 9:25AM
• 
  78

  Up Down
  Make public package variables available to SQL

  Under Review - Voting Still Open Chris Hunt 9.3K views 30 comments 78 points Most recent by MatthiasRogel May 20, 2021 5:05PM
• 
  78
  LISTAGG with DISTINCT option

  Delivered ApexBine 107.5K views 48 comments 78 points Most recent by Racer I. Feb 6, 2019 9:33AM
• 
  75
  Parameterized Views

  Delivered ApexBine 25.5K views 53 comments 75 points Most recent by User_75YZK Oct 18, 2021 1:02PM
• 
  64

  Up Down
  Provide parameter to control/enable/disable ALL Database Options (not only Diag/Tuning Packs)

  Active Loïc Lefèvre-Oracle 834 views 9 comments 64 points Most recent by Stew Ashton May 3, 2018 11:05AM
• 
  63

  Up Down
  Extend UTL_FILE with function to return list of files in directory

  Under Review - Voting Still Open MortenBraten 20.5K views 17 comments 63 points Most recent by connor_mc_d-Oracle Nov 17, 2022 4:13AM
• 
  57

  Up Down
  CREATE easily Database Link for another user

  Active Rodrigo Jorge DBA 17K views 8 comments 57 points Most recent by Alex Lamar-Oracle Oct 22, 2018 10:49AM
• 
  53

  Up Down
  Exclusive BETWEEN

  Active William Robertson 7.1K views 9 comments 53 points Most recent by Sentinel Sep 26, 2019 4:47PM
• 
  51

  Up Down
  A second A-Row column for input rows in the traces

  Active Martin Preiss 954 views 7 comments 51 points Most recent by User_KC6Y3 Feb 11, 2021 2:01PM
• 
  50

  Up Down
  Filter clause for aggregate functions

  Active Martin Preiss 1.8K views 9 comments 50 points Most recent by User_MW1JP Jul 18, 2022 1:58PM
• 
  50

  Up Down
  Constrain PDB datafiles into specific directory

  Active Franck Pachot 898 views 10 comments 50 points Most recent by Mathias Zarick Oct 19, 2016 11:43AM
• 
  49
  Partitioned sequences to avoid hot block contention on indexes

  Delivered Franck Pachot 1.5K views 11 comments 49 points Most recent by Sven W. Jan 29, 2019 12:38PM
• 
  47

  Up Down
  DBMS_WALLET built-in package to manage certificates via PL/SQL API

  Active MortenBraten 276 views 3 comments 47 points Most recent by Omar M. Sawalhah May 12, 2020 9:22PM
• 
  47

  Up Down
  Change the ORA-1555 message

  Active Franck Pachot 773 views 9 comments 47 points Most recent by connor_mc_d-Oracle Nov 12, 2022 5:08AM
• 
  46

  Up Down
  Add support for the VALUES() constructor

  Under Review - Voting Still Open Lukas Eder 2.1K views 2 comments 46 points Most recent by connor_mc_d-Oracle Nov 12, 2022 5:05AM