현재 선택되어진 select box의 값 읽기 // Get selected value $("#myselectbox option:selected").val(); // Get selected text $("#myselectbox option:selected").text(); // Get selected index $("#myselectbox option").index($("#myselectbox option:selected")); Select box의 Selected 값 설정 // Set the element at index 2 to be selected $("#myselect option:eq(2)").attr("selected", "selected"); // Set the selected element ..

Guestaddition 설치C:\Program Files\InnoTek VirtualBox Guest Additions\ 경로로 이동명령 입력VBoxControl addcustommode 1680 1050 32 (1440 900 32등등)

SELECT TRUNC(EndDate - StartDate) as "일", TRUNC(((EndDate - StartDate) - TRUNC(EndDate - StartDate)) * 24) as "시간", FLOOR(((((EndDate - StartDate) -TRUNC(EndDate - StartDate)) * 24) - TRUNC(((EndDate - StartDate)-TRUNC(EndDate - StartDate)) * 24)) * 60) as "분" FROM ( SELECT TO_DATE('2013-08-07','yyyy-mm-dd') AS STARTDATE, -- 시작일 TO_DATE('2013-12-30','yyyy-mm-dd') AS ENDDATE -- 종료일 FROM DUAL );

select b.machine "hostname", b.username "username", b.osuser "OS User", b.program "Program", a.tablespace_name "TableSpace", row_wait_file# "File Number", row_wait_block# "Block Number", c.owner, c.segment_name, c.segment_type from dba_data_files a, v$session b, dba_extents c where b.row_wait_file# = a.file_id and c.file_id = row_wait_file# and row_wait_block# between c.block_id and c.block_id +..

테이블 삭제 Begin for c in (select table_name from user_tables) loop execute immediate 'drop table '||c.table_name||' cascade constraints'; end loop; End; 시퀀스 삭제 Begin for c in (SELECT * FROM all_sequences WHERE SEQUENCE_OWNER='DBUSER') loop execute immediate 'drop SEQUENCE '||c.sequence_name; end loop; End;