Set new row value on insert from select statement in Oracle SQLplus

You can do a select into

select ot.details_col
  into :new.column_one
  from other_table ot
 where ot.property_id = :new.property_id;

Of course, I’d strongly question the data model if this makes sense. That strongly implies that you’ve got a data model in need of some normalization.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top