Is this possible to do.
I.e.
CREATE OR REPLACE VIEW VW_TEST(USERNAME "USERID")
AS
SELECT USERNAME
FROM TEST_USERS;
I know the above doesn't work, but I was wondering if it is possible to use alias for column names in a view? I havent located anything on Metalink, I was wondering if anyone has tried or succesfully create a view doing this.
Cheers,