create and use read-only view
537341Oct 31 2006 — edited Nov 1 2006Hi,
Im using HANDS ON ORACLE DATABASE 10G EXPRESS EDITION BOOK. Im in chap05 p. 179. Im using the object browser to create a view. Im creating the following SQL command:
create or replace view 'BACKLOGGED ORDERS' as
SELECT * FROM orders WHERE status = 'B' WITH READ ONLY
I was able to create this view. After this, I need to to replace the current version of the BACKLOGGEG_ORDERS view with the constrained updateable view. These are the steps:
1. Select BACKLOGGED_ORDERS in the Object selection pane.
2. Click code.
3. Click Edit.
4, Edit the definition of the view by replacing WITH READ ONLY with WITH CHECK OPTION.
5. CLICK COMPILE.
MY problem is the step no. 4. ( about edit the definition...) because I cannot see any choices there that says WITH READ ONLY or WITH CHECK OPTION. When I click the EDIT BOX . its not working at all. No messages. Totally empty.
PLEASE HELP ME WHAT CAN I DO WITH THIS.
THANK YOU.