SELECT statement gives Oracle Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SELECT statement gives Oracle Error

  1. #1
    Join Date
    Feb 2006
    Posts
    10

    SELECT statement gives Oracle Error

    Hi All,

    After importing the data, I get the following error whenever I ran a SQL query. This happens to only few tables and other tables are giving proper result.

    SELECT * FROM FR_BONUS_TYPES WHERE rownum < 2

    ORA-00936: missing expression

    Please help me

    Thanks in advance

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    Can you do "select count(*) from FR_BONUS_TYPE;"? What is FR_BONUS_TYPE? Is it a
    view and if so is the view valid? Do you have invalid objects in the sys or system schemas?
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width