여우의 IT

Oracle DB Link Command create database link UserDB connect to user2 identified by pwd00 using '(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=000.000.000.000)(PORT=1521))(CONNECT_DATA=(SERVER=DEDCATED)(SERVICE_NAME=orcl)))';

Create Table Space CREATE TABLESPACE TABLESPACENAME LOGGING DATAFILE 'DIRECTORY' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ; Delete Table Space ALTER TABLESPACE TABLESPACENAME OFFLINE; DROP TABLESPACE TABLESPACENAME INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;

Login : root 1. For Unix :: root #] su - oracle oracle #]exp userid=scott/tiger file=/disk1/backup.dmp For Window :: >exp userid=id/pass@hostname file=Location.dmp 2. For Window :: >imp id/pass file=Location.dmp full=y

오라클 쿼리 팁 ◆ DB에 있는 모든 Table 이름보기 select table_name from user_tables ◆ Table의 Primary Key 찾기 select * from user_ind_columns where table_name = ''CodeTable'' ◆ 인수전달 select * from user_ind_columns where table_name = ''&1'' ===>; save key SQL> start key CodeTable ◆ 서로 연결되는 Key를 찾는 방법 select constraint_name, constraint_type, r_constraint_name from user_constraints where table_name = ''TABLE_NAME ◆ TAB..

CREATE TABLE EMPEX ( EMPNONUMBER(4)NOT NULL, ENAMEVARCHAR2(10), JOBVARCHAR2(9), MGRNUMBER(4), HIREDATEDATE, SALNUMBER(7,2), COMMNUMBER(7,2), DEPTNONUMBER(2), PRIMARY KEY(EMPNO) ) ; COMMENT ON TABLE EMPEX IS '사원테이블' COMMENT ON COLUMN EMPEX.EMPNO IS '사원번호' COMMENT ON COLUMN EMPEX.ENAME IS '사원이름' COMMENT ON COLUMN EMPEX.JOB IS '업무' COMMENT ON COLUMN EMPEX.MGR IS '직속상관' COMMENT ON COLUMN EMPEX.HIRED..

-- 질의 탐색을 위해 사용될 둘이상의 표현식을 지정 select prod_name 상품, prod_sale 판매가 from prod where prod_sale in (150000, 170000, 330000); --범위내의 모든 값을 탐색 select prod_name 상품, prod_sale 판매가 from prod where prod_sale between 100000 and 300000; -- 두 문자열을 연결하여 반환 select concat('My Name is', mem_name) from member; -- 대소문자 구분 lower(소문자), upper(대문자), initcap(첫글자만대문자) select lower('DATA manipulation Language') "lower", u..

ORACLE SQL Injection Notes In ORACLE you can not just SELECT stuff you have to SELECT them from some table. For this purpose you can use special table called DUAL. i.e. SELECT 'dummydata' || 'x' FROM DUAL; You have to close comments if you used /* comment */ style comments Concatenation SELECT utl_raw.concat('x','y') FROM DUAL; SELECT 'x' || 'y' FROM DUAL; SELECT 'a' || 'b' FROM DUAL; SELECT use..