indexing expressions instead of columns / clipper style indexes

From: <ssharma_at_clearnet.com>
Date: Sun, 26 Apr 1998 12:17:44 -0600
Message-ID: <6hvq7n$vb8$1@nnrp1.dejanews.com>

Hello
Is this possible directly in Oracle 7.3?

create an index based on some expression instead of on a bare column name and then when users use that exact expression, have Oracle use that index.

As I understand so far, this is impossible directly in Oracle.

If this is true, could anyone give me some idea of how I could implement this in pl/sql? Can one access / influence oracle's native indexing schemes through PL/ SQL?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun Apr 26 1998 - 13:17:44 CDT