Hello,
Our Application has some complication and based on type of database it chooses required action.
What we need is ::
Is there any common query that can tell whether the database is
11g version OR 12c NON CDB OR 12c CDB OR 12c PDB
Our Application needs to do some prework( prechecks ) before creating the schema in any of the above databases.
and this prework is different for each of them.
The problem that currently i m facing if i execute a query "select name,cdb from v$database" to check whether database is CDB or NON CDB.
Same query when executed on 11g gives an error ,as CDB is not defined in 11g.
So what is the best way to do this.
Thanks.