13th Day of Oracle Learning

Source: Internet
Author: User
Tags one table

First, the constraint: Skip, MSSQL is not very used

Second, view: This is still more useful, especially when working with other companies, often provide a view of each other

1. Create VIEW: Created OR REPLACE view XX as SELECT * from XXX; Easy update with "OR REPLACE"

Default Scott user does not have View permissions created

2. The View data dictionary User_views

3. View Add Data: Single table can, but if insert into view, will only increase the view contains this data, the remaining table field will be filled with NULL, if not NULL will be an error.

4. View Update data: Single table can

5. View multiple table Insert or UPDATE: Will "Unable to modify multiple base tables through the Join view"

6, delete data: Single table can, but multi-table association will only delete one table, the other table is not deleted

7. With CHECK OPTION: The View creation Criteria field is not updated, but other fields can be updated

8. With Read only: read-only view

9. Remove View: Drop View XXX

13th Day of Oracle Learning

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.