Advices for applications based on ORACLE
1. Construct test cases and test scripts before you write your code2. Establish clear rules for how developers will write the SQL statements in the applicationSingle or multiple-row queries and inserts and updates should be "hidden" behind prebuilt and thoroughly tested procedures and functions which can be optimized, tested and mantained much more effectively by a SQL guru within team than SQL statements scattered throughout each developer's codes. 3.Establish clear rules for how dev