Run MySql without installation
Note: This applies to MySql version 5.7. See the comments section of this post for version 8.0. I have been...
SAP BusinessObjects Universe: Using ANSI92 SQL syntax
When writing SQL queries, I prefer the JOIN clause syntax over (+) in where clause for creating table joins. It...
BusinessObjects Universe: Defining Complex Outer Join
A complex join contains more than one condition in the join expression. Consider the following expression where one line of...
Designing BusinessObjects Universe: Join problems in schema and resolution techniques
An essential aspect of creating a BusinessObjects universe is to define joins among tables in ‘Universe Design Tool’. Even if the...
Chasm Trap: Designing SAP BusinessObjects Universe
While designing SAP BusinessObjects universe with Universe Design Tool, Chasm Trap is one of the major join problems that one...
Code Snippet: PL/SQL Cursor inside Procedure or Anonymous Block
DBMS_OUTPUT.PUT_LINE can be used to write to console. It works if server output is on: set serveroutput on size 30000;