| Subject | error when add computed |
|---|---|
| Author | ronaldorezende |
| Post date | 2003-04-04T14:30:35Z |
I have this error when I try to create this computed column.
Token unknow: LIne 3 char 1.
ALTER TABLE MATRICULA ADD QTD_MATRICULA_CURSO COMPUTED BY
(
SELECT COUNT(*) FROM MATRICULA
)
What's wrong?
If I put "extract(year from DATA_MATRICULA) from MATRICULA" instead of
"SELECT COUNT(*) FROM MATRICULA" is ok
Token unknow: LIne 3 char 1.
ALTER TABLE MATRICULA ADD QTD_MATRICULA_CURSO COMPUTED BY
(
SELECT COUNT(*) FROM MATRICULA
)
What's wrong?
If I put "extract(year from DATA_MATRICULA) from MATRICULA" instead of
"SELECT COUNT(*) FROM MATRICULA" is ok