Ora Training Blog

Many of you would have noticed that while launching forms from Oracle Applications 11.5.10 using Internet Explorer (IE 7) then it might crash with following error. Though it may work perfectly fine in mozilla firefox. This is the working fix for the issue. Solution-1: 1) Take backup of jvm.dll located at c:Program FilesOracleJInitiator 1.3.1.21binhotspot directory. […]

Oracle PL/SQL Quick Reference   PL/SQL Block Structure DECLARE –Optional   –Variables, Cursors, User-defined exceptions BEGIN –Mandatory   –SQL statements   –PL/SQL statements EXCEPTION –Optional   –Actions to perform when errors occur END; –Mandatory

Oracle SQL Quick Reference SELECT Query Statement SELECT [DISTINCT] {*, column [alias],…} FROM table WHERE condition(s)] ORDER BY {column, exp, alias} [ASC|DESC]] NOTE: Avoid using DISTINCT with large table as it first does sorting of all the rows and then eliminates duplicate rows, so need a full table scan and thus it’s very slow. ORDER […]