Oracle Database Data Definition Language (DDL Statements) – DROP Object Commands: In this section, we will try to explain about important database DROP commands that are used by a data modeler by relating it with our example data. Drop Index: DROP INDEX IND_SSN; Drop Synonym: DROP SYNONYM SYN_EMPLOYEE_DTL; Drop View: DROP VIEW VIEW_EMPLOYEE_DTL; Drop Sequence:…
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…
Oracle Database Data Definition Language (DDL Statements) – ALTER Commands: In this section, we will try to explain about important database ALTER commands that are used by a data modeler by relating it with our example data. ALTER TABLE – Add Column: ALTER TABLE EMPLOYEE_DTL ADD JOIN_DATE DATE; ALTER TABLE – Rename Column: ALTER TABLE…
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…
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…
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…
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…
