database - insert statement show 1 row created but data is not insert (script) -
i using run sql command line insert data, script ask below.
insert usermaster (userid,userpwd,username,userposition,useraccessrights,userstatus,createuserid) values ('admin','nvzfj0sojj/efu700exl6a==','admin','administrator','non-administrator','1', 'admin');
but when open database using toad , log in user , see, data not insert table. may know place goes wrong?
image below output in sql command.
what commit. autocommit on?
or add 'commit' after insert statement
Comments
Post a Comment