(2) update name to

Data Main table

Reference table

load_)data_buf

(1) create a new column
for refereence id

(4) dgite regerence id back

(5) remove reference name column

(3) before unsrt trigger to
before insrt trigger( or, set AI to reference ID column )

download and insert

csv online

load_)data_log

(6) set foreign key to reference id column

Yahoo stock data - ca;lculatedaily change rate

update change rate using two data sets inner join

update change rate using cursor in srored procedure