Oracle Find NVARCHAR Field

To find NVARCHAR Field , run below SQL

select  table_name,column_name,data_type from user_tab_columns  where data_type like 'NVARCHAR%';
select  owner, table_name,column_name,data_type from dba_tab_columns  where data_type like 'NVARCHAR%';

Leave a Reply