Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE students ( id, name )
AS SELECT 1, 'Alice' FROM DUAL;
1 rows affected

DECLARE
  invalid_identifier EXCEPTION;
  PRAGMA EXCEPTION_INIT( invalid_identifier, -904);
BEGIN
  EXECUTE IMMEDIATE 'CREATE VIEW student_view AS SELECT id, name, SUBSTR( email, 1, 100 ) AS STUDENT_EMAIL FROM students';
EXCEPTION
  WHEN invalid_identifier THEN
    EXECUTE IMMEDIATE 'CREATE VIEW student_view AS SELECT id, name, CAST( null AS VARCHAR2(100) ) AS STUDENT_EMAIL FROM students';
END;
/
1 rows affected

SELECT * FROM student_view;


ID
NAME
STUDENT_EMAIL


1
Alice
null