ALTER VIEW 문의 CHANGE QUERY 절을 사용하여 뷰 질의 명세부에 정의된 질의를 변경할 수 있다.
ALTER [ VIEW | VCLASS ] 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'