Data Base

Different types of Command used in Structural Query Language(SQL)

Posted on

Different type of Command used in SQL basically categories by their functionality. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.The following are the different types of command. The main categories are DDL (Data […]

Data Base

SQL Insert Command Different Types

Posted on

SQL Insert Command Different Types Different type of SQL command are used to perform same operation  need to use at different time as per our requirement.We can use them in the next example  we are going to create a table name as TEST and heaving the following command. Create Table command CREATE TABLE TEST(ID NUMBER(10),NAME […]

Data Base

Alter Command For Add Renaming Column

Posted on

Alter table command is used to modify the table structure we can add a column or modify column. Syntax ALTER TABLE table_name ADD column_name datatype eg-alter table test add mobile number(10); Modifying a column Syntax ALTER TABLE “table_name” RENAME COLUMN “column 1” TO “column 2”;

Data Base

Alter table Modify

Posted on

This command is used to alter table existing data type.By giving this command we can change the parameter of  an  table. ALTER TABLE table_name  MODIFY column_name column_type; alter table emp modify id number(20);

Data Base

Alter Table Drop A Column

Posted on

Syntax To DROP A COLUMN in an existing table, the Oracle ALTER TABLE syntax is: ALTER TABLE table_name  DROP COLUMN column_name; Example Let’s look at an example that shows how to drop a column in an Oracle table using the ALTER TABLE statement. For example: ALTER TABLE customers  DROP COLUMN customer_name; This Oracle ALTER TABLE […]

Data Base

My SQL Alter Command

Posted on

Alter Table Drop A Column Syntax To DROP A COLUMN in an existing table, the Oracle ALTER TABLE syntax is: ALTER TABLE table_name  DROP COLUMN column_name; Example Let’s look at an example that shows how to drop a column in an Oracle table using the ALTER TABLE statement. For example: ALTER TABLE customers  DROP COLUMN […]