I've two tables: BL (bl_id), FL (bl_id)
in BL there is the col COUNT_FL. One Building (bl_id) has more FL (floor fl_id). Now the col COUNT_FL is set default to zero.
When Can I update the col COUNT_FL to see the number of floor on any building???
this needs to be an after statement trigger
(making it a row trigger will result in a mutating trigger)
be warned tough this will
result in updating and locking your BL table entirely
a workaround would be to use
triggers & package to "push" only updates,inserts or deletes
in the package variables the update accordingly
this is a bit longer tough if you want the base scripts for that e-mail me
i'll send them