반응형

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

+ Recent posts