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,