oracle获取表结构:
set long 800000000 pagesize 1000
select dbms_metadata.get_ddl( 'TABLE', 'RS_BLANKSIM_INFO_USED', 'MANAGER' ) from dual;
sqlplus网络方式连接oracle:
sqlplus MANAGER/Ora_0910@10.167.135.70/orcl
sqlplus执行SQL语句:
sqlplus MANAGER/Ora_0910@10.167.135.70/orcl @/home/oracle/czw/a.sql
a.sql的内容如下:
SQL语句;(分号结尾)
/
exit
sqlplus -silent /nolog <<EOF
conn usrName/Password@Inst;
set feedback off;
set head off;
spool OutPutFileName;
select xxxx FROM TableName WHERE yyyy=zzzz;
spool off;
EOF