practise dbms

subhamsingh · May 15, 2023
create table emp (
empno numeric(20) primary key,
ename varchar(20) not null,
job varchar(30),
mgr numeric(5),
hiredate varchar(15),
sal numeric(6),
comm numeric(5),
deptno numeric(3)
);

insert into emp values(7369,'smith','clerk',7902,1980-12-17,800,'null',20);

select * from emp
Output

Comments

Please sign up or log in to contribute to the discussion.