查询表中所有的列:
select column_name from user_tab_columns where table_name='T_USER';
查询表中字段的名字、类型、长度(注意表名和字段名大写):
select column_name,data_type,data_length from user_tab_columns where table_name='T_USER' and column_name='USERNAME';
select column_name from user_tab_columns where table_name='T_USER';
查询表中字段的名字、类型、长度(注意表名和字段名大写):
select column_name,data_type,data_length from user_tab_columns where table_name='T_USER' and column_name='USERNAME';