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' 단추
$ cat test1.sh
logdir="/abc/def";
filename=`ls -lt $logdir/MY_LOG.log | tail -1 | cut -b 59 -`
v=`grep KEY_WORD $filename | wc`
w=`echo $v | sed 's/ .*//'`
echo
echo
echo
printf " KET_WORD count : [%08d]\n" $w
select * from ALL_PART_KEY_COLUMNS where name = 'TABLE_NAME'
union
select * from ALL_SUBPART_KEY_COLUMNS where name = 'TABLE_NAME'
select * from table_name PARTION ( $PARTION_NAME );
select * from table_name SUBPARTION ( $SUB_PARTION_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
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:1156159920245
$ cat v1.sh
vi $(ls -ltr LONG-LOG-FILE-NAME* | tail -1 | cut -b -59)
59 값은 조정할 것
ls -ltr LOG_FILE_NAME* | tail -1 | cut -b 59- | xargs tail -f
cut -b 뒤의 숫자 59 는 알아서 조정
