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 PL/SQL built-in packages: DBMS_OUTPUT, …

https://www.safaribooksonline.com/library/view/learning-oracle-plsql/9781771375702/ – my PL/SQL course In my PL/SQL course I came across this built-in package: DBMS_OUTPUT. The put_line procedure within that package reminded me of Ada, so I got curious to get to know its sister subroutines. My web search led me to this : http://stackoverflow.com/questions/1453538/how-to-redirect-the-output-of-dbms-output-put-line-to-a-file … http://shop.oreilly.com/product/9781565923751.do – Oracle Built-in Packages – Oracle Development Languages https://www.safaribooksonline.com/library/view/oracle-built-in-packages/1565923758/ https://www.safaribooksonline.com/library/view/oracle-built-in-packages/1565923758/ch06.html – “Generating Output… Continue reading Oracle PL/SQL built-in packages: DBMS_OUTPUT, …

Published
Categorised as Oracle DB

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?

O’Reilly Media video training course: Learning Oracle PL/SQL (by Darryl Hurley)

http://shop.oreilly.com/product/0636920047087.do – the 2016 Hurley video training course http://shop.oreilly.com/product/9780596001803.do – the 2001 Pribyl&Feuerstein book As I have full access to Safari (as an individual), I don’t pay for individual books and videos – as long as I only access them online (referring to the books) – so I can just start the video training course and see,… Continue reading O’Reilly Media video training course: Learning Oracle PL/SQL (by Darryl Hurley)

Published
Categorised as Oracle DB

iReport, some Oracle database, JDBC, SQLRunner, …

Your task is to interface a rather remote Oracle database with iReport. But you are not really sure, whether you are able to successfully connect to the database at all. And you want to “explore” the database, its tables, its “views” … No CLI utility like sqlplus available as well. I am trying SQLRunner. Says something… Continue reading iReport, some Oracle database, JDBC, SQLRunner, …

how to connect to a PostgreSQL database using JDBC w/o host

https://en.wikipedia.org/wiki/Java_Database_Connectivity http://jan-lolling.de https://github.com/jlolling/sqlrunner https://github.com/JochenHayek/sqlrunner – my fork I am giving Jan Lolling’s SQLRunner a try to connect to a local PostgreSQL database. SQLRunner is written in Java, and it uses JDBC to connect to the various databases. Apparently there are 2 ways to connect to a PostgreSQL database: hostname + port + database + … socket +… Continue reading how to connect to a PostgreSQL database using JDBC w/o host

Pre-Built Developer VMs for Oracle VM VirtualBox: Oracle DB, Solaris, …

http://www.oracle.com/technetwork/community/developer-vm/index.html It looks rather, rather intriguing to run a ready-made VM with Oracle DB. Let’s see, how and wether it will work out! A ready-made VM with Oracle DB: That would trueyl be the easiest way to improve my Oracle DB, and SQL, and PL/SQL skills – together with the fine o’Reilly books on the related… Continue reading Pre-Built Developer VMs for Oracle VM VirtualBox: Oracle DB, Solaris, …

O’Reilly Media book: Oracle Essentials

http://shop.oreilly.com/product/0636920027737.do Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume, including a valuable overview of Oracle Database 12c. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture,… Continue reading O’Reilly Media book: Oracle Essentials

Published
Categorised as Oracle DB

O’Reilly Media book: Oracle PL/SQL Programming, 6th Edition

http://shop.oreilly.com/product/0636920024859.do Considered throughout the Oracle technology community to be the best Oracle PL/SQL programming book available, this guide is the definitive reference on Oracle’s powerful procedural language. Like its predecessors, this sixth edition covers language fundamentals, advanced coding techniques, and best practices for using PL/SQL. Thoroughly updated for Oracle Database 12c.

Published
Categorised as Oracle DB