이응기역

https://docs.oracle.com/cd/B10501_01/server.920/a90842/ch13.htm

http://www.cs.rpi.edu/~musser/dsc/idl/idl-overview_13.html

request.getParameterMap().put(parameterName, new String[] {parameterValue});

(http://stackoverflow.com/questions/892537/how-to-set-a-parameter-in-a-httpservletrequest

)

http://egloos.zum.com/romanticDM/v/2508766

http://docs.oracle.com/cd/E13203_01/tuxedo/tux81/pdf/idl2java.pdf

http://www.thegeekstuff.com/2009/09/multitail-to-view-tail-f-output-of-multiple-log-files-in-one-terminal/

$ vi multi-tail.sh
#!/bin/sh

# When this exits, exit all back ground process also.
trap 'kill $(jobs -p)' EXIT

# iterate through the each given file names,
for file in "$@"
do
	# show tails of each in background.
	tail -f $file &
done

# wait .. until CTRL+C
wait

http://razorsql.com/articles/oracle_compile_errors.html

select * from SYS.USER_ERRORS where NAME = 'RAISE_SALARY' and type = 'PROCEDURE'

SQL > @1.sql

https://addons.mozilla.org/ko/firefox/addon/web-developer/

설치안될때에는 *.xpi 를 내려받아 수동 설치한다

http://psoug.org/snippet/Create-Package_450.htm 참조

SQL> CREATE TABLE test2 (id NUMBER, name CHAR(20));

SQL> CREATE OR REPLACE PACKAGE test_pkg AS
  PROCEDURE add_test (col1_in NUMBER, col2_in CHAR);
  PROCEDURE del_test (col1_in NUMBER);
END test_pkg;
/
 
SQL> CREATE OR REPLACE PACKAGE BODY test_pkg AS
 
  PROCEDURE add_test(col1_in IN NUMBER,col2_in IN CHAR) AS
  BEGIN
    INSERT INTO test2 VALUES (col1_in,col2_in);
  END add_test;
 
  PROCEDURE del_test(col1_in IN NUMBER) AS
  BEGIN
    DELETE FROM test WHERE id = col1;
  END del_test;
 
END test_pkg;
/

SQL> call test_pkg.add_test(1, 'aaa')

/

SQL> commit

/

SQL> select * from test2

/

http://www.journaldev.com/2502/jdbc-callablestatement-stored-procedure-in-out-oracle-struct-cursor-example-tutorial 도 참조