반응형
create table emp01(
empno number(4),
ename varchar2(20),
sal number(7,2));
desc emp01;
create table dept01(
deptno number(2),
dname varchar2(14),
loc varchar2(13));
create table emp02
as select * from emp;
select * from emp02;
create table dept02
as select * from dept where 2>3;
select * from dept02;
select table_name
from user_tables;
insert into dapt02(DEPTNO,DNAME,LOC)
values (dd,aa,qq);
'데이터베이스' 카테고리의 다른 글
MYbatis fetchSize 설정 (0) | 2019.07.09 |
---|---|
[SQLyog] sql 요그 툴 단축키 (0) | 2019.05.02 |
DB2 (0) | 2016.06.22 |
DB2 기본 명령어 (0) | 2016.06.22 |
Oracle select 문제풀이 (0) | 2014.11.18 |