all,
the exmaples I have seen for FBIs are mostly of type

CREATE INDEX area_index ON rivers (area(geo));

but what if I have an expression like below?
mine is failing..
SQL> create index fb_idx_test on MONAGA (SMCID(<>0));
create index fb_idx_test on MANAGA (SMCID(<>0))

ERROR at line 1:
ORA-00936: missing expression

this is for a query that ends thus
where SMCID <> 0; => need to add the FBI here.
thanks