How to create Table a table in oracle or MSSQL or SQLServer.

How to create Table a table in oracle or MSSQL or SQLServer. 

 CREATE TABLE students (

  id INTEGER PRIMARY KEY,

  dept TEXT NOT NULL,

  salary TEXT NOT NULL

);

-- insert some values

INSERT INTO students VALUES (1, 'cse', 3000);

INSERT INTO students VALUES (2, 'ece', 2000);

INSERT INTO students VALUES (3, 'ece', 1000);

INSERT INTO students VALUES (4, 'cse', 3000);

INSERT INTO students VALUES (5, 'ece', 4000);

INSERT INTO students VALUES (6, 'cse', 4000);

Select * from students;

Comments