Explore >> Select a destination
|
You are here 
|
sqlmaria.com | ||
| | | | |
parvu.org
|
|
| | | | | This article compiles various queries and code blocks used to manage disabled constraints in a database schema. It includes SQL statements to identify and enable these constraints. The content will be updated regularly with new insights, and it lists the tested database versions, starting with Oracle Database 23ai. | |
| | | | |
connor-mcdonald.com
|
|
| | | | | Anyone who has used APEX will know that in addition to the Builder UI, there is a comprehensive data dictionary for APEX-prefixed views to expose all the metadata associated with APEX applications and workspaces. SQL> select view_name 2 from dba_views 3 where owner = 'APEX_240200' 4 and view_name like 'APEX%' 5 order by 1;... | |
| | | | |
www.bobbydurrettdba.com
|
|
| | | | | I had a five-minute conversation with Oracle development Friday that rocked my world. I found out that parsing blocks stats which blocks parsing. We have a system with queries that are taking minu... | |
| | | | |
tonyhasler.wordpress.com
|
|
| | | As has happened a couple of times recently, comments on a blog of mine have helped me understand the subject matter on which I am commenting far better. In this case a dialogue with Dom Brooks on my previous blog on how to simulate a stored outline/SQL baseline with FORCE_MATCH using SQL profiles has provided... | ||
