=============
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)))
========================================================================================================================