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

17 votes136 views6 answers
Mysql import sql file
SQL
0 vote146 views1 answer
Get date from timestamp in mysql
SQL
2 votes145 views3 answers
Mysql pass command from command line
SQL
0 vote141 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
10 votes135 views1 answer
Create table oracle
SQL
0 vote154 views1 answer
Python dictionary to sql update
SQL
0 vote141 views1 answer
Querry mysql by 2 columns
SQL
0 vote139 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote145 views1 answer
Create or replace view postgress
SQL
5 votes124 views2 answers
Oracle list columns schema
SQL