I demonstrated a number of SQL approaches to reading object types in Appendix B of the Oracle Database 12c PL/SQL Programming book. For example, the easiest one to construct and return the results from a
TO_STRING member function uses the
SELECT TREAT(base_t() AS base_t).to_string() AS "Text"
However, it seems that I could have provided one more. Here’s an example of how you can (more...)
If you’re not using Toad DBA Suite, it’s sometimes hard to find solutions. Somebody wanted to know how to find indexes that aren’t that aren’t indirect. Indirect indexes are those created for a primary key because a primary key column or set of columns are both not null and uniquely constrained. You can’t drop a unique index for a primary key without dropping the primary key constraint that indirectly created it.
The following query (more...)
Oracle Database 12c introduces a
SEARCH_CONDITION_VC column to the
USER_CONSTRAINTS views. The
SEARCH_CONDITION_VC column is a
VARCHAR2 data type equivalent to the search condition in the
LONG data type
SEARCH_CONDITION column. Unfortunately, Oracle Database 11g and earlier versions requires you to convert the
LONG data type to a
VARCHAR2 for the equivalent behavior. This post provides you with a function to help you do that in (more...)
What happens when iPhoto doesn’t export movies? One of two things, you re-install iPhoto and risk losing the movies and photos; or you drop down to the Terminal level and move the files manually before re-installing iPhoto.
Option one is easy, you open iPhoto, choose File from menu, and Export… from the File menu list. When you get to the dialog, change it Kind value to original. If everything is working, you should be (more...)
I’ve been setting up a simplified lab environment to let my students learn use in class. This added content will show them how to do reverse engineering with MySQL Workbench.
It’s a complete Fedora image with MySQL and Oracle Database 11g for the course. The uncompressed image is 14GB and the compressed image is 5.3GB. I chose Fedora because it’s the smallest open source image that supports both environments, and Fedora is the closest (more...)
Somebody asked how to put PostgreSQL on my Fedora image with Oracle Database 11g and MySQL. It’s fairly simple. You can check for the current download at yum.postgresql.org and then download it like this as the
yum localinstall http://yum.postgresql.org/9.3/fedora/fedora-20-x86_64/pgdg-fedora93-9.3-1.noarch.rpm
You should see the following output when the download is (more...)
In Fedora 20, documents have no color coding when you edit them with
vim. That’s because Fedora installs
vim-minimal by default. You can check what’s running with the following command at a shell prompt in the terminal:
It should print the following to console:
You can download and install
vim with the enhanced version by using the following syntax:
sudo yum install vim-enhanced
The early release of Fedora 20 disallowed installation of MySQL Workbench but the current version allows it. Almost like Tom Cruise’s Edge of Tomorrow without the drama. All you need to do is follow my earlier instructions for installing MySQL on Fedora 20. I’d check your kernel to know whether it’s supported. You can check that with this command:
My Fedora is at the following version:
It seems the Oracle E-Business Suite stymies newbies. It’s complex and requires some research before you try to develop customization.
Having just fielded a question about how to manage, search, create and update customers for a third party order entry system, I was surprise that they didn’t know about Oracle’s Trading Community Architecture (TCA). They likewise didn’t know there was already a documented process, like this process defined in the Oracle Trading Community Architecture User (more...)
One annoying thing from installing Oracle Database 11g on Fedora, was that the up arrows for command history didn’t work. I decided to fix that today after seeing Lutz Hartmann’s article on
rlwrap. Unfortunately, the
epel (Extra Packages for Enterprise Linux) package he recommended doesn’t run on Fedora 20. You can read my tale of woe, or skip to the
.bashrc function that fixed it when I installed only
Attempting it on