Inserting Values Into Table Oracle SQL Not Working

Question

I have a few lines that have worked in the past for inserting new values into an existing table.

INSERT INTO TABLE_NAME (OLD_NAME, NEW_NAME, COUNTED, ORIGIN)
VALUES ('old name', 'new name', null , null)

When executing this code it replies with

1 row inserted in 0.008 seconds

but when I check the actual table I see that the table hasn't been updated. I have tried multiple times, placing every piece of data in a line of its own. After checking I found out that the lines are indeed inserted into the table only not showing up when the whole table is queried, but showing up when counting lines.

Also, maybe important, the last two columns don't need information so they are null and the name columns are in a language written from right to left instead of being from left to right.

Consider posting the whole case - table description, INSERT statement, result of subsequent SELECT (which - as you say - proves that nothing was inserted). By the way, if you checked that in another session, you won't see anything until you commit changes you've made. — Littlefoot
– Littlefoot, Commented Apr 10, 2022 at 7:06

Soheil Babadi · Accepted Answer · 2022-04-10 07:54:15Z

1

Any command that updates the table or enters new data must be committed. Did you use the comet command in Oracle after executing the insert command? You can try this command after insert query:

COMMIT WORK;

answered Apr 10, 2022 at 7:54

Soheil Babadi

6952 gold badges7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Littlefoot Over a year ago

Well, not necessarily - if you're in the same session, it doesn't matter as you'll see changes you've made. But, if you want other users (sessions) to see that, then yes - you have to commit. It is unclear what the OP did so ... you might, or might not be right.

hi777 Over a year ago

Thanks, do you perhaps know how to deal with the 'ghost' lines that don't show

Collectives™ on Stack Overflow

Inserting Values Into Table Oracle SQL Not Working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related