Select query on Oracle using ODBC


I am trying to retrieve the data from the Oracle DB using a select query. I have inserted two rows into the table manually. When I tried using a select query on the same, the number of rows that are retrieved is zero.

Below is the simple query that I am using to retrieve the data:

“Select * from <Table_Name>”

Need some suggestions on the same.(Urgent)


Hi @VaishnaviD,

Hope these links will be useful for you.


Check if you are pointing to correct database, or you can include

USE yourDataBaseName
Select * from tablename


Thank you Saranya and Rupesh.

Yeah, it worked after including the Database name.