view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Building Your Own ORM

create view of_your_tables_so_it_is
of an_object
with object oid (your_relational_data) as
select
your_relational_data,
into_an_object_model
from your_relational_tables;
I'm not sure whether or not this approach is "better" than using Hibernate or other object-relational mapping tools.
At least you have a better idea how the mapping works by looking at the database I guess.
For further reading on this, have a look at <

SQL Book Club - Any recommendations?

I got a note from Steven Feuerstein the other day about a group of developers in Stockholm starting an SQL Book Club. What a great idea :-) Anyway, they had asked Steven if he had any recommendations for good books on Advanced SQL. And Steven asked me the same question...And now I'm asking the blog readers: Do you have any favorite books on writing Advanced SQL you can recommend to this new SQL Book Club?

SQL Brainteasers: Guess the Film Part 8

As always, when you think you’ve got answers, put them in the comments.

SQL Quiz: How can we fix this query – the answer

On Friday I asked how this query could be fixed without actually changing it:

MySQL Synonym?

Somebody asked how to create a SYNONYM in MySQL, which is interesting because MySQL doesn’t support synonyms. I thought the prior entry explained how to do it, but here’s a new post. However, you can create a view in one database that relies on a table in another database.

The following SQL statements create two databases and grant appropriate privileges to the student as the root superuser:

Personal Cloud Storage - Oh Yeah!

I hate advertising, but I sure do find the machinations and twisty-thinking of marketeers to be quite entertaining. Here's an especially delightful example:

SQL Quiz: How can we fix this query (without changing it)?

A quiz of a slightly different kind this time. The following SQL raises an ORA-01722 (invalid number) exception:
select *
from
this_simple_join tsj,
does_not_work dnw
where tsj.column_1 = dnw.column_1
and tsj.column_2 = dnw.column_2;

ORA-01722: invalid number

We can fix this so no error is returned without changing the SQL statement itself. How is this possible?
Put your answers in the comments! I’ll post my full solution on Monday.

Justify, a poem

Justify

by Steven Feuerstein, 2013

I should not be here.
I should not be.

Too many humans
devouring the world.

I would leave
to save a single tree
or to ensure
a fern leaf unfurled.

But I'll stay, instead,
and switch allegiance
from a genocidal species
to my planet, my home:
my home of surpassing beauty.

If I stay, instead,
and save a single tree
and help tree ferns
unfurl their leaves,
perhaps I could at least
justify
this poem.

APEX Tree based on Pipelined Table Function

Representing hierarchical data in an APEX Tree is fairly straight forward, the wizard to create a tree region assists you with that. But when you need to show data from multiple tables, you will need to provide your own query. In a previous blogpost I have written how to achieve that.
It is also possible to create a Pipelined Table Function which can be used a the basis of the APEX Tree. In this blogpost I will show you how to do that.
The first that we will need are some Type definitions, starting with the Object Type:

Loey Goes to Youtube!

I finally got around to posting some videos of Loey on Youtube. Enjoy!

view counter