PL/SQL (MOSC)

MOSC Banner

Need Help in design- Update columns

edited Nov 29, 2011 10:32PM in PL/SQL (MOSC) 10 comments
Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center