开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜