EXPLAIN PLAN statement displays execution plans for DML statements (SELECT, UPDATE, INSERT, and / or DELETE statements only).
Just a refresher for oracle substr () function, kind of busy now a days so I will not be able to write something new for some time....
First question first : Why do you need to convert date in a format with function ? Reason is simple and that is standardizing the date...
Situations where Oracle NVL2 Function is helpful. To manage in-accurate source data for ETL. To ensure either predicted or unpredictable ETL quality checks.Read more ›
25 Interview Questions – Informatica scenariosRead more ›
Oracle business Intelligence 11g (OBI 11g) Installation steps with screenshots
Environment Pre requisites
1. OBI is an engine based tool so as it require a database is required, does not necessarily have to be installed on the same server / computer.
Ok it is a typical scenario everyone who needs this information is new to either tool or team. And in both the case it is not possible to ask team members to help you as many of time they are not willing to because of some reasons. Sharing, this to all so it can be helpful for everyone who is first time in this situation.Read more ›