开发者

How to select data from non-table in Firebird?

开发者 https://www.devze.com 2023-03-03 23:50 出处:网络
I\'m searching for the Firebird equivalent of: SELECT \'abc\' AS abc, 123 AS def, \'20110101开发者_JAVA百科\' AS dt

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

精彩评论

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