生成WORD

最新推荐文章于 2021-03-20 20:23:25 发布

hunan_liu_weidong

最新推荐文章于 2021-03-20 20:23:25 发布

阅读量266

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/hunan_liu_weidong/article/details/72912451

版权

oracle 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

set serveroutput on size 999999999999
spool d:/生产数据字典表清单.txt
set pagesize 999999999999
set linesize 999999999999

DECLARE
begin
dbms_output.enable(99999999999999);
DBMS_OUTPUT.put_line('<html>');
DBMS_OUTPUT.put_line('<body>');
DBMS_OUTPUT.put_line('<table border=1>');
DBMS_OUTPUT.put_line('<tr>');
DBMS_OUTPUT.put_line('<th>序号</th>');
DBMS_OUTPUT.put_line('<th>表名</th>');
DBMS_OUTPUT.put_line('<th>表注释</th>');
DBMS_OUTPUT.put_line('<th>索引名</th>');
DBMS_OUTPUT.put_line('</tr>');
FOR TABS IN (SELECT ROWNUM AS RN,TAB.* FROM (
SELECT T.TABLE_NAME,
T.COMMENTS,
(SELECT SUMC(I.INDEX_NAME)
FROM SP_DICT_INDEX I
WHERE I.TABLE_NAME = T.TABLE_NAME) AS INDEX_NAME
FROM SP_DICT_TABLES T
ORDER BY T.TABLE_NAME) TAB) LOOP
DBMS_OUTPUT.put_line('<tr>');
DBMS_OUTPUT.put_line('<td>'|| TABS.RN || '</td>');
DBMS_OUTPUT.put_line('<td>'|| TABS.TABLE_NAME || '</td>');
DBMS_OUTPUT.put_line('<td>'|| TABS.COMMENTS ||'</td>');
DBMS_OUTPUT.put_line('<td>'||TABS.INDEX_NAME||'</td>');
DBMS_OUTPUT.put_line('</tr>');
END LOOP;
DBMS_OUTPUT.put_line('</table>');
DBMS_OUTPUT.put_line('</body>');
DBMS_OUTPUT.put_line('</html>');
end;
/
spool off;

hunan_liu_weidong

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
生成WORD

set serveroutput on size 999999999999spool d:/生产数据字典表清单.txtset pagesize 999999999999set linesize 999999999999DECLAREbegin dbms_output.enable(99999999999999); DBMS_OUTPUT.put_li
复制链接

扫一扫