Prog table

an anonymous user · September 23, 2022
-- create a table
CREATE TABLE prog (
  Name varchar(20) NOT NULL,
  DOB DATE NOT NULL,
  DOJ DATE NOT NULL, 
  SEX varchar(20) NOT NULL, 
  PROF1 varchar(30),
  PROF2 varchar(40),
  SALARY Number(4) NOT NULL
);
-- insert some values
INSERT INTO prog VALUES ('Ryan','03-JUN-1995','02-SEP-2022','M','pascal','basic', '3200');
INSERT INTO prog VALUES ('Joanna', '03-SEP-2000','03-SEP-2022','f','java','python','7400');
-- fetch some values
SELECT * FROM prog;
Output
(Run the program to view its output)

Comments

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