EXPT1.md

1. Create table

CREATE TABLE emp (
    empno NUMBER,
    empname VARCHAR2(255), 
    DOB DATE,
    salary NUMBER, 
    designation VARCHAR2(20)
);

2. Insert values

INSERT INTO emp VALUES(100,'John','4.21.1994', 50000,'Manager');

INSERT INTO emp VALUES(101,'Greg','6.20.1994',25000,'Clerk');

3. Display values

SELECT * FROM emp;

SELECT empname,salary FROM emp;