언어/Database
-
서브쿼리 예제언어/Database 2020. 5. 12. 11:57
select s.member_id,s.name from member s, dept t where s.dept_id= t.dept_id and dept_name='총무부'; select member_id,name from member where dept_id= (select dept_id from dept where dept_name='총무부'); select member_id,name from member where dept_id in(10,20,30); select dept_id from dept where dept_name in('총무부','영업부'); select member_id,name from member where dept_id in (select dept_id from dept where ..
-
데이터 가지고놀기 & 서브쿼리언어/Database 2020. 5. 11. 16:53
create table emp4 ( no number(3,1), name varchar2(10) default 'no value' ) select * from emp4; insert into emp4(no, name) values(1, 'test'); insert into emp4(no) values(2); create table emp5 ( no number(3,1), name varchar2(10) not null ) select * from emp5; insert into emp5(no, name) values(1, 'test'); insert into emp5(no) values(2); select * from emp5; create table emp6 as select * from emp5; c..
-
조인 예제언어/Database 2020. 5. 11. 15:16
select * from po_employeer; select * from po_order_header; select * from po_employeer s , po_order_header t where s.emp_no=t.ord_emp; select s.emp_name, t.ord_no,t.ord_date,t.sup_no,u.sup_name from po_employeer s , po_order_header t ,po_supplier u where s.emp_no=t.ord_emp and t.sup_no=u.sup_no order by s.emp_no asc; select s.emp_name, t.ord_no,t.ord_date,t.sup_no,u.sup_name from po_employeer s i..
-
조인연습언어/Database 2020. 5. 8. 17:27
select * from dept; select * from member; SELECT dept.dept_name,member.name FROM DEPT,MEMBER where dept.dept_id=member.dept_id; select t.dept_name ,s.name from member s, dept t where s.dept_id=t.dept_id; --ansi select t.dept_name ,s.name from member s inner join dept t on s.dept_id=t.dept_id; --outer join select s.dept_name,t.name from dept s left outer join member t on s.dept_id=t.dept_id; --ri..
-
조인언어/Database 2020. 5. 8. 15:32
select * from dept; select * from member; SELECT dept.dept_name,member.name FROM DEPT,MEMBER where dept.dept_id=member.dept_id; select t.dept_name ,s.name from member s, dept t where s.dept_id=t.dept_id; --ansi select t.dept_name ,s.name from member s inner join dept t on s.dept_id=t.dept_id; --outer join select s.dept_name,t.name from dept s left outer join member t on s.dept_id=t.dept_id; --ri..
-
-
구문연습-2 update언어/Database 2020. 5. 8. 14:30
DROP TABLE grade; DROP TABLE member; DROP TABLE dept; CREATE TABLE dept ( dept_id NUMBER(4) , dept_name VARCHAR2(30) , loc_id NUMBER(4) ,CONSTRAINT deptid_pk PRIMARY KEY (dept_id)); CREATE TABLE member ( member_id NUMBER(6) , name VARCHAR2(25) NOT NULL , hire DATE , jikwi VARCHAR2(10) , sal NUMBER(8,2) , bonus NUMBER(5) , mgr NUMBER(6) , dept_id NUMBER(4) ,CONSTRAINT member_member_id_pk PRIMARY ..
-
구문연습-2언어/Database 2020. 5. 7. 17:34
DROP TABLE grade; DROP TABLE member; DROP TABLE dept; CREATE TABLE dept ( dept_id NUMBER(4) , dept_name VARCHAR2(30) , loc_id NUMBER(4) ,CONSTRAINT deptid_pk PRIMARY KEY (dept_id)); CREATE TABLE member ( member_id NUMBER(6) , name VARCHAR2(25) NOT NULL , hire DATE , jikwi VARCHAR2(10) , sal NUMBER(8,2) , bonus NUMBER(5) , mgr NUMBER(6) , dept_id NUMBER(4) ,CONSTRAINT member_member_id_pk PRIMARY ..