This is an example of how you would upload data from a flat file,
or Comma Separated Value (CSV) file. It’s important to note that
in the file upload you are transferring information that doesn’t
have surrogate key values by leveraing joins inside a
MERGE statement.

Step #1 : Create a virtual directory

You can create a virtual directory without a physical directory
but it won’t work when you try to access it. Therefore, you
should create the physical directory first. Assuming you’ve
created a /u01/app/oracle/upload file directory on
the Windows platform, you can then create a virtual directory and
grant permissions to the student user as the
SYS privileged user.

This post shows you how to add the menu option and GUI to set
users and groups. It’s quite a bit easier than mastering all the
command-line syntax. It makes setting up the required user and
group accounts for an Oracle Enterprise or MySQL database
solution much easier.

You add the utility by calling the yum (Yellowdog Updater,
Modified) utility like this:

Sometimes I give parts of a solution to increase the play time to
solve a problem. I didn’t anticipate a problem when showing how
to perform a sort operation with a CASE statement.
It’s a sweet solution when you need to sort something differently
than a traditional ascending or descending sort.

I gave my students this ORDER BY clause as an
example:

CASE
WHEN filter = 'Debit' THEN 1
WHEN filter = 'Credit' THEN 2
WHEN filter = 'Total' THEN 3
END;

It raises the following error in MySQL for students:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY
CASE
WHEN filter = 'Debit' THEN 1
WHEN filter = 'Credit' THEN' at line 6

Last week, I wrote about how to use bash arrays and the MySQL
database to create unit and integration test scripts. While
the MySQL example was nice for some users, there were some others
who wanted me to show how to write bash shell
scripts for Oracle unit and integration testing. That’s what this
blog post does.

If you don’t know much about bash shell, you should
start with the prior post to learn about bash arrays,
if-statements, and for-loops. In this blog post I only cover how
to implement a bash shell script that runs SQL
scripts in silent mode and then queries the database in
silent mode and writes the output to an external file.

I’ve copied the basic ERD for the example because of a request
from a reader. In their opinion it makes cross referencing the …

This is the continuation of my efforts to stage an awesome Fedora
developer’s instance. It shows you how to install Java 1.8
software development kit, which is nice to have. Though you can’t
use Java 1.8 officially with Oracle SQL Developer 4.0.3
it is required for Oracle SQL Developer 4.1.
Fortunately, the Oracle Product Manager, Jeff Smith has advised
us that you can use Java 1.8 JDK with Oracle SQL Developer
4.0.3, and he’s written a comment to the blog post that it
runs better with the Java 1.8 SDK.

After you install Oracle SQL Developer 4.0.3 or
Oracle SQL Developer 4.1, you can watch Jeff Smith’s
YouTube Video on SQL Developer 3.1 to
learn how to use the basics of SQL Developer. I couldn’t find an
updated version of the video for SQL Developer 4 but I
didn’t try too hard.

Somebody asked me if there was a cheaper alternative to using the
Embarcadero Data Architect (a data modeling tool). I said sure,
you can use the MySQL Workbench. My friend laughed and said, it’s
to model Oracle databases and they use different data types. I
broke the news to him that he can create his own user defined
types and use MySQL Workbench to model problems for the Oracle
Database 11g.

For example, you can launch the MySQL Workbench, and click on the
Model menu option, and in the menu window click on the
User Defined Types choice, as shown in the following:

Choosing the User Defined Type option, launches the
following form. You can enter customized user defined types in
the User Defined Types module:

In teaching, I had a problem because my students have different
base operating systems, like Windows 7, Windows 8, Linux, and Mac
OS X. I needed a teaching and lecture platform that would let me
teach it all (not to mention support their environments). That
meant it had to virtualize any of the following with a portable
device:

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.