DBMS_SQL_TRANSLATOR.SQL_ID

select
   dbms_sql_translator.sql_id('select * from user_objects')
from
   dual;
--
-- 0d7hz8d1y5vw6

select *
from
   v$sql
where
   sql_id = '0d7hz8d1y5vw6';

select
   sys.dbms_sqltune_util0.sqltext_to_sqlid('select * from user_objects')
from
   dual;