正常:comment on column CRM_CUSTOMER.ACCOUNTNO is '编码';
目前:select 'comment on column '||upper(tablename)||'.'||upper(columnname)||' is '||(说明字段)||';'
from sys_tabcolumns where tablename='Crm_Customer'(此SQL是错误的,说明字段前后少了“‘”标识符)
求:说明字段表示一个字段的时候,查询之后出现 comment on column CRM_CUSTOMER.ACCOUNTNO is '具体说明字段内容';
就是出现两个红色的‘'’,目前那个sql出来是没有这连个标识符的
目前:select 'comment on column '||upper(tablename)||'.'||upper(columnname)||' is '||(说明字段)||';'
from sys_tabcolumns where tablename='Crm_Customer'(此SQL是错误的,说明字段前后少了“‘”标识符)
求:说明字段表示一个字段的时候,查询之后出现 comment on column CRM_CUSTOMER.ACCOUNTNO is '具体说明字段内容';
就是出现两个红色的‘'’,目前那个sql出来是没有这连个标识符的
目前:select 'comment on column '||upper(tablename)||'.'||upper(columnname)||' is '||(说明字段)||';'
from sys_tabcolumns where tablename='Crm_Customer'(此SQL是错误的,说明字段前后少了“‘”标识符)
求:说明字段表示一个字段的时候,查询之后出现 comment on column CRM_CUSTOMER.ACCOUNTNO is '具体说明字段内容';
就是出现两个红色的‘'’,目前那个sql出来是没有这连个标识符的
select 'comment on column '||upper(tablename)||'.'||upper(columnname)||' is '||(说明字段)||';'
from sys_tabcolumns where tablename='Crm_Customer'
改
select 'comment on column '||upper(tablename)||'.'||upper(columnname)||' is '||说明字段||';'
from sys_tabcolumns where tablename='Crm_Customer'
select 'comment on column '||upper(tablename)||'.'||upper(columnname)||' is '||(说明字段)||';'
from sys_tabcolumns where tablename='Crm_Customer'
查询出来的结果是:comment on column CRM_CUSTOMER.ACCOUNTNO is 编码;
而我要的结果是:comment on column CRM_CUSTOMER.ACCOUNTNO is '编码';