More from Amol

Page 1 :
1. Create table is used to create the table in database, Create Table <Table_Name>(Column1 Datatype,Column2 Datatype,Column3 Datatype);, Create Table DBMS_EMP_TEST(Empid char(6),Empname Varchar2(50),Salary number(7,2),Address, Varchar2(1000),DOJ date);, Describe DBMS_EMP_TEST;, Desc DBMS_EMP_TEST;, ================================================================================, 2.Alter table is used to add or drop or modify columns in existing table., adding the column, ALTER Table <Table_Name> ADD Column1 datatype;, ALTER Table DBMS_EMP_TEST ADD Department Varchar2(20);, ================================================================================, Modifying the column, ALTER Table <Table_Name> Modify Column1 new_datatype;, ALTER Table DBMS_EMP_TEST Modify Department Varchar2(25);, ================================================================================, Dropping the column, ALTER Table <Table_Name> DROP Column1;, ALTER Table DBMS_EMP_TEST DROP Department;, ================================================================================, 3.Truncate table is used to delete whole rows of the table.The structure remains as it is.You can add new, data to the table again., Truncate Table <Table_Name>, Truncate Table DEPT0;, ================================================================================, 4.DROP table is used to delete the table with rows.The structure does not remains.You need to create the, table again., DROP Table <Table_Name>, DROP Table DEPT0;, ================================================================================, 5.Rename table is used to rename the old table name to new table name., Rename old_table_name to new_table_name;, Rename DBMS_EMP_TEST to DBMS_EMP_TEST1;, ================================================================================, 6.Insert the new rows in table: