Oracle Database DML Commands

Oracle Database Data Manipulation Language (DML) Commands: In this section, we will try to explain about important database DML commands that are used by a data modeler. Insert statements: Insert Values into GENDER_LKP: Insert statements are used to insert data into the table. In our example, we have used SYSDATE, an Oracle’s function, which is…

Read More

Oracle DDL Commands – Create Commands

Oracle Database Data Definition Language (DDL Statements) – Create Commands To execute Oracle database commands, you need Oracle’s username, password and oracle instance name to connect to oracle database. If you haven’t got the username, contact database administrator (DBA) and get the relevant privileges. When you are working with a client, you may be provided…

Read More

Database: Sample Data Analysis

Database: Sample Data With a simple example of designing a data model with ‘Employee related information’, most of the data structures can be easily understood. So we will try to design a data model using the sample data given below and will explain the data modeler’s involvement in the database environment. Sample Source Data: First…

Read More

Oracle Database Objects Overview

Oracle Database Objects Overview: A database can have many schemas; one schema can contain multiple database objects like tables, views, Synonym etc. A brief explanation on each of these Oracle database objects is given below. For more detailed explanations, please refer the official website of Oracle at www.oracle.com. Schema: This is also known as USER…

Read More

Database Overview

Database Overview: A database is a collection of organized and structured data, stored in the computer as files. Various data types like numeric, textual, image, multimedia etc., can be managed and maintained more efficiently in a database. Database Types: Database Management Systems (DBMS) Relational Database Management Systems (RDBMS) Object Oriented Databases Multidimensional Databases Often used…

Read More