I created a sql script to create and populate tables. The script was run in SqlDeveloper.

When I run the query

Select * from table_name

in Sql Developer it does work and returns the data from the table.

But when I open the Command Prompt and I login and execute the same query I receive the message "no rows selected". I also tried to run

SELECT table_name FROM user_tables;

in command line and it does work, all the tables names are returned.

1 Answers

2
sticky bit On Best Solutions

Sounds like you did not commit the transaction. Issue a

COMMIT;

after your INSERT statements.