Update with check option

After that, insert a row into the employees table through the vps view:. Finally, insert an employee whose job title is SVP Marketing into the employees table through the vps view to see if it is allowed. Error Code: Up Next. Oracle technology is changing and we strive to update our BC Oracle support information.

If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. All rights reserved by Burleson. Search BC Oracle Sites. Asked 8 years, 4 months ago. Active 6 years, 9 months ago. Viewed 7k times. What's going on here? Improve this question.

TheWommies TheWommies 4, 10 10 gold badges 57 57 silver badges 76 76 bronze badges. What version of SQL are you using? Add a comment. Active Oldest Votes. Improve this answer. Andrey Morozov Andrey Morozov 7, 5 5 gold badges 47 47 silver badges 73 73 bronze badges.