Thursday, April 19, 2007

Why understanding...

Why understanding matters.  I think many will find this interesting.  Interesting because of the ways to keep dependent data within a group that are demonstrated... and mostly interesting because of the implications of read consistency and the effect of that on recursive SQL (SQL executed on behalf of your SQL - in this case - SQL hidden in PL/SQL called from SQL)...

POST A COMMENT

1 Comments:

Anonymous Anonymous said....

It's pure evil I tell you.

You show someone some plsql and they learn a little about functions and stored procedures etc.

Then they want to start showing people they know some plsql and they start putting in function calls into sql.

Well we know ( and your example clearly shows ) how bad it is to try to use plsql when you can do it only in sql ...

But it happens again and again and ...

You would think peo0ple are actually trying to do things in oracle instead of reading all your books 3 or 4 times!

Thu Apr 19, 03:13:00 PM EDT  

POST A COMMENT

<< Home