creaet a table in sql code example
Example 1: how to create table in sql
CREATE TABLE students
( student_id number(4) primary key,
last_name varchar2(30) NOT NULL,
course_id number(4) NULL );
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);
Example 2: creating a table in sql
CREATE TABLE students
( student_id number(4) primary key,
last_name varchar2(30) NOT NULL,
course_id number(4) NULL );
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);