Dart
Dart
HTML Canvas
HTML Canvas
Redis
Redis
Bash
Bash
JavaScript
JavaScript
Oracle

Daily Use Commands (from SQL command line)

Connect to Contaner or PDB
 
CONN <user>/<pwd>@//<host>:<listener port>/<service> {as sysdba};
 
CONN <user>/<pwd>@//<tns_entry> {as sysdba};
Display Current Container or PDB
 
SHOW CON_NAME;
 
SELECT SYS_CONTEXT('USERENV','CON_NAME')
 
SHOW CON_ID
;
 
  FROM DUAL;
List Containers and PDBs on Instance
 
SELECT PDB_NAME, Status
 
SELECT Name, Open_Mode
 
SELECT Name,PDB
 
  FROM DBA_PDBS
 
FROM V$PDBS
 
FROM V$SERVICES
 
ORDER BY PDB_Name;
 
ORDER BY Name;
 
ORDER BY Name;
Change Container or PDB
 
ALTER SESSION SET container=<name>;
 
ALTER SESSION SET container=cdb$root;
Comments
Related