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

4 votes374 views2 answers
Postgresql float data type
SQL
0 vote321 views2 answers
Sql server select first day of previous year
SQL
0 vote405 views1 answer
Oracle simple quote
SQL
0 vote344 views1 answer
Supprimer les valeur d'une table mysql
SQL
23 votes342 views3 answers
Sql where contains part of string
SQL
1 vote311 views1 answer
Sql delete all values in a column
SQL
2 votes342 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
5 votes306 views3 answers
Truncate function in sql oracle
SQL
0 vote335 views3 answers
Select random sql
SQL
1 vote341 views1 answer
Mysql list bigger table
SQL