Oracle库连接

=============
tnsnames.ora
==========================================================================
ORAHON222 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.XXX.XXX)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORAHON)
    )
  )
===========================================================================

==========
cmd1--連続
===========================================================
sqlplus /nolog
conn username/userpassword@172.16.XXX.XXX:1521/SERVICE_NAME

===========================================================

=================================
cmd2--実行1-返却値含むのfunction
===========================================================
declare
msg varchar2(100);
begin
msg := A0001_JB001(to_date('2014/04/01','YYYY/MM/DD'),0);
end;
===========================================================

=================================
cmd2--実行2-編集用のメモ
===========================================================
ed
===========================================================

=================================
cmd2--実行3-package-body.method()
===========================================================
exec JB_M01001_PKG.JB_M01001_PROC();
===========================================================

====
CSE
========================================================================================================================
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.XXX.XXX)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=skum)))
========================================================================================================================