We would initiate the job by creating a VM on the base windows machine, the installation of Oracle / linux remains same with installation on base machine other than VM part. Please follow the steps as specified in the image any explanation if required, that would be available at the bottom of the image.…
1. Pluggable Databases through Database Consolidation: Oracle is doing everything to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database architecture through the introduction of Container Databases also called CBD and…
FNDLOAD is an Oracle utility that allows for the transfer of a wide range of Oracle Foundation (FND) data from one instance to the other. The loader reads a configuration file (LCT) to determine what data to access. It works by downloading the data in the source instance into a text file (LDT file)…
FND SRWINIT: FND SRWINIT sets your profile option values and allows Oracle AOL user exits to detect that they have been called by a Oracle Reports program.[Before Report trigger, P_CONC_REQUEST_ID lexical parameter]. We should always call FND SRWINIT from the Before Report Trigger SRW.USER_EXIT(‘FND SRWINIT’); FND SRWEXIT: FND SRWEXIT ensures that all the memory allocated…
XML Publisher patch has to be installed in your machine before developing xml publisher Reports. Please check the blog post for installing the XML publisher desktop patch: http://oracleapps4u.blogspot.com/2011/04/installing-oracle-bi-publisher-xml.html Steps for Developing XML Publisher Reports Create a RDF Report and register it as Concurrent Program of Format type “XML” Build a Data Definition & XML…
SQL is divided into the following :- Data Definition Language (DDL) Data Manipulation Language (DML) Data Retrieval Language (DRL) Transaction Control Language (TCL) Data Control Language (DCL) DDL – Create, Alter, Drop, Truncate, Rename DML – Insert, Update, Delete DRL – Select TCL – Commit, Rollback, Savepoint DCL – Grant, Revoke DRL COMMANDS CREATE TABLE Syntax: Create table <table_name> (col1 datatype1, col2 datatype2 …coln datatypen); Create table XXSTP_EMP_DETAILS…