Hi,
Can any one help me to find out Oracle equivalent query
of this sql query

if not exists (Select * from Syscolumns where id = object_id(N'[UM_MAILINGEVENTS]') and name = 'fScheduleType')
ALTER TABLE UM_MAILINGEVENTS ADD [fScheduleType] [int] DEFAULT 0 NOT NULL