On 2/26/2013 5:13 PM, anydacdev anydacdev wrote:
I am struggling with SQLite's support for Oracle's DUAL table.
The updated statement, now including Oracle's DUAL looks like.
MERGE INTO x TGT
USING (SELECT 'A_NAME' as name, 'A_KEY' as key FROM DUAL) SRC
As far as I can tell, you are using DUAL as a table with no data, just
something to put into a FROM clause to keep the parser happy. In this
case, you would be glad to know that SQLite doesn't require FROM clause
at all - you can simply write
SELECT 'A_NAME' as name, 'A_KEY' as key
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
