SQL query to get all details for Oracle 19c Database from v$database
SQL query to get all details for Oracle 19c Database from v$database
-- Database Detail (Standalone DB / RAC DB/ Container DB)
SET LINES 300
SELECT inst_id, name, open_mode, log_mode, database_role, cdb, con_id, created
FROM gv$database;