SQL to find Oracle SID

select sys_context('userenv','db_name') s_id from dual;

Similar queries to get SID.

select * from v$database;
select ora_database_name from dual;
select * from global_name;