sqlplus执行一条插入命令

1、在单机环境下

要想启动或关闭ORACLE系统必须首先切换到ORACLE用户，如下

su - oracle

a、启动ORACLE系统

oracle>svrmgrl

SVRMGR>connect internal

SVRMGR>startup

SVRMGR>quit

b、关闭ORACLE系统

oracle>svrmgrl

SVRMGR>connect internal

SVRMGR>shutdown

SVRMGR>quit

启动oracle9i数据库命令：

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Oct 31 13:53:53 2003

Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.

SQL>connect / as sysdba

Connected to an idle instance.

SQL>startup^C

SQL>startup

ORACLE instance started.

在每条语句的后面加分号,作成.sql脚本在SQLPLUS中执行

例:update tab_a set a1 =(select a1 from tab_b where id = 'id1')

a2 =(select a2 from tab_b where id = 'id1')

---