Skip to Content
0
Former Member
Jun 05, 2009 at 11:39 AM

Update through native sql

51 Views

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.