Example : How to Start/open Oracle 10g/11g first time. Example : How to create new user in Oracle 10g/11g. Example : How to change/modify the current logged in user password in Oracle 10g/11g. Example : How to give administrator power to a newly created user in Oracle 10g/11g. Go to Read more…
DCL stands for Data Control Language. DCL statements are collection of those sql statements which are used to control security and concurrent access to the stored (table) data from the user in a database i.e. it functions like as authorization. In another words, it allows or restricts the user from Read more…
DML stands for Data Manipulation Language. DML is used to manipulate database data i.e. DML statements are the collection of those SQL commands which are used to store or save or insert, retrieve or search, modify or change or update, and erase or remove or delete data from the database as per Read more…
DDL stands for ‘Data definition language’. DDL is subset of SQL and is a part of DBMS. DDL statements are the collection of those SQL commands which are used to create and manipulate the structures of a database/schema i.e. they are used to create database objects like databases, tables, users, Read more…