The advantage of bitmap index are greatest for low cardinality columns i.e, if the values in a column are repated more than a hundred times, the column is a candidate for a bitmap index

syntax:
CREATE BITMAP INDEX ON ();

EXAML\PLE:

CREATE BITMAP INDEX V1_INDX ON ORDERS(ORDERNO);