2014. 4. 25. 13:36
SELECT A.TABLE_NAME, B.COLUMN_NAME, A.CONSTRAINT_NAME, A.CONSTRAINT_TYPE, A.SEARCH_CONDITION
FROM USER_CONSTRAINTS A, USER_CONS_COLUMNS B
WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND A.TABLE_NAME = '테이블명'
AND A.CONSTRAINT_TYPE = 'P';

 

Posted by Thread
2014. 4. 24. 17:29

function addSelectBoxOption(oSelect, value, text){
 var oOption = document.createElement("OPTION");
 oOption.value = value;
 oOption.text = text;
 oSelect.options.add(oOption);
}

function addSelectBoxFirstOption(oSelect, value, text){
 var oOption = document.createElement("OPTION");
 oOption.value = value;
 oOption.text = text;
 oSelect.options.add(oOption, 0);

}

 

 

Posted by Thread
2014. 4. 23. 15:19

SQL> SELECT
       TO_CHAR(SYSDATE, 'yyyyMMddhh24miss) 현재시간,
       TO_CHAR(SYSDATE+1, 'yyyyMMddhh24miss') 1일,   
       TO_CHAR(SYSDATE+1/24, 'yyyyMMddhh24miss') 1시간,
       TO_CHAR(SYSDATE+1/24/60, 'yyyyMMddhh24miss') 1분,
       TO_CHAR(SYSDATE+1/24/60/60, 'yyyyMMddhh24miss') 1초
   FROM DUAL;

 

 

'Programing > Oracle DataBase' 카테고리의 다른 글

백업테이블 생성으로 테이블(데이터) 백업 방법  (0) 2014.12.04
Oracle 테이블 PK 조회  (0) 2014.04.25
User 권한 풀기  (0) 2013.12.26
Posted by Thread