I’ve been looking for a way to help my kid learning computer programming. My daughter and I tried out the trial version of “Phrogram” which is listed in the top hits when googling for “kid programming”. It is nice, well-made and powerful by just looking at provided samples. Its look & feel and language look …
One of the cool things about Oracle APEX is ability to embed HTML tags into everything you could display. This includes simple HTML tags like Add a break Employee<br>Name Add color <font color=”#FF0000″>Employee Name</font> Or more complex one like – Rotate 90 degree vertically (work with IE only) <div style=”writing-mode: tb-rl”>Employee Name</div>
The Oracle SQL developer is not only a great tool for SQL development, with its migration workbench, it is an excellent tool for database migration. Did I also mention it is free? To get it started, you will need to download the latest version of the tool which is version 1.5.1. Also it is recommended …
Currently I’m working on a project dealing with lot of statistic calculations particularly that of quartiles. First, I have no idea what it is. Thanks to Wiki for explanation. Now the tough part is to do the actual calculation. Fortunately, Oracle provides DBMS_STAT_FUNCS which is exactly what I’m looking for. List of available calculations – …
In 11g SQL*Plus, when session is terminated, somehow it displays the process ID, SID and Serial#. Not quite sure what is really for? I guess it is for debugging purpose. 10g Client user @db10w1> select * from dual; select * from dual * ERROR at line 1: ORA-01012: not logged on 11g Client user @db10w1> …
I found one of the interesting features in SQL*Plus 11g for Oracle11g database when doing “help show” from the tool. SHOW SPPARAMETERS [parameter_name] Show specific parameters – SYSTEM @db11r1> show spparameters sga SID NAME TYPE VALUE ——– —————————– ———– —————— * lock_sga boolean * pre_page_sga boolean * sga_max_size big integer * sga_target big integer Show …
