CREATE VIEW OLIVOS_A AS SELECT * FROM OLIVOS WHERE UPPER(OLIVOS.TEXTO) LIKE 'A';
CREATE VIEW OLIVOS_S AS SELECT * FROM OLIVOS WHERE UPPER(OLIVOS.TEXTO) LIKE 'S';
CREATE VIEW OLIVOS_N AS SELECT * FROM OLIVOS WHERE UPPER(OLIVOS.TEXTO) NOT LIKE 'A' AND UPPER(OLIVOS.TEXTO) NOT LIKE 'S';