- /*
- 列出指定表的所有字段, 使用时将 SYS_TABLE 换成具体表名即可[Oracle 10g下运行通过]
- */
- declare
- cursor c is
- select a.COLUMN_NAME||' ' from user_tab_columns a
- where a.TABLE_NAME = 'SYS_TABLE';
- col user_tab_columns.COLUMN_NAME%type;
- cols varchar2(4000);
- begin
- open c;
- loop
- fetch c into col;
- exit when c%notfound;
- cols := cols || col;
- end loop;
- close c;
- dbms_output.put_line(cols);
- end;
- --该片段来自于http://www.codesnippet.cn/detail/250320132544.html
来源: http://www.codesnippet.cn/detail/250320132544.html