Расширенные возможности SQL. Команды SQL в рамках урока #1

-- Поиск данных в таблицах и базе SQL (часть 1)
-- https://youtu.be/iv7ux_5AroM

-------------------------------------------
-- Расширенные возможности SQL. Примеры команд SQL в рамках урока #1.



SELECT * FROM EMPLOYEES
WHERE ROWNUM <= 5
;


SELECT * FROM USER_TABLES
;


SELECT TABLE_NAME FROM USER_TABLES
WHERE
    TABLE_NAME LIKE '%ORDER%'
    OR TABLE_NAME LIKE '%EMPLOYEE%'
;


SELECT * FROM USER_TAB_COLUMNS
;


SELECT DISTINCT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE
    TABLE_NAME LIKE '%ORDER%'
    OR TABLE_NAME LIKE '%EMPLOYEE%'
;


SELECT DISTINCT TABLE_NAME, COLUMN_NAME FROM USER_TAB_COLUMNS
WHERE
    COLUMN_NAME LIKE '%ORDER%'
    OR COLUMN_NAME LIKE '%EMPLOYEE%'
;


SELECT OWNER, TABLE_NAME FROM ALL_TABLES
WHERE
    TABLE_NAME LIKE '%ORDER%'
    OR TABLE_NAME LIKE '%EMPLOYEE%'
;


SELECT DISTINCT OWNER, TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS
WHERE
    COLUMN_NAME LIKE '%ORDER%'
    OR COLUMN_NAME LIKE '%EMPLOYEE%'
;



SELECT DISTINCT OWNER FROM ALL_TAB_COLUMNS
WHERE
    COLUMN_NAME LIKE '%ORDER%'
    OR COLUMN_NAME LIKE '%EMPLOYEE%'
;


SELECT DISTINCT OWNER, TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS
WHERE
    (COLUMN_NAME LIKE '%ORDER%'
    OR COLUMN_NAME LIKE '%EMPLOYEE%')
    AND OWNER IN ('HR', 'OE')
ORDER BY OWNER, TABLE_NAME
;


SELECT * FROM ORDERS
;


SELECT * FROM OE.ORDERS
;