数据库空格问题 declare tablenames varchar2(50); var_sql varchar2(200); Cursor tablename_cursor is select t.table_name from user_tab_comments t where t.table_name like 'EXIT2010010500%'; begin open tablename_cursor; loop fetch tablename_cursor into tablenames; exit when tablename_cursor%notfound; if tablename_cursor%found then var_sql:='update test.'||tablenames||' t set t.vehiclelicense=t.vehiclelicenseauto where t.vehiclelicense=||' '; execute immediate var_sql; end if; end loop; close tablename_cursor; end;
问题: var_sql:='update test.'||tablenames||' t set t.vehiclelicense=t.vehiclelicenseauto where t.vehiclelicense=||' ';这句中的空格一直显示错误。用了vehiclelicense is null也不行,用length(vehiclelicense)=0也不行,请大家帮忙看看!
t.vehiclelicense=||'' ''
------解决方案-------------------- 怎么感觉引号多一个啊~~~ var_sql:='update test.'||tablenames||' t set t.vehiclelicense=t.vehiclelicenseauto where t.vehiclelicense is null '; execute immediate var_sql;