Category: Data Base

Different types of Command in SQL

Different type of Command 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 Definition […]

Continue Reading

SQL Insert Command Different Types

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 […]

Continue Reading

Alter Command For Add Renaming Column

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”;

Continue Reading

Alter table Modify

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);

Continue Reading

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 customer_name; This Oracle ALTER TABLE […]

Continue Reading

Alter Command

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 […]

Continue Reading