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

  
Showing Answers 1 - 2 of 2 Answers

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions