desc tab_name or select * from cols where table_name = &tab_name
Top myh0305(seasail) ( ) 信誉:100 2006-04-26 10:18:00 得分: 0
desc talbename这个命令只是oracle sql/plus自带的
toad、sqlplus 等第三方工具照样支持
to sxiong() : toad sqlplus 等第三方工具照样支持 sqlplus 好像不是第三方的吧
Oracle9i支持:select max(substr(SYS_CONNECT_BY_PATH(COLUMN_NAME, ','),2)) col from ( select COLUMN_NAME,column_id from user_tab_columns where table_name='&表名') start with column_id=1 connect by column_id=rownum;
或者在Pl/SQl Developer中查看
因为有关开发ORACLE的软件都可以用~
or
select * from cols where table_name = &tab_name
myh0305(seasail) ( ) 信誉:100 2006-04-26 10:18:00 得分: 0
desc talbename这个命令只是oracle sql/plus自带的
toad、sqlplus 等第三方工具照样支持
toad sqlplus 等第三方工具照样支持
sqlplus 好像不是第三方的吧
select COLUMN_NAME,column_id from user_tab_columns where table_name='&表名')
start with column_id=1
connect by column_id=rownum;