oracle declare table code example
Example 1: 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)
);
Example 2: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)