실습문제_1B-1.pdf

select *from tabs;

실습문제_1B-2.pdf

DESC PROFESSOR;

실습문제_1B-3.pdf

SELECT * FROM PROFESSOR;

실습문제_1B-4.pdf

SELECT NAME,ID,EMAIL FROM PROFESSOR

실습문제_1B-5.pdf

SELECT DISTINCT DEPTNO FROM PROFESSOR;

실습문제_1B-6.pdf

SELECT 
	profno AS "교수번호" 
	, name, position "위치"
	, hpage  "홈페이지" 
FROM PROFESSOR;

실습문제_1B-7.pdf