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
Post a Comment