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.