Example:
CREATE TABLE TOAD.TEST
(
B CHARACTER (10) WITH DEFAULT NULL,
A INTEGER WITH DEFAULT NULL,
C SMALLINT WITH DEFAULT NULL
);
CREATE VIEW TOAD.TEST
AS
(SELECT A || '-- TEST' AS AS, B, C FROM TOAD.TEST2100411TABLE);
The script generated by Toad is :
CREATE VIEW TOAD.TEST VIEW AS (
SELECT A || ' FROM TOAD.TEST);
Note that the --TEST is missing
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center