-
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
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|