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
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center