Select query on Oracle using ODBC


#1

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)


#2

Hi @VaishnaviD,

Hope these links will be useful for you.



#3

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

USE yourDataBaseName
Go
Select * from tablename


#4

Thank you Saranya and Rupesh.

Yeah, it worked after including the Database name.