select ename as 이름 , sal as 월급
from emp;
설명: as는 생략 가능합니다.
문제1. 사원이름, 직업과 월급을 출력하는데 모두 다 컬럼명을 한글로 출력하시오
select ename 사업이름, job 직업, sal 월급 (as) 생략
from emp;
설명: 컬럼별칭을 사용할때 더블 쿼테이션 마크를 사용해야할 때!
예: select empno as “Emplyee Number”, ename as “Employee Name”
from emp;
※오라클 전테를 통틀어서 더블 쿼테이션 마크를 사용하는 때는 이 경우 밖에 없습니다.
나머지는 모두 싱글 쿼테이션 마크 사용입니다.
■ 우리반 테이블 생성 스크립트
drop table emp19;
create table emp19 ( empno number(10), ename varchar2(20), age number(10), birth date, telecom varchar2(10), major varchar2(50), email varchar2(60), address varchar2(100) ) ;
INSERT into emp19(empno, ename, age, birth, telecom, major, email, address) values(5, '신지혜', 28, to_date('1996/04/17', 'RRRR/MM/DD'), 'SKT', '소비자학', '[email protected]', '서울시 강서구 등촌1동');
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) VALUES (6, '박보은', 25, to_date('1999/01/05', 'YYYY/MM/DD'), 'kt', '컴퓨터학', '[email protected]', '경기도 광주시 초월읍');
INSERT INTO emp19(empno,ename,age,birth,telecom,major,email,address) values( 14, '노승욱', 26, to_date('1999/10/19','YYYY/MM/DD'),'sk','수학과','[email protected]','성남시 중원구 성남동');
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) Values(3,'박두연',28,to_date('1996/01/18','YYYY/MM/DD'),'sk','간호학과','[email protected]','서울시 동작구 상도동');
insert into emp19(empno, ename, age, birth, telecom, major, email, address) values(12, '윤지윤', 28, to_date('1996/02/29','YYYY/MM/DD'), 'skt', '디자인과' ,'[email protected]', '서울시 강서구 염창동' );
insert into emp19 (empno,ename,age,birth,telecom,major,email,address) values(29, '문혜선', '25',to_date('1999/04/16','YYYY/MM/DD'),'sk','정보통신공학과','[email protected]','경기도 화성시 능동' );
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) VALUES(19, '안민영', 29,to_date('1995/01/19','YYYY/MM/DD'), 'lg', '영어교육', '[email protected]','서울시 광진구 중곡동');
insert into emp19(empno, ename, age, birth, telecom, major, email, address) values(28, '김진경', 31, to_date('1993/03/23','yyyy/mm/dd'), 'kt', '분자생명공학', '[email protected]', '경기도 용인시 수지구' );
INSERT INTO emp19(empno,ename,age,birth,telecom,major,email,address) values( 25, '유동현', 26, to_date('1998/05/18','YYYY/MM/DD'),'sk','의료공학','[email protected]','서울시 광진구 구의동');
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values( 27, '황지영', 30, to_date('1994/09/10','YYYY/MM/DD'), 'sk', '외식산업', '[email protected]', '경기도 용인시 수지구' );
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) VALUES(2, '한지희', 28, to_date('1995/07/07', 'YYYY/MM/DD'), 'sk', '통계데이터', '[email protected]', '경기도 남양주시 화도읍');
INSERT INTO emp19(empno,ename,age,birth,telecom,major,email,address) values(11,'유재현',32,to_date('1992/02/03','YYYY/MM/DD'),'lg알뜰','한문학','[email protected]','서울시 강남구 개포4동');
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values(9,'이현서', 25, to_date('2000/01/06','YYYY/MM/DD'), 'KT', 'AI전공', '[email protected]', '경기도 남양주시 별내동');
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values( 30, '서동현', 28, to_date('1996/01/13','YYYY/MM/DD'), 'kt', '무역물류학과', '[email protected]', '서울시 송파구 송파동' );
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values( 7, '조혜정', 29, to_date('1995/12/10','YYYY/MM/DD'), 'lg', '재활과학', '[email protected]', '서울시 송파구 삼전동' );
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values( 4, '이승원', 26, to_date('1998/04/24','YYYY/MM/DD'), 'sk', '건축', '[email protected]', '용인시 처인구 고림동' );
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) VALUES (8, '이혜인', 28, to_date('1998/01/20','YYYY/MM/DD'), 'SKT', '아동보육', '[email protected]', '성남시 분당구 백현동');
INSERT INTO emp19 (empno,ename,age,birth,telecom,major,email,address) values(15,'김준희',26,to_date('1999/12/12','YYYY/MM/DD'),'sk','통계학과','[email protected]','성남시 중원구 성남동');
insert into emp19 (empno, ename, age, birth, telecom, major, email, address) values (13, '김연우', 24, to_date('2000/07/18','YYYY/MM/DD'), 'kt', '문헌/빅데이터','[email protected]', '성남시 분당구 서현동');
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) values(1, '심지민', 27, to_date('1997/06/28', 'YYYY/MM/DD'), 'sk', '일본학', '[email protected]', '서울시 송파구 장지동');
insert into emp19 (empno, ename, age, birth, telecom, major, email, address) values (26, '이원석', 31, to_date('1993/01/11','YYYY/MM/DD'), 'SKT', '관광', '[email protected]', '성남시 분당구 운중동');
iNSERT INTO emp19 (empno, ename, age, birth, telecom, major, email, address) values(16, '박찬혁', 27, to_date('1997/09/08','YYYY/MM/DD'), 'lg','컴공', '[email protected]', '서울시 강남구 역삼동');
INSERT INTO emp19(empno,ename,age,birth,telecom,major,email,address) values(10,'석승연',25,to_date('2000/02/16','yyyy/mm/dd'),'lg','기계공학', '[email protected]','서울시 강남구 역삼동');
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) values(18, '이동근', 33, to_date('1991/06/06','YYYY/MM/DD'), 'LG', '시각디자인', '[email protected]', '서울시 강서구 염창동');
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values(20, '한수연', 28, to_date('1996/02/04','YYYY/MM/DD'), 'lg', '정보사회학', '[email protected]', '서울시 동작구 신대방동' );
INSERT INTO emp19(empno, ename, age, birth, telecom, major, email, address) values(17, '김서준', 27, to_date('1997/02/05', 'YYYY/MM/DD'), 'kt', '국제통상', '[email protected]', '서울시 동작구 상도동');
INSERT INTO emp19(empno,ename,age,birth,telecom,major,email,address) values(24, '경진우',27,to_date('1998/11/03','YYYY/MM/DD'),'lg','기계공학','[email protected]','경기도 평택시 이충동' );
insert into emp19(empno,ename,age,birth,telecom,major,email,address) values(21, '손주용', 26, to_date('1998/07/06','YYYY/MM/DD'), 'kt', '경영', '[email protected]', '안양시 동안구 달안동' );
insert into emp19 (empno, ename, age, birth, telecom, major, email, address) values (23, '성연우', 38, to_date('1985/01/11','YYYY/MM/DD'), 'SKT', '화학', '[email protected]', '서울시 서초구 방배동');
INSERT INTO emp19(empno,ename,age,birth,telecom,major,email,address) values(22, '박진우',28,to_date('1996/08/22','YYYY/MM/DD'),'skt','경영학','[email protected]','서울시 종로구 창신동');
commit;
select * from emp19 order by empno asc;
오늘의 마지막 문제 우리반 테이블에서 학생이름, 나이 전공을 출력하는데, 컬럼명을 한글로 출력하시오!
select ename 학생이름, age 나이, major 전공 from emp19;