PL/SQL Update Table Where id in Select Another Table

update schema_name.table_name
set tur_id=24
where id in(select id
            from schema_name.table_name
            where tur_id not in (1,24,3,4,5,7,23,21));

Comments

Popular posts from this blog

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Solution for "Can not obtain Oracle client information from registry"