在shell中编写sql语句

1.建立测试表
create table test
(id varchar2(10),name varchar2(10));


2.编写shell vi insert.sh
#!/bin/bash
id="'aaa'"
name="'bb cc dd'"
sqlplus yc/manager1@demo73 <<EOF
insert into test values($id,$name);
commit;
exit
EOF