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 <T…

Check if you are pointing to correct database, or you can include USE yourDataBaseName Go Select * from tablename

Select query on Oracle using ODBC

SaranyaKishore (Saranya R) July 3, 2018, 7:23am 2

Hope these links will be useful for you.

Topic		Replies	Views
Database Activity Query, How to do this Help database	2	2564	December 22, 2016
Database : select query Help	3	1490	August 29, 2018
Execute Query: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00922: missing or invalid option Help database , activities , question	3	1883	December 11, 2020
Help running a Query in Oracle DB Help	2	1937	November 28, 2018
Oracle connection guide Help	3	2642	May 3, 2019