I'm using Oracle database and I've created a test table "Table1" with a varchar column "column1". I ran the following loop to add some rows:
BEGIN FOR i in 1..10 LOOP INSERT INTO TABLE1 (COLUMN1) VALUES (i); END LOOP; END;
If I run 'select count(*) from table1' I get '10' as my result. However, in SQL Developer, nothing shows up. I can add rows manually and commit them to the database(these appear in SQL Developer), but I can't seem to view the ones created in sqlplus command line. Why is that?