SQLite vs Oracle SQL Developer – nope?!?

https://en.wikipedia.org/wiki/SQLite https://en.wikipedia.org/wiki/Oracle_SQL_Developer http://www.oracle.com/technetwork/developer-tools/sql-developer/thirdparty-095608.html http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html https://stackoverflow.com/questions/1525444/how-to-connect-sqlite-with-java https://bitbucket.org/xerial/sqlite-jdbc/downloads/ (Looks like) SQL Developer is no longer able to interface with as many RDBMSs as explained in its list. https://en.wikipedia.org/wiki/Comparison_of_database_tools

“Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?

Why is this: 10.2.0.5 (why not “.so.10.2“?): ./usr/lib/oracle/10.2.0.5/client64/lib/libocci.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libclntsh.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libclntsh.so -> libclntsh.so.10.1 ./usr/lib/oracle/10.2.0.5/client64/lib/libocci.so -> libocci.so.10.1 ./usr/lib/oracle/10.2.0.5/client/lib/libsqora.so.10.1 11.2.0.2.0 (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so -> libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libocci.so -> libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 11.2.0.4.0 (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libclntsh.so -> libclntsh.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libocci.so -> libocci.so.11.1 ./usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 12.2.0.1.0 (why not “.so.12.2“?): ./usr/lib/oracle/12.2/client64/lib/libocci.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntshcore.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntsh.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntshcore.so -> libclntshcore.so.12.1 ./usr/lib/oracle/12.2/client64/lib/libclntsh.so -> libclntsh.so.12.1… Continue reading “Oracle Instant Client” for Linux x86-64 (RPM) – why not “*.so.X.2”?

“Oracle Instant Client” vs Debian (resp. Ubuntu)

http://www.oracle.com/technetwork/database/database-technologies/instant-client/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/ Of course “Oracle Instant Client” is closed source, does not comply with Debian rules, and cannot / may not be distributed through Debian channels. Oracle supplies RPM files for “Linux x86-64” but no “.deb” files. And presumably both Oracle and also the “Debian Project” disallow redistribution of “Oracle Instant Client” components as Debian… Continue reading “Oracle Instant Client” vs Debian (resp. Ubuntu)

how can I create a copy of an Oracle table without copying the data?

https://stackoverflow.com/questions/233870/how-can-i-create-a-copy-of-an-oracle-table-without-copying-the-data#233890 create table xyz_new as select * from xyz where rownum < 0; In Oracle SQL Developer use the menu-function (maybe right-click) on the table you want to operate on (i.e. that you want to copy), “Table“, “Copy…“, w/o checking “Include Data“.