Amar, Sqlite has bind variables. They are not the same as an Oracle bind variable in that once you bind the address for the variable you do not have to rebind. With sqlite if you change the variable you must rebind. Sqlites version of binding is more like a copy into its own memory area. Also sqlite is missing the array level interface, which is the capability to batch up an array of data items and perform a single dml command where oracle would internally iterate over the array performing the operation. Also if you are planning on having multiple users and high concurrency you'd better stick with oracle. Sqlite is designed for embedded single users systems. Regards, Ken
"Amarjeet Kumar (RBIN/ECM4)" <[EMAIL PROTECTED]> wrote: Hi, Can we use the bind variable in sqlite query, if so how? Thanks in advance. Regards, Amar
