Skip to content

Instantly share code, notes, and snippets.

@secf4ult

secf4ult/Oracle.sql

Last active June 21, 2024 03:20
Show Gist options
  • Save secf4ult/dedaf70fca1411de4c7a90d7d2b8935f to your computer and use it in GitHub Desktop.
Save secf4ult/dedaf70fca1411de4c7a90d7d2b8935f to your computer and use it in GitHub Desktop.
Download ZIP
SQL cheatsheet
Raw
Oracle.sql
-- Get the execution plan for the last command
SELECT * FROM dbms_xplan.display_cursor();
-- Get the hinted plan for the last command
SELECT * FROM dbms_xplan.display_cursor(format=>'+outline'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment