Experiment Date
Name of the
Experiment No. ....... .Experiment Result .. Page No.
(xea tabl employte Cenp-d, sat name, anton
SSLIeat tobl employee (emp-?d Dumbta idsame
(0), dof numbtasalay oumben, dap- fdLoumku
hable (aatd
sgLz oeac employees
AAME AlDLL2 NUMBR
ORST_NANME UAR(HIAR(20
|LASTNAME VARCHAR(o)
JOB_l VARCHAR(20
DOT AlUM6ER
NDMBER
|SALARY AUM8ER
DEPT-Do NUMBER
dalwslo0L, 'Ao, chow
SQLOnneut
Cay'io', ojan 2do0,25000, 2, 00)
C002,'Sandepfha
S9L Ta gest oto employee sdalns -PS.S.S.H.E
Experiment
Name of the Date
Page No.
Experiment No. Experiment Result
23000' 3, L00L)
Emp-To FNAME ANAME JoB-1D DOT SAA
syi >Tnott ioto employee valuslbo3, bhasath'.
|001 ANTA CHOJOARY:LO O-JAN-00 25000 2 (00| sloghui o3,'o1 MhH- 2000', 22000,5, 1001);
| o02SANDEEP SHARMA Ol- FEB- O0 2 300O 1001
l003BHARATH STNGHVT )(o3 SQL>însttt fnto nployze Valua(to0, Suoheel
shasma' so4Di- ÅpT-2o0a 2L00o, L, 1001)
22000 5 1001
t004 SUSHEEL SHARMA jo4 Ol- APR-00 20000 (001
|lo05 |SACHTN VERMAos O- MAY - 00 20000 100|
sgL>fraut Poto amplayee
20004
SL COMNAT
COMMTT cemput
-PS.S.S.H.E
RP
Experiment :..
Name of the Date:
ExperimentNo Page No.
Experiment Result :.
(ateo table
02
dlapastmant ldep ?d.,dupt namt
sQL uat tabu dpatmant [d fd oumbn,
dnam nyachaslao) maragmidoumbu)
Table Moatd
NAME ull2
DTD NUMBE
DNAME WARHA Rla0)
|MANA4ER10 AlDNMAER
SQL> frsent lote alepaskmugt yalusl 'Reseaub'
TO03)
14ou2 (20ato
rocut ato dpantrmot saluaC2, 'Admla
L002)+
nalunl,'Pxodmtbn
SqL > PnAut Poto alepast meot
-PS.S.S.H.E
Experiment
Name of the Date :
Experiment No. . Page No.
Experiment Result :.
sa L ott Roto dapatrmuntyalud4, salnio0s)
DEP- TO DNANE DMURTo
RESEARCH 4003 jaluss ls, "HP', 1001)|
2 (o2
ADNTN
SQL commit
3 PRODVCTTON
SALES (005 commit anpl
HR
-PS.S.S.H.E
RA
Experiment
Name of the Date
Page No.
Experiment No. .Experiment Result :..
leate a tabla customx Cust
rntname d,
lastoami, addeuas, (?ty.phonieYoi)
SAL> Aacile talble customsCust oumbt,
hiatnama daichans(a0, laat namA aHIhas(20),
addsus ahcban 2(20)city amchan2(ao)paone
42 92ulr tail natdhan 2o))
Table ceeated
AAME Null ? T9PE
NUMBER
P2ST-NAME VA2CHAR2(20)
LASTNAME VA2CHAR2(20)
ADDRESS VARCHARs(20)
JALLHAR2(20)
LPHONLE NUMBER
EMATL VARCHAR2(20)
SÙL > lnout ipto customsy vaus CoL, 'Anand, A
aBasangee22uSARAL, 'Bnand.a@jm
1 40u cH0atd
-PS.S.S.H.E
RA
Experiment Date
Name of the
Page No.
Experiment NO. ........ Experiment Resut
fPNagasbengalua
Com)
243568401, Saxautod .vgmai
cUST-FNAME NA- ADDR (ITY PHONE EMAL
ME
1234s67990
ANAND JAYA NAARA DAVANGERE lanand.a@grl
3456RQ02
102 ARAVIND V
JPNAuAR BENGALURU2345678401 lavavird v@grai
Com
O3 CANESH JC EXTN YS0RE 3456784012 lganb gagma SQL >fnstst foto cstoms valuslau, 'suRUDh 'a udya
com
gusesh. spgai.lony
'Tumke)u6 ¬R90123,
1O4 SURSHS VgDVA NA;AR TUMIUR 56189o23 Suush. s@ama
Con 1 94o uahol
D5 kSHOR k RAJATI
NAUAR
SHIMOUAS6184o1234 s678oi234a, Bibek@gmal
Com
custome
-PS.S.S.H.E
RA
Experiment
Name of the Date
Experiment No. ... Experiment Result :.. Page No.
Ceate a table
Aagada Cgade, highual, lousal)
SQL (acti toabl
pumben,leutal algrada
lnloenylgjuda numbin highsat
AAME AlIL? DYPE
GRADE NUMGER
H4HSAL AUMAER
dowsAL NUMBER
SQL >innut eoto alues ( 50000, 2G000)
SQL> Pooest ate salgiada alwsl2 4c0co, 20000)
SQ2> ingeHt lotonalgtado alwsl?, 30000, 1So0o
(Hoated
valwsls,25000, 19500)
-PS.S.S.H.E
Ma
RAMCO
14 Thursday
Week 11
Experiment :. Date
Name of the Page No.
Experiment Result
ExperimentNo.
palgad waus (s,90000,100oa)
LOwSAL L0u2 oathd
HTUHSAL
RADE
So000
2S00O
2000 O
Leromit toapld
3 3 000 O
1250 O
25 000
2000O 19000
-PS.S. S.H.E
AA
RAMCcO
14 Thursday
eek 11 Experiment :. Date
Name of the Page No.
.Experiment Result
Experiment No.
sth Tabl anal data oaog anotha
DOT SA pEP-TD MYR
Enp.o FNANE NAEJoB-î0 table
STNGHUTIo3
|O1-MAR-oo 2200o SQ> select em tmpayte whoa emp- J0033
t00 3 BHARATH
depid3
EMP-FNAMENAMEJOB-îD DOT SAL DE P-TD MURTD
(002 SANDGEP |SHA RDAJL0 2 O1- FEB-0o23000 3 100[ SGL upelali mplayee at sal 1Ñ000 wkstmp4
updatud
EMP-TD SAA
l004 18000
-PS.S.S.H.E -
RAMCO
14 Thursday
Week 11 Experirment: Date Page No.
Name of the
ANAME DNAME Experiment No. Experiment Result
FNANE
FNp_TO
BHARATHSINQHUÎ RESEARCH sQ abet Emp-fd, fnam, knami, nane
|00 3
Amployee dpttmant cha impd DMle
SANDEEP SHARMA ADMTN
|002
|004 SUSHEEA SHARMA |PRODUCT£ON
CHOLJDARy HR
Lowclulitd
J001 ANTL
EMP-FNAMELNAME JOB-0 DoT SAL DEP_TD
ANTL CHOODARy JIOI o-JAN00250o 0 2
100
1D02SANDEEP TI02 o-FEB-00 2 300o
(00(
1004 SÜsHEEL
SHAfMATI04 O|- APR-00 2 \000 I00
O0sSA CHTN
VERMATIOS o-MAY-00 20000
PS.S.S.H.E
