SQLPlus

Для захода в консоль без подключения

sqlplus /NOLOG

Для подключения сразу как SYSDBA

sqlplus / AS SYSDBA

Starting and Shutting Down a Database with SQL*Plus

SQL> startup;
SQL> shutdown;

Connect to Oracle Database with username SYSDBA:

SQL> CONNECT / AS sysdba;

Display status of Pluggable Databases

SQL> SHOW PDBS;

Switch between containers within the container database

SQL>ALTER SESSION SET container=PDBORCL;

SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;

Команда подключения

sqlplus <user>/<pass>@<local_SID>

  <local_SID> =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL= TCP)(Host= <addr>)(Port= 1521))
      (CONNECT_DATA = (SID = <remote_SID>))
    )

Версия СУБД

SELECT * FROM v$version;

SELECT * FROM v$database;

To list all the tables related the current user:

SELECT table_name FROM user_tables;  

List the tables accessible by the user:

SELECT table_name FROM all_tables;  

List all the tables (ADMIN):

SELECT table_name FROM dba_tables; 

Структура таблицы

DESC TABLE_NAME;