PL/SQL Insert into one table from another by using sequence


insert into table_1
(
  col_1, col_2, col_3
)
select  seq_my_sequence.nextval,
        k.col_2,
        k.col_3,
        from my_schema.table_2 k;

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"