Useful SQL commands
Useful SQL commands Here I used Table Name as " TechConnect " for all Query. 1. To Create Table:- > Create Table TechConnect (Name Varchar2(30), College_name Varchar2(30), Roll_no Number(15), D.O.B Date, Height Number(4,2)); 2. To Insert Data Into Table:- > Insert into TechConnect Values('Ram Kumar', 'ABCDE', 123001, '11-Jan-1994', 7.5); 3. To see items of table:- > Desc TechConnect; 4. To show whole data of a Table:- > Select * from TechConnect; 5. To select any Column > Select Name, College_name, D.O.B from TechConnect; 6. To save :- > Commit: 7. To Delete From Table (Row / Tuple):- > Delete from TechConnect where name = 'Ram Kumar'; 8. To Add extra Column in exist Table :- > Alter table TechConnect add (Dept Varc...