declare
sql_stat varchar(200);
fieldtest varchar2(10);
begin
fieldtest :='groupid';
sql_stat := 'update XT.trust_USR_grp set '||fieldtest||' = ''3''
where userid=''zgk''' ;
execute immediate sql_stat using '3','zgk',fieldtest;
end;
/
sql_stat varchar(200);
fieldtest varchar2(10);
begin
fieldtest :='groupid';
sql_stat := 'update XT.trust_USR_grp set '||fieldtest||' = ''3''
where userid=''zgk''' ;
execute immediate sql_stat using '3','zgk',fieldtest;
end;
/
sql_stat varchar(200);
fieldtest varchar2(10);
begin
fieldtest :='groupid';
sql_stat := 'update XT.trust_USR_grp set '||fieldtest||' = ''3''
where userid=''zgk''' ;
execute immediate sql_stat;
end;
/