Create table oracle

CREATE TABLE ot.persons(
    person_id NUMBER GENERATED BY DEFAULT AS IDENTITY,
    first_name VARCHAR2(50) NOT NULL,
    last_name VARCHAR2(50) NOT NULL,
    PRIMARY KEY(person_id)
);

Similar codes

5 votes127 views1 answer
Sql integer to serial
SQL
2 votes123 views1 answer
Oracle apex list connected users
SQL
0 vote139 views1 answer
Sql query use select name inside where clause
SQL
0 vote114 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote128 views1 answer
Generate sequence number in sql server
SQL
11 votes125 views1 answer
Mysql text type max length
SQL
0 vote174 views1 answer
Parent and child link in mysql
SQL
0 vote130 views1 answer
Show all mongodb
SQL
0 vote116 views1 answer
Mysql use password error
SQL
4 votes161 views6 answers
Select sql
SQL