wp.jochen.hayek.name/blog-en

Category: SQL

  • SQLite vs Oracle SQL Developer – nope?!?

    —

    by

    johayek
    in , ,

    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”?

    —

    by

    johayek
    in , , , ,

    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…

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

    —

    by

    johayek
    in , , , , ,

    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…

  • Oracle Instant Client: “free, light-weight, and easily installed Oracle Database tools, libraries and SDKs for building and connecting applications to an Oracle Database instance”

    —

    by

    johayek
    in , ,

    http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/ http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/

  • Oracle SQL scripts: how to use a variable for the table name

    —

    by

    johayek
    in , ,

    https://stackoverflow.com/questions/1179652/how-to-use-a-variable-in-oracle-script-for-the-table-name There is a “test table” and there is a “serious table” – use a variable name for the table(s) in question!

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

    —

    by

    johayek
    in ,

    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“.