Display Oracle SID name using SQL

Execute the following SQL as a SYS or SYSTEM user:

select instance_name from v$instance;