GS dbms

/*
create table emp(e_no int,e_name varchar2(20),addr varchar2(20));
create table dept(d_no varchar2(10),d_name varchar2(20),e_no int);
insert into  emp values(1,'Ram','Delhi');
insert into  emp values(2,'Varun','chd');
insert into  emp values(3,'Ravi','Chd');
insert into  emp values(4,'Amrit','Delhi');


insert into  dept values('D1','HR',1);
insert into  dept values('D2','IT',2);
insert into  dept values('D3','MRKT',4);
*/

-- select e_name from emp natural join dept;



ALTER TABLE dept ADD  location varchar2(20);



DESC dept;