Intersystems Cache Dummy Table

0
votes

Does Intersystems Cache database have a dummy table similar to Oracle's DUAL?

I want to do something similar to:

SELECT 1; -- mysql
-- or
SELECT 1 FROM DUAL; -- oracle
1
intersystems-cache

1 Answers

1
votes

Older versions of Cache do not support this. You can create a dummy table yourself called DUAL or DUMMY. Newer versions of Cache (2009.1+) support select with no FROM clause.