GS_SPM_SQL_PARAM
GS_SPM_SQL_PARAM is used to view the SQL parameter information of the current user. Users with permissions higher than common users can access this view.
Name |
Type |
Description |
---|---|---|
sql_namespace |
oid |
OID of a schema. |
sql_hash |
bigint |
Unique ID of an SQL statement in the current schema. |
sql_text |
text |
SQL text string. |
position |
integer |
Position index of a parameter in the SQL statement, starting from 0. |
datatype |
integer |
OID of the parameter type. |
datatype_string |
text |
Character string of a parameter type. |
value_string |
text |
Character string of a parameter value. |
is_null |
Boolean |
Specifies whether a parameter value is NULL. |
hash_value |
bigint |
Hash value of a parameter value. |
creation_time |
timestamp with time zone |
Time when a record is created. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot