Code: Select all
use okmdb;
update okm_profile set PRF_TB_SCANNER_VIS='F' where PRF_ID=1 ;
update okm_profile set PRF_TB_UPLOADER_VIS='F' where PRF_ID=1 ;
commit;
SELECT PRF_TB_SCANNER_VIS,PRF_TB_UPLOADER_VIS FROM okmdb.okm_profile ;
Pls do modification as above , it will work as expected .