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

2 votes135 views1 answer
Sql server case sensitive search
SQL
0 vote142 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
1 vote138 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
10 votes140 views3 answers
Insert into auto increment mysql
SQL
1 vote221 views1 answer
Aqua Data studio postgresql ssl
SQL
1 vote155 views1 answer
Mysql update inner
SQL
0 vote142 views1 answer
Oracle get running queries
SQL
0 vote151 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
14 votes137 views1 answer
Excel
SQL
1 vote155 views2 answers
Sql queries practice
SQL