//
archives

Archive for

A Short Guide to Oracle SQL [III] – DML & Transactions

Welcome to the third Part of SQL fundamentals. This part basically deal with DML statements and transaction concepts. Data Manipulation Language (DML) DML statements accesses or manipulate data in existing schema objects such as tables. The main difference between DDL and DML statements is whereas DDL changes the structure of database objects, DML used to … Continue reading

A Short Guide Oracle SQL [II] – DDL & Constraints

Welcome to the second Part of SQL fundamentals. This part basically deal with DDL statements and constraints. Describe a Table’s Structure Use the DESCRIBE [DESC] to get the structure of a table, view/data dictionary views or synonym etc. It’s a SQL*Plus command. DESCRIBE can be used on SQL Developer as SQL Developer supports many of … Continue reading