I was asked by our APEX developer whether or not some fields of the tabular form created by wizard, except on a new row when “Add Row” is clicked, can be made read-only. This is a part of business requirements that the existing parameters should not be modified by end users. I started searching for …
Read-only fields on APEX tabular form except on a new row Read More »
Our organization just started looking into upgrading all older versions of database including 9i. Definitely one of many business justifications for upgrade is to avoid de-supporting from vendor. I recently looked into Oracle’s support policy and did not realize that it offers the lifetime support policy on its entire technology stack, from database to middleware …
I just read a good whitepaper titled “For Developers: Making Friends with the Oracle Database” by Cary Millsap. Cary makes an excellent point that most developers think of database as a black box. However, by progressively understanding Oracle kernel little by little, they can improve performance of their queries dramatically. I appreciate the way Cary …
Good whitepaper “For Developers: Making Friends with the Oracle Database” Read More »
I found this tip from forum discussing about Oracle’s reserved words. You can use it to quickly view reserved words for both SQL and PL/SQL. SQL> help reserved RESERVED WORDS (PL/SQL) ———————– PL/SQL Reserved Words have special meaning in PL/SQL, and may not be used for identifier names (unless enclosed in “quotes”). An asterisk (*) …
Ubiquity is the FireFox extension allowing you to perform tasks including wiki, map, dictionary, etc., while still staying on the same web page (instead of having to jump around pages). Even though it is still in version 0.1.x, there is a quite number of commands (at Ubiquity Herd and Ubiquity In The Wild) being developed …
