0/3 : sql.bsq usefull information /* please check this on sql.bsq file -------------------------------- 1 = table check, 2 = primary key, 3 = unique, 4 = referential, 5 = view with CHECK OPTION, 6 = view READ ONLY check 7 - table check constraint associated...
HIDDEN CONTENT 1/3 Should create a table which contains the complete necessary information by row drop table t_ind; create table t_ind ( index_owner varchar2(30), index_name varchar2(30), index_type VARCHAR2(27), table_owner varchar2(30), table_name varchar2(30),...
HIDDEN CONTENT --> Compare tables --> Compare column_name ( could be extented simply by adding column_id, data_type, DATA_LENGTH) No matter about position, type, lenght of the columns prompt comparaison TABLES select '&util','Miss', table_name from dba_tables...
