Comparing objects between two database objects with one select statement
Hello,
Need to make comparation that would
compare ddl definitions of tables between source and target schema ( same number of columns, columns have same names, each columns has same datatype ).
Would be safe for that case to use GET_DDL function which returns DDL definnition into CLOB ?
Is Oracle doing some character cleansing and character strings standardisation when storing DDL definitions so that strings are completely comparable ?
Would make sense to do similar comparation between two schemas on other objects like VIEW definitions, procedure source code?
Thank you for any reference or experience,