More than one foreign key between two tables?

This simple post was created based in a question from a friend who doesn’t know very well this Oracle’s characteristic. Can exist more than one foreign key between two tables?, here I show the answer with an example: Read more of this post

Installing and running SQL Developer on Ubuntu

In this post, I’ll show you how to install the SQL Developer on Ubuntu and how to run it; because there is a problem when you try to start the program, here I’ll show you how to avoid this error  too. Read more of this post

Changing the AUD$ table to another tablespace

Naturally, after an Oracle database installation, the AUD$ table stores the auditing activities and its the base for the DBA_AUDIT_TRAIL view, it’s placed in the SYSTEM tablespace.

According the audited quantity of actions and the quantity of users in the database, the AUD$ table can require too much tablespace space. And since the SYSTEM tablespace is very important for the Oracle database, that AUD$ growing can generate serious problems.

Here, I show you how to change the AUD$ table to a different tablespace. Read more of this post

Records concatenation

In this post I’ll show you how to concatenate records like columns, without any program, just a simple query. Read more of this post

Installing examples and HR schema

When you install the RDBMS, if you choose to create the database, you can choose the installation of the Oracle examples.

Here I’ll show you how to install the Oracle examples if you choose to install just the RDBMS without any database.

In these examples, there is a set of scripts to configure the HR schema with some objects to be used in any SQL or PL/SQL tests.

This is valid for the 11g version, the most mature right now. However, you must consider that there is the 12c version and will be more versions later. Read more of this post

Test values for RAW and BLOB columns

In this post, you will find an easy and quick way to insert test data in a RAW or BLOB column, without using the Oracle’s DBMS_LOB package for real file loading. Read more of this post

How to solve weird query results format

When you are using the SQL Plus and you want to copy the result to a tool like a text editor, you can obtain a result that doesn’t seems like in the SQL Plus:

TNAME                   TABTYPE    CLUSTERID
------------------------------ ------- ----------
DENSITY                TABLE
REVIEW                   TABLE
SOURCE                   TABLE
TARGET                   TABLE

Here I show you how to fix “this problem”. Read more of this post

%d bloggers like this: