Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create and use read-only view

537341Oct 31 2006 — edited Nov 1 2006
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2006
Added on Oct 31 2006
1 comment
433 views