连接数据库的脚本，连接后自动执行一条语句

XQKA

连接数据库的脚本，连接后自动执行一条语句，保留连接的会话。这可以实现吗?


more conn
#!/bin/ksh
export ORACLE_SID=TESTDB
sqlplus " / as sysdba"

我执行这个脚本后就连接到TESTDB，并保留连接会话，出现SQL> 提示符，等待用户输入

sh conn

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jun 21 11:39:29 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL>


现在我需要连接进去后执行一条语句alter session set nls_data_format='YYYY-MM-DD hh24:mi:ss';

请问这个脚本能实现吗？

waker

(echo ' / as sysdba';cat)|sqlplus

XQKA

waker 发表于 2012-06-21 12:34
(echo ' / as sysdba';cat)|sqlplus

alter session set nls_data_format='YYYY-MM-DD hh24:mi:ss';

需要这个命令是自动执行的，而且会话不断开，否则重新连接的话上面的命令就没什么意义了。

XQKA

还是用sqlplus自身的方法来解决吧
写一个head.sql
more head.sql
set line 145
set pages 99
set line 1500
set feed off
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
set feed on
set time on
set timi on
select sysdate from dual;


more conn
#!/bin/ksh
export ORACLE_SID=TESTDB
sqlplus " / as sysdba" @head.sql

sh conn
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jun 21 12:52:01 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options


SYSDATE
-------------------
2012-06-21 12:52:01

1 row selected.

Elapsed: 00:00:00.00
12:52:01 SQL>

rdcwayx

1. sqlplus " / as sysdba" <<ENDOFSQL
   
2. alter session set nls_data_format='YYYY-MM-DD hh24:mi:ss';
   
3. exit;   #这个可要可不要，看你的需求
   
4. ENDOFSQL

复制代码

XQKA

rdcwayx 发表于 2012-06-21 13:04

不符合的，试过了。
不管是否有exit，它都将退出sqlplus

waker

(echo ' / as sysdba';echo "alter session set nls_data_format='YYYY-MM-DD hh24:mi:ss'"; cat)|sqlplus