How to select data from non-table in Firebird?
I'm searching for the Firebird equivalent of:
SELECT 'abc' AS abc, 123 AS def, '20110101开发者_JAVA百科' AS dt
Whenever I do
SELECT 'whatever' as xxx
I get an error message.
Firebird, like Oracle, requires a table for a SELECT.
Usually, RDB$DATABASE is used for this purpose:
SELECT 'abc' AS abc, 123 AS def, '20110101' AS dt
FROM RDB$DATABASE
加载中,请稍侯......
精彩评论