Common Column

SELECT * FROM USER

_TAB_COLUMNS WHERE COLUMN_NAME=<COLUMN_NAME>

Sequence Creation

-- Create sequence
create sequence SQ_SOH_BONANZA_DETAILS
minvalue 1
maxvalue 999999999999999999999999999
increment by 1;