|
-
 Originally Posted by prodadmin
column1 is a datatype number
Not after you've wrapped in in SubStr() it isn't, even if it is stored as a number in the database. Run DESCRIBE on the table to see what it really is, and if you want to use a numberic format on that column either embed it in a to_char() or leave it alone and use COLUMN to format it. My preference would be the latter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote