摘要:
【Oracle SQL】 一行流方式: select count(*) from all_tables where table_name=upper('your tableName') 层次化方式: select count(*) from all_tables where table_name=u 阅读全文
摘要:
【SQL】 select a.table_name as name,b.comments as remark from (select table_name from user_tables ) a inner join (select table_name,comments from user_t 阅读全文
摘要:
【数据库版本】 Oracle 19c 服务器版 【出错记录】 SQL> create user hy identified by 1234; create user hy identified by 1234 * 第 1 行出现错误: ORA-65096: 公用用户名或角色名无效 【出错原因】 or 阅读全文
摘要:
【sql】 select a.column_name as name,a.column_id as order_num,b.comments as remark from (select column_name,column_id from user_tab_columns where table_ 阅读全文