On Tue, Feb 26, 2013 at 2:29 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > 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
Igor, a little correction here: it's not table with no data, it's table with exactly one row. If it was table with no data then SELECT .. FROM DUAL would have returned nothing. ;-) But anyway you suggested the correct replacement for that in SQLite. Pavel > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
