Oracle DBMS 설치

Oracle DBMS 설치

• Oracle 11g
  https://drive.google.com/file/d/1ATMd5YZm4q0V9RUFrwThwCYrlD-RzaAw/view?usp=sharing -> password : 1234
  cmd - sqlplus - usernmae -system - password - 1234

Tool 설치

-DBeaver
create connection - oracle

hr 계정 unlock

alter user hr identified by hr account unlock;
참고 블로그 : https://velog.io/@krafftdj/Oracle-%EA%B3%84%EC%A0%95-%EC%83%9D%EC%84%B1-%EA%B6%8C%ED%95%9C-%EB%B6%80%EC%97%AC

hr 계정 pw 설정

alter user hr identified by 1234;
grant connect, resource to hr;

단축키

ctrl + shift + + = 글자 커짐

수업 준비

n/a에서 hr 선택하기
SELECT * FROM EMPLOYEES e ;