Tag Info

New answers tagged

0

I suggest you rephrase your insert like: INSERT INTO bar (description, foo_id) SELECT 'testing', id from foo WHERE type='blue' UNION SELECT 'another row', id from foo WHERE type='red'; or: INSERT INTO bar (description, foo_id) select y.description, x.id from foo as x join ( select 'blue' as type, 'testing' as description union select ...


1

Oracle has mentioned related to this in the Tec documents JDBC-ODBC Bridge The JDBC-ODBC Bridge allows applications written in the Java programming language to use the JDBC API with many existing ODBC drivers. The Bridge is itself a driver based on JDBC technology ("JDBC driver") that is defined in the class sun.jdbc.odbc.JdbcOdbcDriver. The ...



Top 50 recent answers are included