CHANGE QUERY 절

설명

ALTER VIEW 문의 CHANGE QUERY 절을 사용하여 뷰 질의 명세부에 정의된 질의를 변경할 수 있다.

구문

ALTERVIEWVCLASS ] view_name

    CHANGE QUERY [ integer ] select_statement [ ; ]

예제

--adding select_statement which query number is 2 and 3 for each

ALTER VIEW b_view ADD QUERY SELECT * FROM a_tbl WHERE id IN (1,2);

ALTER VIEW b_view ADD QUERY SELECT * FROM a_tbl WHERE id = 3;

SELECT * FROM b_view;

;xr

 

=== <Result of SELECT Command in Line 1> ===

 

           id  phone

===================================

            1  '111-1111'

            2  '222-2222'

            3  '333-3333'

            4  NULL

            5  NULL

            1  '111-1111'

            2  '222-2222'

            3  '333-3333'

 

 

8 rows selected.

 

--altering view changing query number 2

ALTER VIEW b_view CHANGE QUERY 2 SELECT * FROM a_tbl WHERE phone IS NULL;

SELECT * FROM b_view;

;xr

 

=== <Result of SELECT Command in Line 1> ===

 

           id  phone

===================================

            1  '111-1111'

            2  '222-2222'

            3  '333-3333'

            4  NULL

            5  NULL

            4  NULL

            5  NULL

            3  '333-3333'