Oracle中得到一张表中的所有列

select column_name from user_tab_columns where table_name='tablename'

 

 

declare
  tmp varchar2(2000);
begin
  for i in (select column_name from user_tab_columns where table_name='TMP')

   loop
     tmp:=i.column_name||','||tmp;
   end loop;
  dbms_output.put_line(tmp);
end;
/