Oracle输出html字体颜色,Oracle sqlplus HTML report - alternating rows color

/* File: sqlplus-runner-csv.sql v1.0.0 docs at the end */

/* do not print echo commands */

set echo off

/* do not require feedback from the user */

set feedback off

/* set a nice prompt */

set sqlprompt ''

/* -- separate columns with a comma */

set colsep ';'

/* -- only one header row */

set pagesize 0

/*-- remove trailing blanks */

set trimspool on

/* REMOVE THE WHITE SPACE */

set trimout on

/* -- this may or may not be useful...depends on your headings. */

set headsep ON

/* how- long the line should be */

set linesize 3000

/* print the headers as well */

set heading on

/* request full html for output */

/* set markup html on spool off */

/* define the file where the output of the results should be stored */

spool "&1..html"

-- START SQL

select '

tables

' from dual ;

-- specify grey ( #CCC ) and white colors

-- open the row

select '

'

-- print a single table cell

|| '

' || OWNER || ''

-- print another single table cell

|| '

' || TABLE_NAME || ''

-- close the row

|| '

' FROM

-- IF YOU NEED ORDER BY CLAUSE AS WELL,

(

SELECT OWNER , TABLE_NAME FROM ALL_TABLES ORDER BY OWNER , TABLE_NAME

)

;

select '

' from dual ;

-- STOP SQL

spool off ;

/* exit the sqlplus tool */

EXIT 0;

/*

Purpose:

- to provide a single sql statement to run agains an oracle database

- to output a single file passed as the first argument to the script

VersionHistory:

1.1.0 --- 2012.04.08 - 23:04:19 --- ysg --- Added order by clause

1.0.0 --- 2012.04.08 - 22:07:19 --- ysg --- Initial creation

*/