On Sun, Sep 11, 2016 at 11:48 PM, mikeegg1 <mikee...@mac.com> wrote: > I think Oracle (a long distant memory) has variables like @variable or > @@variable.
Not really. Oracle SQL doesn't have variables per se. But APIs to interact with Oracle SQL (OCI, JDBC, ODBC, etc...) can *bind* and *define* "host language" variables, just like SQLite's API can bind/define them too. The Oracle command-line program (of choice), SQL*Plus, allows to bind variables [1] [3], which behind the scene means allocating some memory for the variable, and binding it as normal. But there's no direct support for defining. For this you need PL/SQL (see below). Then PL/SQL, the server-side language which also supports variables, has special syntax to SELECT ... INTO [2], to define variables, and natively supports bind variables as well. But again, in both cases it's the host program that implements the variable handling, not SQL itself. (define variables do need special support at the SQL level I guess, for the INTO syntax) sqlite3.exe, the SQLite command line driver, doesn't support bind variables itself. It could be added (using [5] and co.), but that's just not the case. In addition to what David mentioned (temp tables), you could also use CTEs [4], which is just a variation of the same temp table technique, albeit with a more "transient" temp table. [1] https://oracle-base.com/articles/misc/literals-substitution-variables-and-bind-variables [2] https://oracle-base.com/articles/misc/introduction-to-plsql#using-sql-in-plsql [3] http://www.adp-gmbh.ch/ora/sqlplus/use_vars.html [4] https://www.sqlite.org/lang_with.html [5] https://www.sqlite.org/capi3ref.html#sqlite3_bind_parameter_count _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
