Need Help in design- Update columns
Need your help in design of the procedure
Scenarion: need to update all the columns for the records based on the condition
Pacakge: PKG_UPDATE.doc_reqquest (acct_no in varcahr2) -- this package contains an update sending an input as account number
table: 'Doc_request' have total columns of 120 (initail insert only for 30 columns) and rest of the columns need to update by calling the above package
is this the below statment is recommended to update all the columns
BEGIN
FOR INDX IN (SELECT *
FROM DOC_REQUEST WHERE TRUNC(DATETIMESTAMP) = TRUNC(SYSDATE)
AND CMS_DOC_TYPE_ID = 1 and status ='N' ) LOOP