create or replace procedure t_name_column(abc in char)
as
t_name varchar2(30);
t_column_name varchar2(300);
begin
select table_name ,column_name into t_name,t_column_name 
from user_tab_columns where table_name like abc;
end;

begin
t_name_column('CUSTOMER');
end;

create or replace procedure t_name_column(table_start in char)
as
     t_name varchar2(30);
     t_column_name varchar2(300);
begin
for c5 in (select table_name ,column_name 
into t_name,t_column_name 
from user_tab_columns where table_name like 'table_start||%')
    loop
           dbms_output.put_line(t_name ||t_column_name);
    
    end loop;

end;

begin
t_name_column('ACCOUNT');
end;

like 'table_start||%'

like table_start||'%'