Comparing Table Structure in Oracle

Опубликовано: 31 Март 2025
на канале: GoLearningPoint

1,210

Comparing Table Structure in ORACLE
Select USER_TAB_COLUMNS.COLUMN_NAME, USER_TAB_COLUMNS.DATA_TYPE From USER_TAB_COLUMNS Where Table_Name='EMPLOYEE';

Select USER_TAB_COLUMNS.COLUMN_NAME, USER_TAB_COLUMNS.DATA_TYPE From USER_TAB_COLUMNS Where Table_Name='DEPARTMENT';

WITH
T1 As (Select USER_TAB_COLUMNS.COLUMN_NAME, USER_TAB_COLUMNS.DATA_TYPE From USER_TAB_COLUMNS Where Table_Name='EMPLOYEE'),
T2 As (Select USER_TAB_COLUMNS.COLUMN_NAME, USER_TAB_COLUMNS.DATA_TYPE From USER_TAB_COLUMNS Where Table_Name='DEPARTMENT')
Select
T1.COLUMN_NAME EMP,
T1.DATA_TYPE EMP_TYPE,
T2.COLUMN_NAME DEPT,
T2.DATA_TYPE DEPT_TYPE
From T1 Full Join T2
On (T1.COLUMN_NAME=T2.COLUMN_NAME);

Select 'EMPLOYEE' TABLE_NAME,Column_Name, Data_Type
From
(
Select Column_Name, Data_Type
From USER_TAB_COLUMNS
Where Table_Name='EMPLOYEE'
Minus
Select Column_Name, Data_Type
From USER_TAB_COLUMNS
Where Table_Name='DEPARTMENT')

Union All

Select 'DEPT' TABLE_NAME,Column_Name, Data_Type
From
(
Select Column_Name, Data_Type
From USER_TAB_COLUMNS
Where Table_Name='DEPARTMENT'
Minus
Select Column_Name, Data_Type
From USER_TAB_COLUMNS
Where Table_Name='EMPLOYEE'
);

Home Page
https://tipsfororacle.blogspot.com/

#GoLearningPoint