Re: [sqlite] Oracle connection

for clearification: the roots of the question: business needs; our client has a big Oracle infrastructure. Now they want, in relation to their infrastructure a litte App based on SQlite. as I mentioned earlier: to copy data from an Oracle DB to another Oracle DB there is just one single line

Re: [sqlite] Oracle connection

I don't know what JET is. I testet ADO. That works. But it'is slow and you have to write some (to much) code. Much more better would be a solution like a direct LINK (like an Oracle Database Link). as shown in my first email: insert into sqlitetable_columA select ColX from ta...@oracledb If

Re: [sqlite] Oracle connection

On 3 Jun 2010, at 4:25pm, Simon Hax wrote: > Is something possible like > > insert into sqlite_table.ColumnA select x from ta...@oracledb > > ? > (Without copying into local memory (firstly do a select from Oracle ) > and then insert into a Sqlite database (via e.g. ADO )

[sqlite] Oracle connection

Is something possible like insert into sqlite_table.ColumnA select x from ta...@oracledb ? (Without copying into local memory (firstly do a select from Oracle ) and then insert into a Sqlite database (via e.g. ADO ). ) S. ___ GRATIS für

[sqlite] FW: recursive select in sqlite

Oracle knows a clause called " connect by ..." where you can have "parent"-nodes and "siblings" and so on to construct hierarchical e.g. part lists My understanding is that sqlite does not support this. S. -Ursprüngliche Nachricht- Von: zeal Gesendet: 17.05.2010

Re: [sqlite] sqlite update with joins

Oracle allows to assign an alias to a table in an update-statement like update T x set x.col = . in my eyes thats clear syntax. so there is a better way. I would prefer that syntax. Sqlite should have implemented that. Simon -Ursprüngliche Nachricht- Von: Pavel Ivanov

[sqlite] Update: set multiple values

I think in sqlite the following is not possible: update T set (a,b,c) = ( select x,y,z from ...) Does anyone know how to do in an easy way ? Simon ___ GRATIS: Movie-Flat mit über 300 Top-Videos. Für WEB.DE Nutzer dauerhaft kostenlos!