Category: Oracle DB
-
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…
-
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,…
-
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…
-
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…
-
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,…
-
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.
-
O’Reilly Media book: Oracle Essentials, 5th edition
Oracle Essentials: Written by experienced Oracle insiders, this easy-to-read volume covers every aspect of the Oracle database for readers of all technical levels. The book includes information on Oracle’s product line, architecture, data structures, networking, concurrency, tuning and more.
-
Poke disables Oracle’s database auditing – The H Security: News and Features
Poke disables Oracle’s database auditing – The H Security: News and Features: A command that is known from the BASIC programming language apparently allows unauthorised users to disable the auditing functions of Oracle databases. Experts think that this renders products which are based on these functions, such as Oracle Audit Vault, “nearly useless”