Tag: Oracle SQL Developer

  • 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

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

  • Oracle SQL Developer – how to run it on Windows in English w/o admin rights?

    https://stackoverflow.com/questions/7768313/how-can-i-change-the-language-to-english-in-oracle-sql-developer https://stackoverflow.com/a/24532448/3119172 I chose the approach “set language at runtime“: sqldeveloper.exe –AddVMOption=-Duser.language=en Works like a charm. On the Win7 PC at work I have no admin rights, therefore I cannot change the config file mentioned in the thread.

  • Oracle’s SQL Developer – they give it away for free

    https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html http://stackoverflow.com/questions/7768313/how-can-i-change-the-language-to-english-in-oracle-sql-developer – add a few AddVMOption-s in/to ide/bin/ide.conf In international working environments I personally don’t want to see software developers use “indigenous languages” for software development, and I always go for English. And also: if you “google” for error / warning messages – what sense does it make to search for error messages in e.g. Alemannic?