Invoking SQL loader from UNIX for multiple files
Overview This document says about how to load multiple data files with csv format using sql loader from UNIX and also explains about control file and database connection through Linux.…
Read MoreQualified Expressions for Associative Array
Overview This document talks about how Qualified Expressions for Associative Array works before and after the oracle 18c version. Technologies and Tools Used The following technologies has been used to…
Read MoreUPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD
UPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD LOG INTO THE DATABASE AND MAKE SURE THE CORRECT ORACLE HOME HAS BEEN SET. CHECK STATUS OF ARCHIVELOG MODE IN…
Read MoreMICROSOFT WINDOWS 19C DATABASE CREATION
STEPS TO CREATE 19C DATABASE IN MICROSOFT WINDOWS STEP…
Read MoreGENERATING RANDOM NUMBERS IN OUTSYSTEMS
OUTSYSTEMS: Outsystems is an excellent and rapid Application Development platform for mobile and web-based applications. Outsystems is a low-code programming system which run in cloud, on premises and in hybrid environments.…
Read MoreScript to create trace at database schema level by using trigger
Please create the below and disable or drop the trigger once completed. create or replace trigger set_trace after logon on database begin if user not in (‘SYS’,’SYSTEM’,’SYSMAN’,’OLAPSYS’) then execute…
Read MoreHow Oracle Cloud Infrastructure Powers Fusion Applications?
Businesses are finding innovative ways to use Oracle Cloud Infrastructure (OCI) every year to foster innovation and development. This year is no exception, with Oracle releasing a plethora of new…
Read MoreBLOCK STRUCTURES OF PL/SQL
INTRODUCTION: PL/SQL stands for Procedural Language/Structured Query Language. PL/SQL offers a set of procedural commands (IF statements, loops), organized within blocks, that complement and extend the reach of SQL. PL/SQL is…
Read MoreMigrate to Oracle Cloud Database within “1-Click”
Introduction: Oracle provide a tool called MV2OCI(Move to Oracle Cloud Database) and it is a new tool is permitting the load data and migration from “on premises” to Oracle Cloud…
Read More11G to 19c autoupgrade failled with ORA-00904 Error
Introduction: During 11.2.0.4 database upgrade to 19c, Autoupgrade fails with error – NVL(bundle_series,’0′)||’#’|| * ERROR at line 3: ORA-00904: “BUNDLE_SERIES”: invalid identifier ] [ORCL] – ExecuteSql$SQLClient.run NVL(TO_CHAR(action_time, ‘DD-MM-YYYY HH24:MI:SS’),’0′) ||’#’|| NVL(action,’0′)||’#’||…
Read More