oracle中判斷某個字段是否存在
document為表名 docid為字段名 select count(column_name) from cols where table_name=upper('document') and column_name=upper('docid') 如果查詢出來的為0說明document中不存在docid字段
document為表名
docid為字段名
select count(column_name) from cols where table_name=upper('document') and column_name=upper('docid')
如果查詢出來的為0說明document中不存在docid字段
Powered by: BlogJava Copyright © 詩特林
