create table student(
id int,
name varchar(20)
);
insert into student values(12345,'홍길동');
select * from student;
commit; -- rollback 취소
delete from student;
select * from student;
rollback;
select * from student;
drop table student;
create table student(
id int not null,
name varchar2(50) not null,
department varchar2(100) not null,
address varchar2(200) not null
);
select * from student;
insert into student values(12345,'홍길동','컴퓨터공학과','서울시 영등포구');
commit;
create table board(
bno number primary key,
title varchar2(50) not null,
content varchar2(1000) not null,
writer varchar2(50) not null,
wDate date not null,
readCount number not null
);
insert into board values(1,'sql이 뭐죠?','sql은 RDB에서 쓰는 언어입니다','홍길동',sysdate,0);
select * from board;
insert into board values(2,'oracle이 뭐죠?','oracle은 rdb입니다.','이순신',sysdate,0);
