Blog

Create Table Definition : This statement creates a new/fresh table with various column or field names and respective datatypes in a database. Syntax : CREATE TABLE schema_name.table_name (column_name1 data_type1 column_constraint1, column_name2 data_type2 column_constraint2,    . . . table_constraints ); CREATE …

Click this link to know How to Uninstall Oracle 10g from Window 7/8.1/10.        Example : How to start/open oracle 10g from C-Command prompt/in MS-DOS ? Example : How to back at C-Command prompt/in MS-DOS from Oracle 10g …

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 …

Introduction DCL stands for Data Control Language. DCL statements are crucial for managing database security by controlling who has access to what data and what operations they can perform. Definition DCL statements are a collection of those SQL statements that …

Introduction of View View is a powerful feature of SQL that can significantly streamline our data management and querying processes. Definition View is a virtual table created using the CREATE VIEW statement from an existing table. Characteristics In SQL, a …

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 …

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 …