Create new table plsql

CREATE TABLE customers
( customer_id number(10) NOT NULL,
  customer_name varchar2(50) NOT NULL,
  city varchar2(50)
);

Source: techonthenet.com

Create new table plsql

CREATE TABLE table_name
( 
  column1 datatype [ NULL | NOT NULL ],
  column2 datatype [ NULL | NOT NULL ],
  ...
  column_n datatype [ NULL | NOT NULL ]
);

Source: techonthenet.com

Similar codes

0 vote99 views2 answers
Homebrew nysql launch
SQL
0 vote96 views1 answer
Sql sum if
SQL
1 vote107 views3 answers
Mysql Server Start
SQL
10 votes120 views2 answers
Select nextval from sequence oracle
SQL
0 vote106 views1 answer
Oracle shrink table
SQL
2 votes92 views1 answer
Can you use a where clause for a child query
SQL
2 votes116 views1 answer
Merge firstname and lastname in sql oracle
SQL
2 votes95 views1 answer
Sqlplus clear screen
SQL
2 votes135 views1 answer
Search query in mysql
SQL
4 votes102 views2 answers
Insert current date in mysql
SQL