I want to input date and time from the below sql script, but it show the error
please guide.
DECLARE
INVOICE_NO_V NUMBER;
BEGIN
SELECT MAX(INVOICE_NO) INTO INVOICE_NO_V FROM INV.RESTU_SALE_M;
SELECT TO_CHAR(DATE_TIME,'DD.Mon.RRRR')||' '|| TO_CHAR(SYSDATE,'HH:MI:SS AM')
INTO :RESTU_SALE_M.DATE_TIME FROM INV.RESTU_SALE_M WHERE INVOICE_NO = INVOICE_NO_V;
END;
