Please try this create table a ( name char (1), sex varchar2 (15)) update a set sex = decode ( sex ,'m','f','f','m')
Type: Posts; User: jag_swathi; Keyword(s):
Re: Convert Gender Column
Please try this create table a ( name char (1), sex varchar2 (15)) update a set sex = decode ( sex ,'m','f','f','m')
Re: Inserting instead of updating
please check the form status by putting in message of when-button-pressed trigger.
the commit built-in is inserting the record because of unchanged form status.
in case u can not find it put...