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

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

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


SELECT * FROM ALL_OBJECTS;


SELECT * FROM ALL_OBJECTS
WHERE
    OBJECT_TYPE = 'TABLE'
    AND OBJECT_NAME LIKE '%CUSTOMERS%'
;


SELECT * FROM ALL_OBJECTS
WHERE
    OBJECT_TYPE IN ('TABLE', 'VIEW')
;


SELECT OWNER, OBJECT_NAME, CREATED, LAST_DDL_TIME
FROM ALL_OBJECTS
WHERE
    UPPER(OBJECT_NAME) = 'EMPLOYEES'
    AND OBJECT_TYPE = 'TABLE'
;


SELECT * FROM ALL_TAB_COMMENTS
WHERE
    UPPER(COMMENTS) LIKE '%EMPLOYEE%'
;


SELECT * FROM ALL_COL_COMMENTS
WHERE
    COLUMN_NAME LIKE '%EMPLOYEE%'
    AND COMMENTS IS NOT NULL
;


SELECT * FROM ALL_COL_COMMENTS
WHERE
    COLUMN_NAME LIKE '%EMPLOYEE%'
    AND COMMENTS IS NOT NULL
    AND TABLE_NAME = 'JOB_HISTORY'
;


SELECT * FROM ALL_TABLES
WHERE TABLE_NAME LIKE 'KMV_%'
;


SELECT 'drop table ' || TABLE_NAME || ' purge;' AS TNAME FROM ALL_TABLES
WHERE TABLE_NAME LIKE 'KMV_%'
;


SELECT 'alter table ' || TABLE_NAME || ' modify ' || COLUMN_NAME || ' varchar2(100);' AS TNAME
FROM ALL_TAB_COLUMNS
WHERE
    TABLE_NAME LIKE 'KMV_%'
    AND COLUMN_NAME = 'CITY'
;