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.