create view of_your_tables_so_it_is
with object oid (your_relational_data) as
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 <
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?
As always, when you think you’ve got answers, put them in the comments.
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
A quiz of a slightly different kind this time. The following SQL raises an ORA-01722 (invalid number) exception:
from this_simple_join tsj,
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.
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
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:
I finally got around to posting some videos of Loey on Youtube. Enjoy!