[[SQLPlus]]

Oracle

SQLPlus

Конфигурация TNS

local_SID =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= hostname.network)(Port= 1521))
    (CONNECT_DATA = (SID = remote_SID))
  )

Подключение

sqlplus user/pass@local_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;

Обсуждение

Aleksey, 2016/07/08 13:36

LIMIT

SELECT column_name(s) FROM table_name WHERE ROWNUM <= number ORDER BY START_DATE DESC;
Ваш комментарий. Вики-синтаксис разрешён:
8 +1 = ?
 
tools/databases/oracle/sqlplus.txt · Последние изменения: 2016/07/08 13:28 — lexa
Gentoo Linux Driven by DokuWiki