ALTER Table CASHCLOSEMAST ADD ( CMC_VerifiedStatus CHAR (1 BYTE) default 'N', CMD_VerifiedDate DATE, CMC_VerifiedUser CHAR (4 BYTE) ); Insert into WEBMENU (CMODULE, NMAIN_MENU, NSUBMENU_ID, NSUBMENU_NAME, CMENU_URL, NMENU_ORDER, EDATE) Values ('CL', 1, 'CL002', 'Cash Close Receipt', 'CashCloseReceipt.aspx?startDate=%20&EndDate=%20&UserCode=%20&UserName=%20', 2, TO_DATE('09/15/2014 15:17:32', 'MM/DD/YYYY HH24:MI:SS'));