AMIS, Data Driven Blog – Oracle & Microsoft Azure
Getting value from IoT, Integration and Data Analytics
What’s in a name? A title is important and I hope that it describes well what I do want to share with you in this series of articles. It is not so much about how to use the back-end part (Oracle Database) or the front-end (Oracle APEX, Java, Node, React […]
0 
0 Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)”, I told you about Git, Subversion, Maven and Flyway. In this final article, I will discuss the following tools & methods: Oracle SQL Developer, utPLSQL, SonarQube, Perl, Ant and DevOps. Oracle […]
0 0 Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)”, I told you about the Oracle SQL Developer Data Modeler. This time I will discuss the following tools: Git, Subversion, Maven and Flyway. Flyway The first tool I would like to […]
0 0 Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (3)”, I told you about the Oracle Database and Oracle APEX. This time I will discuss Oracle SQL Developer Data Modeler. Oracle SQL Developer Data Modeler A book I can recommend is Oracle […]
0 0 Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (2)”, I did show you the database structure. This time I will elaborate on the base tools, the Oracle Database and Oracle APEX. Oracle Database How to use it? I can tell […]
0 0 Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (1)”, I gave you an introduction. This time I will elaborate on the database structure. Project folder layout The following top level directories may exist for every database application project: Directory Description […]
0 0 In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In the previous two Blogs I have described the tools and techniques used to create and install migration scripts. In this Blog I will describe the ‘(un)happy flow’ for a database […]
0 0 In the previous Blog I have described how to implement CD for an Oracle database by using migration scripts. In this Blog I will describe how to create migration scripts (automagically). DML scripts This is the more simple case because you need them less often. There are various data compare […]
0 0 In this Blog I will explore the possibilities to apply Continuous Delivery (CD) for the Oracle database. What is Continuous Delivery? The introduction on Wikipedia Continuous Delivery says: “Continuous delivery (CD) is a software engineering approach in which teams produce software in short cycles, ensuring that the software can be […]
0 0 Oracle biedt sinds Oracle 8i via het package DBMS_PROFILER ondersteuning voor profiling. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden en zal het pldbg package geoptimaliseerd worden waarbij het gebruik van dynamisch PL/SQL wordt verbeterd en conditionele compilatie wordt gebruikt om […]
0 0 Oracle biedt sinds Oracle 8i via het package DBMS_DEBUG ondersteuning voor debugging. In dit artikel, dat ook in Optimise zal verschijnen, zal dit package onder de loep genomen worden en zullen de volgende toepassingen gepresenteerd worden: een interactieve debugger in SQL*Plus en het automatisch tonen van waardes van in en […]
0 0 From 21 February till 23 February the OakTable seminar Optimising Oracle (Performance by Design) by Jonathan Lewis was held. The seminar had been organised by Lex de Haan, who recently died, and his wife, Juliette Nuijten, from Naturaljoin (http://www.naturaljoin.nl). Despite his death the seminar continued, just as Lex wanted. Naturaljoin […]
0 0 Did you (or one of your customers) ever encounter ORA-00942 (table or view does not exist) while working in a (Web) form? No, then you can skip this post.
0 0 Have you ever tried to split the DDL scripts generated by Designer? Pretty tough, isn’t it? Well, I have a nice solution for you: the Perl script sql_split.pl splits the input DDL script(s) as if you had chosen to generate just one object in Designer. For example: if you generate […]
0 0 The tool JPublisher is a little bit unknown. But it is a very handy tool for accessing PL/SQL stored procedures, packages, functions as well as object, collection or reference types from Java. There is no need for writing error prone Java code when you need to access those objects: JPublisher […]
0 0 The Open Source Java code checker Checkstyle can be easily used by Ant to check your Java code. This is an excerpt from an Ant build.xml file using the Sun Java coding checks: <property name=”checkstyle.home” location=”…”/> <taskdef resource=”checkstyletask.properties” classpath=”${checkstyle.home}/checkstyle-all-3.5.jar”/> <target name=”checkstyle”> <checkstyle config=”${checkstyle.home}/sun_checks.xml” failOnViolation=”false” classpathref=”classpath”> <fileset dir=”${src.dir}” includes=”**/*.java”/> </checkstyle> </target> […]
0 0 Ever needed to update a sequence so the next value is greater than the maximum value of a table? Well, the quick and dirty ways are select SEQ.nextval from dual; (ever did this a million times?) drop sequence SEQ; create sequence SEQ start with MAX+1; (never had problems with grants […]
0 0 Introduction Last week I have been investigating the XML DB basic demo at OTN (http://www.oracle.com/technology/tech/xml/xmldb/9.2.0.2.0/index.html, Downloadable Demo). Unfortunately there is also a similar but older demo at http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html (Oracle9i R2 XML DB Demonstration). The demo shows a lot of XML DB stuff. It is quite comprehensive with a few installation […]
0 0 
