목록DB/Oracle (88)

develog

인덱스 재생성

ALTER INDEX 인덱스명 REBUILD;
DB/Oracle 2014. 6. 17. 11:05
Oracle Locks

Automatic Locks in DML Operationshttp://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_locks001.htm Data Concurrency and Consistencyhttp://docs.oracle.com/cd/B13789_01/server.101/b10743/consist.htm 트랜잭션 수준 읽기 일관성http://wiki.gurubee.net/pages/viewpage.action?pageId=3900389
DB/Oracle 2014. 5. 14. 18:39
ORA-32035: unreferenced query name defined in WITH clause

with 절에 선언하고 사용하지 않을 때 발생 ex) BB 가상테이블 사용하지 않음WITH AA AS( SELECT '11' COL_NM FROM DUAL UNION ALL SELECT '22' COL_NM FROM DUAL UNION ALL SELECT '33' COL_NM FROM DUAL), BB AS( SELECT '44' COL_NM FROM DUAL UNION ALL SELECT '55' COL_NM FROM DUAL) SELECT * FROM AA;
DB/Oracle 2014. 2. 26. 18:50
oracle, sql, with

WITH AA AS( SELECT '11' COL_NM FROM DUAL UNION ALL SELECT '22' COL_NM FROM DUAL UNION ALL SELECT '33' COL_NM FROM DUAL), BB AS( SELECT '44' COL_NM FROM DUAL UNION ALL SELECT '55' COL_NM FROM DUAL) SELECT * FROM AAUNION ALLSELECT * FROM BB;
DB/Oracle 2014. 2. 26. 18:43
SELECT 랜덤하게

SELECT *FROM ( SELECT 'DD' COL FROM DUAL UNION ALL SELECT 'BB' COL FROM DUAL UNION ALL SELECT 'CC' COL FROM DUAL UNION ALL SELECT 'AA' COL FROM DUAL)ORDER BY DBMS_RANDOM.VALUE;
DB/Oracle 2014. 1. 22. 21:04
Tora (Client Tool)

▶ Tora 웹사이트http://torasql.com/ ▶ Tora 다운로드http://sourceforge.net/projects/tora/files/tora/2.1.3/windows/tora2.1.3-win32.zip ▶ oci.dll 파일명 변경※ 다운로드 받은 파일 압축풀고 oci.dll -> oci.dll.old※ Oracle Client 의 oci.dll 파일을 사용하도록 변경 ▶ 환경변수 설정%ORACLE_HOME% = D:\oracle\product\10.2.0\client_1%TNS_ADMIN% = %ORACLE_HOME%\NETWORK\ADMIN ▶ 접속시 옵션 설정Connection provider : Oracle (TNS)Options : SQL*Net ※ Oracle Client ..
DB/Oracle 2013. 8. 30. 15:47
Prev 1 ··· 7 8 9 10 11 12 13 ··· 15 Next