oracle表導(dǎo)出為excel 請問oracle數(shù)據(jù)庫如何導(dǎo)出數(shù)據(jù)庫的表結(jié)構(gòu)?
請問oracle數(shù)據(jù)庫如何導(dǎo)出數(shù)據(jù)庫的表結(jié)構(gòu)?Oracle數(shù)據(jù)庫導(dǎo)出數(shù)據(jù)庫的表結(jié)構(gòu),使用SQL查詢將數(shù)據(jù)復(fù)制到excel表并保存。查詢代碼:select t.table | name,t.colUMN
請問oracle數(shù)據(jù)庫如何導(dǎo)出數(shù)據(jù)庫的表結(jié)構(gòu)?
Oracle數(shù)據(jù)庫導(dǎo)出數(shù)據(jù)庫的表結(jié)構(gòu),使用SQL查詢將數(shù)據(jù)復(fù)制到excel表并保存。查詢代碼:
select t.table | name,
t.colUMN | name,
t.DATA | TYPE | | “(”| | t.DATA | LENGTH | | “)”,
t1.COMMENTS
FROM User | Tab | Cols t,User | Col | COMMENTS t1
WHERE t.table | name=t1.table | name
t.colUMN name=t1.colUMN name