Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    33

    Unanswered: populating column

    Hi All,

    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

  2. #2
    Join Date
    Jan 2004
    Posts
    492
    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)

  3. #3
    Join Date
    Mar 2004
    Posts
    23
    update my_table set disable_date = some_date where status = 'inactive'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •