Archives
-
Fix for IE crash on launching forms in Oracle Applications 11i (11.5.10)
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. […]
Dec 9th, 2009 | Filed under Browser issues, Oracle, Oracle Applications, Oracle Applications DBA, Oracle Applications issues, Windows, Windows Clients, Windows issues -
PL/SQL quick reference
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
Jun 24th, 2009 | Filed under Database programming, Oracle, Oracle Database, Oracle developers, Oracle PL/SQL -
Oracle SQL Quick reference
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 […]
Jun 24th, 2009 | Filed under Oracle, Oracle SQL
Recent Comments