Open Source Database

TABLE OPERTION---ALTERING STRUCTURE ·          Introduction ·          Renaming a table ·          Adding column to a table ·          Removing column from a table. ·          Increasing width of a columns. ·          Decreasing width a columns. ·          Changing data types of a columns. ·          Copying of a table. Introduction:- Let us turn our focus on modifying the existing structure of table. By structure we means column names, data types and constrains. Renaming a table:- Now change the table name COLLAGE TO COLLAGES. SQL> select * from collage; COLLAGE           ...

                             SORTING ·          Introduction ·          Sorting on single columns. ·          Sorting on multiple columns. ·          Sorting on a columns with null values. ·          Combining WHERE and ORDER BY clause. ·          Sorting on DATE columns. INTRODUCTION:- Sorting refer to arrange record in a specified sequence may be alphabetically or by values. This sorting can be achieved by the ‘ORDER BY’ clause of select statement. SORTING ON SINGLE COLUMNS:- SQL> desc collage;   Name                      ...