DISQUS

Eddie, the hint to the 'Doing SQL from PL/SQL: Best and Worst Practices [PDF]' is great!!
Very interesting Document about effective Oracle PL/SQL 11g programming

Karl

The should have called it CLIENT_DATE it's the date where the Client operates :-)

timestamps has another disadvanatge if you import (imp) data on a table with a timestamp, it's not loded bulk but row per row. that's what i experienced on 10.2;

if a sysdate should be used or not could be depend on businesss rules. For example using ebay a sysdate should used to store your transaction to be able to compare it against other competitiors

cheers
Karl

It seems TOAD is well designed for Cinema XXL Displays ;-)
Karl

Ohh!
Iike this point very much : The last book you read: Oracle 8i A Beginner’s Guide.

it helps not to run into new errorful features!!
And you are compatible to almost all database releases!!! :-)

And : Developers are not responsible for any testing

The opposite is dangerous too. If the future user group of the system does not test and only developers do.

Karl

Hi,
i think it's a question of the scope; You need documenation outside of the code to get the whole picture and to be able to deliver your business rules/requirements to others.
In more detail the commented code tells you how the aspects of the Business requirements are implemented. Two different focus of ducumentation.

Karl Reitschuster

oh!
this was new to me the differnet behavior of a searched case expression and a statement.
Great
Karl

Raising NO_DATA_FOUND on subscription error. It seems the developers were not busy enough to create an own out_of_bound exception for it

Karl

Hi Eddie;
used it today the first time!
Karl

The picture could also have the tilte 'Ways to show Respect to Nature'
;-)

never forget the good site of lazyness;
a lazy dba does not manually repeat a way again and again. He will find a way to automate it.

One major reason i create solid structured reliable code is that i am to lazy walking throug spaghetty code.

Karl
very lazy dba and database architect.

good tip Eddie!
Karl

It's good to look at the documentation but the weak point of it is to find for example special snytax for local indexes or even worse what's the default if i create an index on a partitioned table? is it LOCAL or GLOBAL?
i searched too long for this important point (looked at the user_ind_partitions to find the answer);

LOOK at he create table clause it's remembers me on a SQL statement with > 100 NESTED LOOPS in the plan.

hard to find the right stuff.

but I still like to search in the manual specially the 10.2 search ist great.

Karl

I do not use ANSI Joins; still keeping the oracle syntax of joins.
We have a UNION constellation in germany now. the lefts and the rights are doing their job together. So this is not a social effect;-)
Karl

Hi,
one reason woman do not work in it based environment could : 'woman take care more for the real world aspects' ;-)

I work as an external (CSC) at Commerzbank AG and i am suprised how many women i meet in teams.
And this is a good thing
Karl

... There are other Oracle bloggers that deserve recognition more than I do. I’m sure they will be sooner or later.

I do not aggree Eddie ;-)
Karl
Your Blog is concentrated on oracle stuff and the kind of publishing and investing for example in other sites is unique. Your serverd the Oracle community successfully.
So in this case Oracle made the right choice ;-)
Karl

Great Eddie!
and finally a nice picture from you.
Karl

Hi Eddie,
i rememeber 15 years ago i took my second child, julian, home and i thought in my car - now you have two children but not double time! But it worked!
I wish You and Your wife and Your childs everything good and an impressing time at home.
Keep growing in fathership.

god bless your family

Karl

Totally aggree with Eddie,
Steven was always hot in the politic things too - specially when he felt the need to fight against unrighteousness;

Karl
Germany

go on Steve and check out what is real ans waht not!
Karl

Don't Repeat Yourself
Hi Rob, this is a sub rule of point 3 ;-)
Karl

Hi Eddie, i always think i could add something to your points but the are complete :-(
Karl

Interesting i played with the slr stuff. even when i took 'slr digital 9-11megapixel $900-$1300 always canon EOS 350 was on top and not my fvaourite NIKON D80. Playing with these paramters then lead me to a never seen google message :

'We're sorry...
... but your query looks similar to automated requests from a computer virus or spyware application. To protect our users, we can't process your request right now. '

Very interesting google hacking tips!! ;-)
Karl

Hi,
i searched for ~car

and found http://www.bmw.de/ as first link!
funny
Karl

done!
karl

Hi Eddie thanks for this,
i can earn 20-40% more in canada or USA; So i will leave germany going to canada or USA and buy a big big truck!
,-)
karl