Gary Han - A Nerd Who Tries To Be Cool And Failed Thus Far

This is just a reminder that when you go to a Oracle database and when u do:
select * from table_name;
it returns view or table not exist
 
yet the table does exist.
 
Please try:
 
select * from "table_name";
 
In Oracle, if you create a table with case sensitive (the " " around your table name) you must also reference it by " " when u run queries.
 
if you create table table_name (without the " ")
then you may do:
 
select * from table_name
select * from TABLE_NAME
select * from Table_nAME
 
it will all work.
 
it seems that no quote when creating tables are the standards now in most companies.