336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
- DML operation on simple view
- Cannot remove or modify a row if the view contains the following:
- Group function
- A GROUP BY clause
- The DISTINCT keyword
- The pseudocolumn ROWNUM keyword
- columns defined by expressions (only modify)
- Cannot add data through a view if the view includes
- Group function
- A GROUP BY clause
- The DISTINCT keyword
- The pseudocolumn ROWNUM keyword
- columns defined by expressions
- NOT NULL columns in the base tables that are not selected by the view
'Oracle' 카테고리의 다른 글
| Using the WITH CHECK OPTION Clause (0) | 2006.11.24 |
|---|---|
| Using the WITH CHECK OPTION Clause (0) | 2006.11.24 |
| Rules for Performing DML Operations on a View (0) | 2006.11.24 |
| Views (0) | 2006.11.24 |
| Views (0) | 2006.11.24 |