I heard that SQLite can use much of Oracle SQL, at least if the queries confirm to the style/standard that SQLite uses. Especially, I thought I heard that SQLite will ignore the "user" or "schema" name parts of the SQL statements.
That is, if a query to Oracle was: select * from user1.table1 Then SQLite would treat it as: select * from table1 Since SQLite doesn't have users. Am I right about that? If not, I suppose I will have to use some conditional code to include the Oracle user name or not, depending on whether my application is connecting to the production DB or my local SQLite development one. -- View this message in context: http://old.nabble.com/using-Oracle-SQL%2C-ignoring-user-tp26836571p26836571.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
