A wee bit late to the party - but just came across this and recalled this
question:
SQL> select * from v$osstat where stat_name = 'INST_TYPE';
STAT_NAME VALUE
OSSTAT_ID COMMENTS
CUM
---------------------------------------------------------------- ----------
---------- ----------------------------------------------------------------
---
INST_TYPE 0
20 Oracle Cloud
NO
Stefan
On Sat, Nov 23, 2019 at 7:41 PM kris rice <kris.rice@xxxxxxxx> wrote:
Here you go...
https://twitter.com/krisrice/status/1198219314412838912?s=20
SQL Example here: https://t.co/PQYY3CHtUF?amp=1
-kris
On Fri, Nov 22, 2019 at 10:29 AM Ethan Post <post.ethan@xxxxxxxxx> wrote:
Anyone know of a constant (or way) I can access to determine if I am
trying to compile into an autonomous database? I would like to set up some
conditionals in my code.
Most of the examples use DBMS_DB_VERSION but don't see anything in the
docs for this but might not be looking in the right place.
Alternative path at the moment (untested) is to query for the cloud user
accounts and if found try to set a CCFLAG and check for that but ideally I
want to just compile the package and not have to run SQL prior to that.
Thanks,
Ethan
https://e-t-h-a-n.com