Amal Singh
Data Lakes Architecture
when we talk of data, it comes in various formats and structure and an administrator or so called the DBAs are there to manage. AS ... Read more
Why Truncate Command Is Not DML, But DDL
One of the most debatable topic, when we talk about some oracle command is TRUNCATE command. Let it be a tech discussion or even a ... Read more
Free Space Management In Data Segments of Oracle Database
Free space can be managed automatically inside oracle database segments. You specify automatic segment-space management when you create a locally managed tablespace. The specification then ... Read more
Overview of Extents
An extent is a logical structure of oracle database that comprises of the contigous data blocks. These logical storage units are stored in segments. Oracle ... Read more
Data Migration Architects
Any person looking for in-depth knowledge of Data Architecture or Data Migrators Architect, should also explore some of the terms like Business Intelligence, Data Warehouses, Enterprise Architecture, Application Architecture, Data Governance, Data Model, Single Instruction Multiple Data, Metadata . These terms are not covered in the article. ... Read more
Oracle Packages List
1765 Oracle provides inbuilt packages that can be used by developer/Programmer working on oracle Databases to generatePLSQL programs for various procudures. These packages are used in ... Read more
What is a View as Object in Oracle Views
View is an oracle objects that can be created by issuing a DDL "CREATE VIEW" Statement. A view can be basically defined as a projection ... Read more
How Truncate Differs With Delete
TRUNCATE TABLE is similar to DELETE, but theoritically it differ also its categorised as two indepandant categories of SQL Command DDL and DML. To understand ... Read more
How To Start SQLPLUS ( Oracle XE ) in Browser
Once you have installed Oracle XE. You can start using SQLPLUS either in Browser or even on command Prompt Following are the option 1. Browser based To start ... Read more
CRUD in Oracle Forms
To create a basic CRUD in oracle form for creating and updating data consider the following. This is not a tuned application, but a beginer ... Read more
Changes In Oracle 9i To Be Aware Of
Some Of The Changes Which Oracle Had stressed in its lower version have been finally implemented in the new release of 9i.The new features in ... Read more
Basic Cursor Writing In PLSQL Procedures
A cursor is a memory area allocated to work with select statements and is declared by a name.Need For CursorIn any PLSQL Statement which is ... Read more
What Is a Database Trigger in Oracle
Database triggers is a consist os sql and plsq statement which is executed on an predefined event.Database triggers are stored as a database object in ... Read more
Wait Events In Oracle
Every Oracle process at given given moment is involved in either a request or waiting for event to occur.And when we have a Term "busy" ... Read more
CALL_FORM built-in - Oracle Forms
121535Runs an indicated form while keeping the parent form active. Form Builder runs the called form with the same Runform preferences as the parent form. ... Read more
How some Training Institutes Misguide students
Some of the Most Common gimmicks and USP as an ad campaign in terms of banners , hoardings, classified, flyers by various training institutes existing ... Read more
Files that control oracle instances
Oracle database is comprised of a set of operating system files containing data entered by users or applications and structural information about the database itself ... Read more
Oracle Forms6i Configuration Post Installation
3743 Configuration Steps for Oracle Forms installation This file gives details of the configuration steps done for you by the installation process (marked '[INFO]') and of any actions ... Read more
Resolving Slow Client Server Architecture In Oracle
Resolving A Slow Client/Server Application By Increasing the array processing size If A client server application takes several seconds to bring up a certain screen ... Read more
Dont get misguided by Some Oracle Training Institutes
How some student are getting misguided by some oracle training institutes.Generally at any training Institutes Which Conducts the Training courses Custom or Predefined are conducted ... Read more