Shulou(Shulou.com)06/01 Report--

Oracle10g exports excel through sqlplus

1. Create a script:

Cd / home/oracle/bristol

Vim a1.sql

Set linesize 200

Set term off verify off feedback off pagesize 999

Set markup html on entmap ON spool on preformat off

Spool / home/oracle/bristol/tables.xls

@ / home/oracle/bristol/get_tables.sql

Spool off

Exit

Vim a2.sql

Select * from CHANNELTYPE

2. Execute and get the output

Sqlplus "test/test" @ / home/oracle/bristol/a1.sql

3. Download the output excel result

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.