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

1 vote252 views1 answer
How to truncate a table in databse
SQL
0 vote497 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote259 views1 answer
Mysql foreach insert
SQL
0 vote252 views1 answer
Show create table in postgresql
SQL
1 vote279 views1 answer
Spark sql convert string to date
SQL
1 vote259 views1 answer
Create table tablename as select * from tablename
SQL
0 vote268 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote274 views1 answer
Get initials name in sql
SQL
2 votes268 views1 answer
Sql percentage with % rounded down
SQL
0 vote267 views1 answer
Sql get count without group by
SQL