下面的SQL报告ORA-00932
SELECT V.USERNAME,
V.TABLESPACE_NAME,
CASE V.MAX_BYTES
WHEN -1 THEN
-1
ELSE
TO_CHAR(MAX_BYTES / 1024 / 1024 )
END as "Q"
FROM DBA_TS_QUOTAS V;下面的就没问题
SELECT V.USERNAME,
V.TABLESPACE_NAME,
CASE V.MAX_BYTES
WHEN -1 THEN
-1
ELSE
MAX_BYTES / 1024 / 1024
END as "Q"
FROM DBA_TS_QUOTAS V;
SELECT V.USERNAME,
V.TABLESPACE_NAME,
CASE V.MAX_BYTES
WHEN -1 THEN
-1
ELSE
TO_CHAR(MAX_BYTES / 1024 / 1024 )
END as "Q"
FROM DBA_TS_QUOTAS V;下面的就没问题
SELECT V.USERNAME,
V.TABLESPACE_NAME,
CASE V.MAX_BYTES
WHEN -1 THEN
-1
ELSE
MAX_BYTES / 1024 / 1024
END as "Q"
FROM DBA_TS_QUOTAS V;
SELECT V.USERNAME,
V.TABLESPACE_NAME,
CASE V.MAX_BYTES
when -1 then
to_char(-1)
else
to_char(MAX_BYTES / 1024 / 1024 )
END as "Q"
FROM DBA_TS_QUOTAS V;