This discussion is archived
1 Reply Latest reply: Nov 13, 2012 8:01 AM by rp0428 RSS

table or view does not exist

user11334489 Newbie
Currently Being Moderated
Dear All,
There is one table in HTGDEV user.The name is 'RTS'.

when I am using select * from Tab where upper(tname)='RTS';
Then I will get the one record.

But when I am using select * from RTS;
Then I got the message 'table or view does not exist'

How its Possible.

Please give me one solution

Thanks and Regards,
Faziludeen
  • 1. Re: table or view does not exist
    rp0428 Guru
    Currently Being Moderated
    WRONG FORUM!

    This forum is only for SQL Developer questions. You need to post your question in the SQL and PL/SQL forum. When you do you need to provide your 4 digit Oracle version.
    SQL and PL/SQL
    >
    There is one table in HTGDEV user.The name is 'RTS'.

    when I am using select * from Tab where upper(tname)='RTS';
    Then I will get the one record.

    But when I am using select * from RTS;
    Then I got the message 'table or view does not exist'
    >
    That code doesn't mean much of anything since the queries use two different tables. We have no idea what the 'Tab' table is or what is contained in the 'tname' column.

    We also have no idea what user you are connected as or whether that user has been granted select privileges on any RTS table.
    Repost your question in the proper forum.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points