Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
I am trying to create a custom security profile in Oracle HRMS. So I went to the 'Security Profiles' screen -> Custom Security tab, check the 'custom restriction' check box and begin typing my SQL where clause. Here is my question:I type this:ASSIGNMENT.grade_id not in ( select grade_id from per_grades where PER_GRADES.NAME not like 'G%' or PER_GRADES.NAME not like 'M%') and it all works fine.However, if I type per_all_assignments_f instead of ASSIGNMENT, I get ORA - 00904 error. Why does this happen? How will I know what alias to use in case I want to include a different table in the query?
Questions by avidlearner
Related Answered Questions
Related Open Questions