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 vote337 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote328 views1 answer
Get week day name sql server
SQL
0 vote351 views1 answer
If column value is null then in mysql
SQL
0 vote386 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote298 views1 answer
CREATE MULTIPLE FK
SQL
3 votes340 views2 answers
Brew restart mysql
SQL
0 vote326 views1 answer
Dns slave zone convert
SQL
0 vote339 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote369 views1 answer
Spark sql grows beyond 64 kb
SQL
8 votes320 views1 answer
Sql remove characters from string right
SQL