Hello guys, This is quite long back I am writing this post! In between there were many changes in everyone’s life. Perhaps we are standing rigid with the help of technology stuff. As working with one of the most leading investment banking in Africa continent, I am dealing with daily reports that Investment banks share Read More
Category: Programming
Few XML Helpers to deal in Typescript
Hi everyone here I am introducing some code to deal with xml data in javascript.
Creating a Pool out Timer in Javascript / Typescript
If you are stuck in pooling the request and need a timer just use these simple line of code. Just For typescript or if you are using ionic with dynamic loader, I created this to show message on loader Here loading:any; is a variable declared for loader.
Common challenges while using bulk collect and techniques to to deal with it
Bulk collects are nothing but select statements that retrieve multiple rows from single fetch into declared type known as collection. FORALL is INSERTS,UPDATES,DELETES that uses collections to modify rows very quickly. The terms SQL Engine and PLSQL engine are used to reference mainly bulk collects and quite confusing. In simple way when I declare a Read More
What are best practices while using data warehouse recovery methodology?
In data warehouses backup and recovery can be very crucial task when you have 100’s of terabytes of data. some of the best practices that can be implemented are using ARCHIVELOG mode. First of all what is the difference between ARCHIVELOG and NOARCHIVELOG mode In ARCHIVELOG mode oracle archives filled online redo log files before Read More
How to use SQL Access Advisor?
SQL Access Advisor suggests proper set of materialized views,partitioned tables,indexes for given workload. Complex tasks such as partition of an unpartitioned table needs a go through for access advisors. Here I will suggest how to use access advisor for each component. In case of views, as a virtual table does not hold any data. Every Read More
What are outlines and how these are used?
Outlines categories are nothing but group of hints associated with a particular SQL statement. Oracle chooses optimal execution plan on it’s own while executing. There comes a time when we want to preserve execution plan. That is nothing but I want an execution with /*+ xyz – – – */ this kind of hint only. Read More
Autonomous transactions benefits
An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions do SQL operations and commit or Rollback, without committing or rolling back the main transaction. For example, if you write auditing data to a log table, you want to commit the audit data even if the operation you are auditing Read More
What are moving data methods in oracle and how it works?
Here I will first load data using Sql * Loader utility and then by using external tables. Sql * Loader loads data from external files into tables of an oracle database.It has powerful data parsing engine that puts little limitation on format of data in data file. Read More
How to multiplex control files?
Control file is small binary file that describes the structure of database.It must be available when database is mounted or opened. Read More