Regd. No Page No
Nota basc Mamaqement Dystonn (N6ms)
RBMS actuolly a tosl uwed to pufolun amy Kind
o t i n an a data
also proVisling amd eouil nol aetelusd
databaAc
ATAGASE Aitfrent types o database
My 892
OAacle
8MS
IBM
ysbasc
Micoboft access
S9L uct soed Gucy
language
PL/SOL Paograrmable dlaucteol guely
S9L Commanals are:
lamguog
Resc Descaile slsuctse tabk ksc idudent
howuseu: dhovs he cuurdemt se).
clsc: Ccas atn, E clears he SCeen
Connect. WcAnamme - aysten , baswosdayste
Rwn: eatcledd Hhe rufitd SIi commamd
Exit: Run amd come out o commomd
lbel to ac the envidon ment.
ota ype in $9
chan t stoves alpha neuenic data
VIGNAN'S INSTITUTE OFENGINEERINGFOR WOMEN:: VISAKHAPATNAMM
, Page No.
Regd. No
Vaachoh &9 one ag vaiohai2 indicolg number objech
umber: dhow dola om
ake dteies data seol fol dab bs
902 Copubiged inte 5 tp
AL - KWata denubon langage.
RML Aota Mamipnlato lomguae
3 RRL ata Retiural lomguage
4.CL Tsamacion oboling domgwoe
L Data contsolng lomguoge
OL Cala dekiritien kanguage)
The commamd e d to dine a able amol be
CSmmamd useol in AL ahe duale, ali , dbey
ncale
Che ATE
Syntan: Caua iabk Tabename lcolumnnare) dalalp)
data lyre Gizc)
Column namea datatye Csise).dlemnramt
Enommde
CLo lale eucernt (sid Voicha (to) snamt halio, sdept
dhar (),Smailid nauchal(so), ephtne rachar(io).
able Atotud
Syntom: cksc taename
Ey dese atudent
Altn:
columname
dyntan: ale Dablenome arld/modiy
altb tabe deudeng modiy dname- "PPPP
eg:
Whekt Sid =504
VIGNAN'S INSTITUTE OF ENGINEERING FORWOMEN: VISAKHAPATNAM
, Regd. No Page No.
byntont. all toke oldenomne add clumnome
&alty tase esudenty addlEdsáes vachal lo)
Isumcate
dyntan: omncat table tabename
e Toumcob tabe asenolen.
CREATNG TABLES
SQL Geoa tahe esuderty ( Sid vardhao Co), Snat chalid
Sdept chan (Y), Sail valcha Cio),Sphome numbe C1o)
Table cluabd
Sq1> ec dkudont
NAME NOLL2 . _TYe.
SiD
SNAME
VARCAARCIO)
cHARIO)
SDEPT
CHA RC)
SMALIPP
SP HONE VARCHARaIO)
NOM BER(10)
Sailos data
801-Goot tole Sailes Csid vachaCio), Snome chanl15),
hotimg rumbr lio), agc nunbrl 3)).
Tabe ceated
S l dhsc eailds;
NAMe TYPE
Sio VARCHAR(0)
SnvAME CHARC15)
RATN NUMBE RCI)
AGE NUMBERCO).
VIGNAN'S INSTITUTEOF ENGINEERING FOR WOMEN: VISAKHAPATNAM
Nota basc Mamaqement Dystonn (N6ms)
RBMS actuolly a tosl uwed to pufolun amy Kind
o t i n an a data
also proVisling amd eouil nol aetelusd
databaAc
ATAGASE Aitfrent types o database
My 892
OAacle
8MS
IBM
ysbasc
Micoboft access
S9L uct soed Gucy
language
PL/SOL Paograrmable dlaucteol guely
S9L Commanals are:
lamguog
Resc Descaile slsuctse tabk ksc idudent
howuseu: dhovs he cuurdemt se).
clsc: Ccas atn, E clears he SCeen
Connect. WcAnamme - aysten , baswosdayste
Rwn: eatcledd Hhe rufitd SIi commamd
Exit: Run amd come out o commomd
lbel to ac the envidon ment.
ota ype in $9
chan t stoves alpha neuenic data
VIGNAN'S INSTITUTE OFENGINEERINGFOR WOMEN:: VISAKHAPATNAMM
, Page No.
Regd. No
Vaachoh &9 one ag vaiohai2 indicolg number objech
umber: dhow dola om
ake dteies data seol fol dab bs
902 Copubiged inte 5 tp
AL - KWata denubon langage.
RML Aota Mamipnlato lomguae
3 RRL ata Retiural lomguage
4.CL Tsamacion oboling domgwoe
L Data contsolng lomguoge
OL Cala dekiritien kanguage)
The commamd e d to dine a able amol be
CSmmamd useol in AL ahe duale, ali , dbey
ncale
Che ATE
Syntan: Caua iabk Tabename lcolumnnare) dalalp)
data lyre Gizc)
Column namea datatye Csise).dlemnramt
Enommde
CLo lale eucernt (sid Voicha (to) snamt halio, sdept
dhar (),Smailid nauchal(so), ephtne rachar(io).
able Atotud
Syntom: cksc taename
Ey dese atudent
Altn:
columname
dyntan: ale Dablenome arld/modiy
altb tabe deudeng modiy dname- "PPPP
eg:
Whekt Sid =504
VIGNAN'S INSTITUTE OF ENGINEERING FORWOMEN: VISAKHAPATNAM
, Regd. No Page No.
byntont. all toke oldenomne add clumnome
&alty tase esudenty addlEdsáes vachal lo)
Isumcate
dyntan: omncat table tabename
e Toumcob tabe asenolen.
CREATNG TABLES
SQL Geoa tahe esuderty ( Sid vardhao Co), Snat chalid
Sdept chan (Y), Sail valcha Cio),Sphome numbe C1o)
Table cluabd
Sq1> ec dkudont
NAME NOLL2 . _TYe.
SiD
SNAME
VARCAARCIO)
cHARIO)
SDEPT
CHA RC)
SMALIPP
SP HONE VARCHARaIO)
NOM BER(10)
Sailos data
801-Goot tole Sailes Csid vachaCio), Snome chanl15),
hotimg rumbr lio), agc nunbrl 3)).
Tabe ceated
S l dhsc eailds;
NAMe TYPE
Sio VARCHAR(0)
SnvAME CHARC15)
RATN NUMBE RCI)
AGE NUMBERCO).
VIGNAN'S INSTITUTEOF ENGINEERING FOR WOMEN: VISAKHAPATNAM
