Forum Discussion

KAD911's avatar
KAD911
New Member
2 years ago
Solved

Oracle Tables Loads from Oracle Database, But writing SQL Statement says Table doesnt exsist

Hello,  I have a oracle database, and I can connect to the server and load tables from the database when Im using, Get Data > Oracle Database > Direct Query > OK. I can see  all the available tabl...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    KAD911 , Try to add DB or Schema Name and try

     

    SELECT * FROM DB1.MY_TABLE

amitchandak's avatar
amitchandak
Super User
2 years ago

KAD911 , Try to add DB or Schema Name and try

 

SELECT * FROM DB1.MY_TABLE

KAD911's avatar
KAD911
New Member
2 years ago

Oh that was it!! 
 I feel so stupid now.

 

Thanks aloot!! You saved the day!!