14_yl
lesanne
1-------------------------------------------------------------------------------
--
sqlplus scott/tiger@testdata
describe kandidaadid
insert into kandidaadid values
('Stanislav',
'Tsvetajev',
'38609140224',
60,
70,
80);
update kandidaadid set eesnimi='Stas' where isikukood=38609140224;
select
*
from
kandidaadid
where
eesnimi = 'Stas';
delete from kandidaadid where eesnimi = 'stas';
lesanne
2-------------------------------------------------------------------------------
--
sqlplus scott/tiger@testdata
select
eesnimi,
perenimi,
emakeel
from
kandidaadid
where
isikukood
like
'4%'
and
annaabi.ee 
