Dear all,
i have written a select query for Update oracle database through Native SQL.
Query is
W_FLG = 'Y'
UPDATE LPR_LEAVEPLAN_TRN SET FLOWLEVEL = W_FLG WHERE EMP_ID = '11200010'.
LPR_LEAVEPLAN_TRN is my oracle table
i want to change the field of that table is FLOWLEVEL with W_FLG where employee id is 11200010
here update is not working.
can any body tell me how can update work with oracle database.