{"id":811,"date":"2007-08-13T07:01:48","date_gmt":"2007-08-13T07:01:48","guid":{"rendered":"http:\/\/www.msinterdev.org\/wp\/2007\/08\/13\/oracleshell-script-%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ec%bf%bc%eb%a6%ac-%ec%8b%a4%ed%96%89\/"},"modified":"2007-08-13T07:01:48","modified_gmt":"2007-08-13T07:01:48","slug":"oracleshell-script-%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ec%bf%bc%eb%a6%ac-%ec%8b%a4%ed%96%89","status":"publish","type":"post","link":"http:\/\/www.msinterdev.org\/wp\/2007\/08\/13\/oracleshell-script-%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ec%bf%bc%eb%a6%ac-%ec%8b%a4%ed%96%89\/","title":{"rendered":"oracle_shell script \ub97c \uc774\uc6a9\ud55c \ucffc\ub9ac \uc2e4\ud589"},"content":{"rendered":"

xxxx.sql \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131<\/p>\n

var a varchar2;
var b number;
begin
    :a := ‘&1’;
    :b := &2;
end;
\/<\/p>\n

select count(*) from zaut_subscriber_fi where pr_flag=:a and rownum <= :b;
exit<\/p>\n

=================================================================================
shell \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131. ( \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uad6c\uc131 \ud558\uc5ec ps \uba85\ub839\uc5b4\ub85c \uacc4\uc815\uc744 \uc54c\uc544 \ub0bc \uc218 \uc5c6\ub3c4\ub85d \ud55c\ub2e4.)
USER=zpro
PASSWORD=zpro<\/p>\n

sqlplus <<EOF
$USER\/$PASSWORD<\/p>\n

@b ‘I’ 10<\/p>\n

EOF<\/p>\n","protected":false},"excerpt":{"rendered":"

xxxx.sql \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131 var a varchar2;var b number;begin    :a := ‘&1’;    :b := &2;end;\/ select count(*) from zaut_subscriber_fi where pr_flag=:a and rownum <= :b;exit =================================================================================shell \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131. ( \uc544\ub798\uc640 \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uad6c\uc131 \ud558\uc5ec ps \uba85\ub839\uc5b4\ub85c \uacc4\uc815\uc744 \uc54c\uc544 \ub0bc \uc218 \uc5c6\ub3c4\ub85d \ud55c\ub2e4.)USER=zproPASSWORD=zpro sqlplus <<EOF$USER\/$PASSWORD @b ‘I’ 10 EOF<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[433,693,544,527,172],"class_list":["post-811","post","type-post","status-publish","format-standard","hentry","category-about-knowledge-db_oracle","tag-oracle","tag-shell","tag-sql","tag-527","tag-172"],"_links":{"self":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/posts\/811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/comments?post=811"}],"version-history":[{"count":0,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/posts\/811\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/media?parent=811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/categories?post=811"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.msinterdev.org\/wp\/wp-json\/wp\/v2\/tags?post=811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}