hello experts see code below
create or replace PROCEDURE CHECK_FOR_SPECIAL_CHARACTERS (p_owner in varchar2, p_table in varchar2) AS
temp_var varchar2(1000);
sql_stmt varchar2(1000);
BEGIN
for r in (select table_name, column_name, Data_type from ALL_TAB_COLUMNS p
where p.owner like p_owner || '%'
and p.table_name like p_table || '%')
loop
EXECUTE IMMEDIATE 'select ' || r.column_name || 'from ' || r.table_name into temp_var;
dbms_output.put_line(temp_var );
end if;
end loop;
END CHECK_FOR_SPECIAL_CHARACTERS;