Create table

How to create table in sql

//to create a table
CREATE TABLE students
( student_id number(4) primary key,
  last_name varchar2(30) NOT NULL,
  course_id number(4) NULL );

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);

Create table

CREATE TABLE fact (
id SERIAL PRIMARY KEY NOT NULL,
type VARCHAR(255),
text TEXT
);

Similar codes

0 vote176 views1 answer
Mysql create table like
SQL
3 votes179 views2 answers
Postgres alter table owner
SQL
0 vote242 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote182 views1 answer
Check for directory in bash
SQL
1 vote203 views1 answer
Oracle plan hash value
SQL
0 vote172 views7 answers
Les jointures sql server
SQL
-2 votes184 views2 answers
Union all in sql
SQL
0 vote165 views2 answers
Find Overlapping sql
SQL
0 vote192 views1 answer
Mysql utc timestamp
SQL
0 vote169 views1 answer
Exclude last comma separated string mysql
SQL