A way to check for the Oracle parameter "compatible" is to check the sys.v_$parameter view:
select name, value from sys.v_$parameter where name = 'compatible'
The only problem is that you need rights over the "SYS" tablespace for this.
