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)

Oracle Syntax

ATTR[IBUTE] [type_name.attribute_name [option ...]]

Snowflake does not have a direct equivalent to this command.

1. Attribute command

Oracle

Command

ATTRIBUTE Address.street_address FORMAT A10

SnowSQL (CLI Client)

Command

-- ** 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.