Find ORACLE_SID via SQL

[JMac]

Is he after the SID specifically, or just a way to identify the database?

Try

SELECT * FROM global_name;