Category: SQL

  • SQLite vs Oracle SQL Developer – nope?!? (Looks like) SQL Developer is no longer able to interface with as many RDBMSs as explained in its list.

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

    Why is this: (why not “.so.10.2“?): ./usr/lib/oracle/ ./usr/lib/oracle/ ./usr/lib/oracle/ -> ./usr/lib/oracle/ -> ./usr/lib/oracle/ (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ (why not “.so.11.2“?): ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ -> ./usr/lib/oracle/11.2/client64/lib/ (why not “.so.12.2“?): ./usr/lib/oracle/12.2/client64/lib/ ./usr/lib/oracle/12.2/client64/lib/ ./usr/lib/oracle/12.2/client64/lib/ ./usr/lib/oracle/12.2/client64/lib/ -> ./usr/lib/oracle/12.2/client64/lib/ ->…

  • “Oracle Instant Client” vs Debian (resp. Ubuntu) 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”

  • Oracle SQL scripts: how to use a variable 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? 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“.