Archive

Archive for the ‘PL/SQL’ Category

Read OS environment variables using DBMS_SYSTEM.GET_ENV()

March 27th, 2009
5 comments

Check out this article by Vikram Das about how to read OS environment variables using PL/SQL.

I did not know that!

  • Share/Bookmark

Tanel Poder Cool stuff, Oracle, PL/SQL

Excellent article on Oracle 11g PL/SQL function result cache

February 3rd, 2008
No comments

I have so far avoided writing such pointer blog posts which only refer you to another article, but I have to do it with this one. Adrian Billington has written an excellent article on performance of Oracle 11g PL/SQL function result cache. His article is a good example of a thorough, well organized and well written technical content. I really enjoyed reading it and thanks to his thoroughness, he has just saved me some precious time doing that research on my own.

Get the article here: http://www.oracle-developer.net/display.php?id=504

  • Share/Bookmark

Tanel Poder Oracle 11g, PL/SQL, Performance, SQL