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

6 votes292 views2 answers
Generate c# class from sql server table
SQL
0 vote362 views2 answers
Oracle ora-00054 how to unlock
SQL
12 votes351 views2 answers
Delete all entries postgres
SQL
1 vote340 views2 answers
Setval max id postgresql sequence
SQL
4 votes341 views1 answer
Create table if not exist in sqlite
SQL
7 votes307 views1 answer
Alter table add key sql
SQL
0 vote791 views2 answers
Zsh: command not found: mysq
SQL
0 vote325 views1 answer
Import mysql'
SQL
1 vote361 views1 answer
Sql in array query
SQL
1 vote382 views1 answer
Mysql select row max date
SQL