노마드오브

1. 오라클 설치2. sqlplus 설치3. sqldeveloper 설치4. java jdk 설치4. font 설치 * 오라클 시작 명령어 : sudo service oracle-xe start

터미널 창 열기sqlplus 입력 엔터sys as sysdba 엔터비밀번호 입력 엔터 alter user hr account unlock;alter user hr identified by 1234;

select * from t_reg; select * from t_regwhere regexp_like(text, '[a-z]'); select * from t_regwhere regexp_like(text, '[A-Z]'); select * from t_regwhere regexp_like(text, '[a-zA-Z]'); select * from t_regwhere regexp_like(text, '[a-z] '); select * from t_regwhere regexp_like(text, '[a-z] [0-9]'); select * from t_regwhere regexp_like(text, '[[:space:]]'); select * from t_regwhere regexp_like(text, ..

-- 1. 단순뷰 -- View를 생성하기 위해서는 create view 권한이 필요-- sysdba로 접속해서-- grant create view to scott; 를 해줘야한다. -- view 생성create or replace view v_emp1asselect empno, ename, hiredatefrom emp; -- view에 index 생성 불가create index idx_v_emp_enameon v_emp1(ename); -- 테이블 생성create table o_table (a number, b number); -- view view1 생성create view view1asselect a, bfrom o_table; -- insertinsert into view1 values (1, ..

-- resource_limit = truealter system set resource_limit = true; -- password profile 생성create profile prof_passwd limitfailed_login_attempts 5password_lock_time 30password_life_time 30password_reuse_time 30; -- resource profile 생성create profile prof_resource limitcpu_per_session 1500connect_time 480idle_time 15; --------------------- -- scott가 적용 받고 있는 Profile 확인select username, profilefrom dba_u..