-- create a table
CREATE TABLE DOCTOR
(
  DNO INTEGER PRIMARY KEY,
  DNAME VARCHAR (20),
  SPECIALIZATION VARCHAR (20),
  QUALIFICATION CHAR (15)
);
-- insert some values
INSERT INTO DOCTOR VALUES ("5","SURAJ","CARDIOLOGY","MBBS");
INSERT INTO DOCTOR VALUES ("10","NEHA","DERMATOLOGY","UG");
INSERT INTO DOCTOR VALUES ("8","ROSHANI","PSYCHIATRIST","PG");
INSERT INTO DOCTOR VALUES ("3","RAJKUMAR","CARDIOLOGY","UG");
-- fetch some values
SELECT * FROM DOCTOR ;