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'
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 도 참조
제어판 --> 색인 옵션 --> 고급 --> 파일 형식 탭에서 파일 형식 별로 속성 및 파일 내용 색인 기능을 이용할 수 있습니다.
http://answers.microsoft.com/ko-kr/windows/forum/windows_7-windows_programs/%EC%9C%88%EB%8F%84%EC%9A%B07/c07ad39d-6887-4eae-92bc-f29a5489714e?msgId=bb07ad70-733e-4875-80e0-bd13a846a0c0
alt + f7
option > options
'Create PLAN_TABLE' 단추
select * from ALL_PART_KEY_COLUMNS where name = 'TABLE_NAME'
union
select * from ALL_SUBPART_KEY_COLUMNS where name = 'TABLE_NAME'
http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2016.htm#REFRN20157
http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin005.htm
|
