ʹÓÃSQL*PLUS¹¹½¨ÍêÃÀexcel»òhtmlÊä³ö
ת×Ô£ºhttp://hong9270503.blog.163.com/blog/static/127292320091611319516/
ͨ¹ýSQL*PLUSÎÒÃÇ¿ÉÒÔ¹¹½¨ÓѺõÄÊä³ö£¬Âú×ã¶àÑù»¯Óû§ÐèÇó¡£
¡¡¡¡
±¾Àýͨ¹ý¼òµ¥Ê¾Àý£¬½éÉÜͨ¹ýsql*plusÊä³öxls£¬htmlÁ½ÖÖ¸ñʽÎļþ.
¡¡¡¡ Ê×ÏÈ´´½¨Á½¸ö½Å±¾:
¡¡¡¡
1.main.sql
¡¡¡¡ ÓÃÒÔÉèÖû·¾³£¬µ÷ÓþßÌ幦Äܽű¾
¡¡¡¡ 2.¹¦Äܽű¾-get_tables.sql
¡¡¡¡
ΪʵÏÖ¾ßÌ幦ÄÜÖ®½Å±¾
¡¡¡¡ ͨ¹ýÕâÑùÁ½¸ö½Å±¾¿ÉÒÔ±ÜÃâspoolÖеÄÈßÓàÐÅÏ¢.
¡¡¡¡ ʾÀýÈçÏÂ:
¡¡¡¡
1.main.sql½Å±¾:
[oracle@jumper utl_file]$ more main.sql
set
linesize 200
set term off verify off feedback off pagesize 999
set
markup html on entmap ON spool on preformat off
spool tables.xls
@get_tables.sql
spool
off
exit
¡¡¡¡ 2.get_tables.sql½Å±¾:
[oracle@jumper
utl_file]$ more get_tables.sql
select
owner,table_name,tablespace_name,blocks,last_analyzed
from all_tables
order by 1,2;
¡¡¡¡ 3.Ö´Ðв¢»ñµÃÊä³ö:
[oracle@jumper utl_file]$
sqlplus "/ as sysdba" @main
SQL*Plus: Release 9.2.0.4.0 -
Production on Mon Apr 25 10:30:11 2005
Copyright (c) 1982, 2002,
Oracle Corporation. All rights reserved.
Connected to:
Oracle9i
Enterprise Edition Release 9.2.0.4.0 - Production
With the
Partitioning option
JServer Release 9.2.0.4.0 - Production
Disconnected
from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With
the Partitioning option
JServer Release 9.2.0.4.0 - Production
[oracle@jumper
utl_file]$ ls -l tables.xls
-rw-r--r-- 1 oracle dba 69539 Apr 25
10:30 tables.xls
[oracle@jumper utl_file]$
¡¡¡¡´Ë´¦Êä³öΪxlsÎļþ£¬Í¨¹ýÏÂͼÎÒ
ÃÇ¿ÉÒÔ¿´µ½Êä³öЧ¹û:
¡¡¡¡°Ñmain.sql½Å±¾Öеģ¬spool tables.xls¸ü¸ÄΪspool
tables.htm,ÎÒÃÇ¿ÉÒÔ»ñµÃhtm¸ñʽÊä³ö£¬Ð§¹ûÈçÏÂͼ:
Ïà¹ØÎĵµ£º
Ò»﹕
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì﹐Ëü²»Äܱ»ÏÔʽµØµ÷ÓÃ﹐¶øÊÇÔÚÍù±íÖвåÈë¼Ç¼﹑¸üмǼ»òÕßɾ³ý¼Ç¼ʱ±»×Ô¶¯µØ¼¤»î¡£ËùÒÔ´¥·¢Æ÷¿ÉÒÔÓÃÀ´ÊµÏÖ¶Ô±íʵʩ¸´ÔÓµÄÍê
ÕûÐÔÔ¼`Êø¡£
¶þ﹕ SQL
ServerΪÿ¸ö´¥·¢Æ÷¶¼´´½¨ÁËÁ½¸öרÓñí ......
SQL Server2005¶Áȡע²á±í
DECLARE @result varchar(255)
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\OperationControlSystem\ClientID','Prefix',@result OUT ---×¢Òâ±ØÐëÓÐOUT·ñÔò@resultΪ¿Õ
SELECT @result
¼ÙÈçÔÚÖ´Ðйý³ÌÖгöÏÖ´íÎ󣬿ÉÄÜÊÇδÕÒµ½´æ´¢¹ý³Ì_master.dbo.xp_regread
ÔÒò£º×ö°²È« ......
´ò¿ª“¹ÜÀí¹¤¾ß¨D¨D×é¼þ·þÎñ”£¬ÒÔ´Ë´ò¿ª“×é¼þ·þÎñ¨D¨D¼ÆËã»ú”£¬ÔÚ“ÎҵĵçÄÔ”Éϵã»÷ÓÒ¼ü¡£
ÔÚMSDTCÑ¡ÏÖУ¬µã»÷“°²È«ÅäÖÔ°´Å¥¡£
ÔÚ°²È«ÅäÖô°¿ÚÖÐ×öÈçÏÂÉèÖãº
Ñ¡ÖГÍøÂçDTC·ÃÎÊ”
ÔÚ¿Í»§¶Ë¹ÜÀíÖÐÑ¡ÖГÔÊÐíÔ¶³Ì¿Í»§¶Ë”“ÔÊÐ ......
--»ñµÃµ±Ç°ËùÓÐÇý¶¯Æ÷
exec master.dbo.xp_availablemedia
--»ñµÃ×ÓĿ¼Áбí
exec master.dbo.xp_subdirs 'c:\'
--»ñµÃËùÓÐ×ÓĿ¼µÄĿ¼Ê÷½á¹¹
exec master.dbo.xp_dirtree 'c:\'
--¶©ÔÄÎļþɾ³ý
declare @tempTable table (Cont varchar(50))
declare @strTemp varchar(50)
declare @dirPath varchar(50)
declar ......