wp.jochen.hayek.name/blog-en

Category: databases

  • how to make MediaWiki connect to a MySQL server on the same server through a socket in a non-standard location

    —

    by

    johayek
    in ,

    https://www.mediawiki.org/wiki/Manual:$wgDBserver This is what I searched for in order to find the above article: mediawiki mysql socket

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

    —

    by

    johayek
    in ,

    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, …

    —

    by

    johayek
    in

    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…

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

    —

    by

    johayek
    in

    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)

    —

    by

    johayek
    in

    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,…

  • iReport, some Oracle database, JDBC, SQLRunner, …

    —

    by

    johayek
    in ,

    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…

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

    —

    by

    johayek
    in ,

    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 +…

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

    —

    by

    johayek
    in ,

    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…

  • O’Reilly Media book: Oracle Essentials

    —

    by

    johayek
    in

    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,…

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

    —

    by

    johayek
    in

    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.