存储过程中，如何在字符串中使用变量
例： select to_char(sysdate,'yyyymmdd') into v_yyyymmdd from dual; execute immediate('create table tableName_bk_' || v_yyyymmdd || ' as select * from TableName');
将A表和B表进行关联，将符合关联条件的B表字段值更新至A表
update TableA a set a1,a2,a3=(select b1,b2,b3 from TableB b where a.column_name1 = b.column_name1 and a.column_name2 = b.column_name2 and ...)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------