oracle-materialized-view

DROP MATERIALIZED VIEW MV_X;
CREATE MATERIALIZED VIEW MV_X 
BUILD IMMEDIATE 
NEVER REFRESH  
--REFRESH  ON DEMAND ENABLE QUERY REWRITE
AS 
SELECT 'A' AS X FROM DUAL
;
create index IDX_MV_X on MV_X(X);
SELECT * FROM MV_X
;