DAY25 - Oracle DB 연습 (2024.08.06)
·
Oracle
EditPlus로 연다. select * from tab;select * from user_sequences;desc employees;create user table sequencedrop user table sequenceselect employee_id, last_name, salary from employees; 더보기더보기더보기사원번호 "이 름" "급 여" → 공백때문에 " 이거 붙임.select employee_id as 사원번호, last_name as "이 름", salary as "급 여" from employees;select employee_id as 사원번호, last_name as "이 름", salary*12 as "급 여" from emplo..