Amal Singh

total: 25 | displaying: 1 - 20

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

total: 25 | displaying: 1 - 20