Attribute
Last updated
Last updated
Transformation for this command is pending
The
ATTRIBUTE
command specifies display characteristics for a given attribute of an Object Type column. (Oracle SQL Plus User's Guide and Reference)
ATTR[IBUTE] [type_name.attribute_name [option ...]]
Snowflake does not have a direct equivalent to this command.
ATTRIBUTE Address.street_address FORMAT A10
-- ** MSC-WARNING - MSCEWI3... - ATTRIBUTE SQL*PLUS COMMAND IS NOT CURRENTLY SUPPORTED BY SNOWFLAKE. **
--ATTRIBUTE Address.street_address FORMAT A10
The code for the EWI is not defined yet.
1. SnowSQL can set the format of a column
Currently, SnowSQL does not support custom types nor does it have a command to format columns. However, you can use the following workaround to format columns in your query result:
SELECT SUBSTR(street_address, 1, 4) FROM person
SELECT TO_VARCHAR(1000.89, '$9,999.99')
SELECT to_varchar('03-Feb-2023'::DATE, 'yyyy.mm.dd');
This alternative solution must consider an additional strategy to disable when in Oracle the ATTRIBUTE
command receives the OFF option.
No related EWIs.