Attribute
Transformation for this command is pending
Description
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.
1. Attribute command
Oracle
ATTRIBUTE Address.street_address FORMAT A10
SnowSQL (CLI Client)
-- ** 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.
Known Issues
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.
Related EWIs
No related EWIs.
Last updated