change column type on select
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: change column type on select

  1. #1
    Join Date
    Dec 2003
    Posts
    90

    change column type on select

    Is it possible to change the type of the column in a select?

    ex:
    select count(*) a
    from table

    the type for column a is system.decimal, I want it as a Number(9) is that possible?

  2. #2
    Join Date
    Mar 2004
    Posts
    3
    Try using SQL PLUS command to preformat the column types. And you can change the name of the columns by using alias names in the select statement.

    Hope it helps.

  3. #3
    Join Date
    Aug 2000
    Location
    Ny
    Posts
    105
    SELECT TO_NUMBER(TO_CHAR(COUNT(*), '999999999'))
    FROM DUAL;

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