我希望能够添加多行的表格/列注释。
通常情况下,这是这样使用的:
COMMENT ON TABLE USERS IS 'User table has the user data'
我需要的是一种方法,在单引号内插入换行符,就像这样;
COMMENT ON TABLE USERS IS 'User table has the user data <smthg_here_for_new_line> 1- Name column has name <smthg_here_for_new_line> 2- Number Column has the id'
这样表格评论将会显示为:
User table has the user data
1- Name column has name
2- Number Column has the id
有人知道如何添加多行表/列注释吗?
COMMENT ON TABLE USER IS 'User table comment1 here' || chr(10) || '1- User table subcomment here' Error at line 1 ORA-00933: SQL command not properly ended
- Levent Divilioglu