[SQLPLUS/Shell Script] 쉘스크립트 쿼리 사용시

#/sbin/sh

sqlscript=`sqlplus -S ugens/ugens << end

set pagesize 0 feedback off ver off heading off echo off

CREATE TABLE test512(

test1 VARCHAR2(20),

test2 VARCHAR2(5),

test3 VARCHAR2(6)

);

INSERT INTO test512 VALUES('TEST','1','2');

COMMIT;

exit`

echo "result " $sqlscript

#end