Skip to content

Instantly share code, notes, and snippets.

@davidhooey

davidhooey/oracle_sql_id_from_sql_text.sql

Last active December 22, 2015 07:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save davidhooey/6436866 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save davidhooey/6436866 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Determine SQL_ID given SQL text.
Raw
oracle_sql_id_from_sql_text.sql
select dbms_sqltune_util0.sqltext_to_sqlid('SQL_TEXT_HERE'||chr(0)) sql_id from dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment