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. enter image description here

what commit. autocommit on?

or add 'commit' after insert statement


Comments

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

python - How to remove the Xframe Options header in django? -