The Pl/SQL Syntax create table.

-- Create table
create table autocodes.
(
  codeid char(50) not null,
  bqty   number default 0 not null,
  descs  nvarchar2(30)
)
;
-- Add comments to the columns
comment on column autocodes..codeid
  is 'The identity of the code';
comment on column autocodes..bqty
  is 'The base qty of the code';
comment on column autocodes..descs
  is 'The identity''s comments';
-- Create/Recreate primary, unique and foreign key constraints
alter table autocodes.
  add constraint pk_autocodes primary key (CODEID);