create table users(aid number primary key, name varchar(20), age number, houseno varchar(5), street varchar(20), city varchar(20), pin number, uname varchar(20) not null unique, password varchar(20) ...

CHANGE COLUMN company_name company_name VARCHAR(255) NOT NULL; ...