1 Reply Latest reply: Nov 13, 2012 10:01 AM by rp0428 RSS

    table or view does not exist

    user11334489
      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
          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.
          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.