Creating view with colum alias
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Creating view with colum alias

  1. #1
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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,
    OCP 8i, 9i DBA
    Brisbane Australia

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Ahh, don't worry, I worked it out.

    CREATE OR REPLACE VIEW VW_TEST(USERID)
    AS
    SELECT USERNAME
    FROM TEST_USERS;
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width