Comparing Table Structure in ORACLE

You can use below SQL Queries to compare two tables based on your requirement:   Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even...

ORACLE SQL Query Order of Operations

How ORACLE process the SQL Query? What is the SQL Query Logical Processing Order? Consider below Query clauses and understand how they get processed when executed in a form of a SQL Query:FROM JOINs GROUP by HAVING WHERE SELECT ORDER BY So, calculated SELECT columns...

Identify columns having all NULLs

There can be different ways and you can have a look on the below code will identify columns having all NULLs. Similarly, you can write it to Delete such columns from Table if you don’t want them in your table. Declare l_count Number; Begin For col In (Select...

ROWNUM Vs. ROWID

SELECT ID, ROWID, ROWNUM From EMP_TEST; ID ROWID ROWNUM 102 AAASd8AAEAAAAIcAAB 1 104 AAASd8AAEAAAAIcAAD 2 105 AAASd8AAEAAAAIcAAE 3 107 AAASd8AAEAAAAIcAAG 4 110 AAASd8AAEAAAAIcAAJ 5 103 AAASd8AAEAAAAIfAAA 6 106 AAASd8AAEAAAAIfAAB 7 108 AAASd8AAEAAAAIfAAC 8 109...

Portfolio Definition: Portfolio Actions Setup

Action (Portfolio Action) is a condition expression that determines how the Additional Column set up on the Additional Column tab (see above) will be populated.  Actions can be assigned to any node of the Portfolio at any level and may vary from one node to another...

Tabular Report

Tabular Report Writer allows you to define and execute snapshots of the enterprise’s transactional activity for a certain date and time. The Tabular Report module includes the following interfaces: Setup Report Generate Preview of the report Generate tabular reports...

FreeFormReport Viewer

         Fig.1a Click arrows to widen the filter pane (Fig.1a and Fig.2a)    Fig.2a    One of the most important functionalities of the FreeForm Viewer screen is Filtering. FreeForm Report Filtering functionality helps filter rows displayed on the Free Form...

Portfolio Definition: Aggregated Condition

At this point, when the reader is familiar with the principles of the Portfolio definition, we can expand on the subject of the Aggregated Condition that we briefly touched upon in the Logical Conditions section.  The aggregated condition allows setting up criteria...

Portfolio Definition: Logical Conditions Selection

Next step of the Portfolio Definition is stipulating conditions for the transaction selection. Conditions may be assigned to any node in the Portfolio structure including the Main (Portfolio) node. Conditions assigned to a node will determine which transactions will...

Portfolio Definition: Saving & Building Portfolios

When you press Save, the following events occur: 1. The system generates one column for each Portfolio level that you created on the Levels Tab. 2. The system generates a path_portfolio_name column where you will be able to trace the exact location of every record in...