:절차적 질의 언어
alter user scott identified by tiger
conn scott/tiger
show user;
set line 200
desc(describe)
select empno,ename from emp;
select ename,'good morning~' from emp;
select ename,'good morning~' "Good Morning" from emp;
select ename,'good morning~' as "Good Morning" from emp;
// 큰 따옴표 생략 불가
select dname,DNAME from dept;
컬럼명, 테이블은 대소문자 구분 안함
select dname, 'its deptno' ,deptno from dept;
select dname, 'it's deptno' ,deptno from dept; //오류
select dname, 'it''s deptno' ,deptno from dept;
select distinct deptno from emp;
select job,ename || job from emp;
select ename||'('||job||')'||' , '||ename||''''||job||'''' AS "NAME AND JOB" from emp;
select ename||''''||'s sal is $'||sal "Name and Sal" from emp;
select * from tab;
desc student;
select * from student;
select studno,name,id from student;
select distinct deptno1 from student;
select name as "이름", birthday as "생일", height as "키(cm)", weight as "몸무게(kg)" from student;
select name||' 학생의 키는 '||height||'(cm)이고, 몸무게는'||weight||'(kg)이다.' from student;
select empno,ename from emp where empno=7900;
