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%';
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%';