SQL 01 기초

create table test(
  num number primary key,
  name varchar2(10),
  addr varchar2(10),
  gen char(1),
  rdate date
);

insert into test
values (1, '홍길동', '서울', 'm', to_date('2017-02-03', 'yyyy-mm-dd'));

insert into test
values (2, '아무개', '서울', 'm', to_date('20170101', 'yyyymmdd'));

insert into test
values (3, '매니저', '경기', 'f', sysdate);

insert into test (num, name, gen, rdate)
values (4, '노숙자', 'm', sysdate);

update test
set addr = '인천'
where num=1;

update test
set addr = '인천', gen = 'f'
where num=2;

delete
from test
where num = 4;

rollback;

select c1, c2
from t
where c = value;

insert into t(c1, c2, c3)
values(value1, value2, value3);

update t
set c1=1, c2=2
where c = value;

delete
from t
where c = value;

to_char(c, 'value') = 'value'
ex)
to_char(rdate, 'yyyy') = '2017'
where name like '%노%'

concat(c, c)

select job
from emp
group by job;

select *
from emp
where deptno=10
and job='clerk';

select ename, job
from emp
where job in ('MANAGER', 'CLERK');

select ename, hiredate
from emp
where (sysdate - hiredate)/365 >= 35;

select substr(ename, 1, 2)||**||substr(ename, 5, 2) as “Luck”
from emp;