Could someone confirm or answer whether Oracle 9i has the following
features?
- Can we define several user function (CREATE FUNCTION) that have the
same name but with different signature (for example, REVERSE(varchar)
and REVERSE(blob))?
- computed field/column is not supported, use VIEW for that purpose;
- Can columns on a VIEW be indexed?
- Only READ COMMITTED and SERIALIZABLE transaction isolation level are
supported; READ UNCOMMITTED and REPEATABLE READ are not.
- Can a unique index accept multiple NULLs?
- Maximum number of indexes per table?
- An index can be defined on RAW (but not LONG or LONG RAW) columns.
Received on Sat Feb 07 2004 - 02:39:22 CST
