var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
How to populate one column whose value is dependent of the value of the other column without writing a procedure.
for example I have column name 'disable_date' and it should be populate only when other column name 'status' has value 'inactive'.
Thanks in advance
Your best best is probably to write a row level trigger on this table. For each row inserted into your table, if the column status = 'inactive' then populate disable_date with sysdate - or else do not.
Oracle OCPI (Certified Practicing Idiot)
update my_table set disable_date = some_date where status = 'inactive'
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors