CREATE TABLE mina ( eesnimi varchar(30) not null, perenimi varchar(100) not null, sugu varchar(5) not null, synnipaev date not null, algus datetime not null default current timestamp, viimati datetime default timestamp, CONSTRAINT pk_mina PRIMARY KEY (eesnimi) ); INSERT INTO mina (eesnimi, perenimi, sugu, synnipaev) VALUES ('Juku', 'Mets', 'Mees', '1980-02-04'); grant connect to Sandra identified by 'tere'; grant group to dba; grant membership in group dba to Sandra; grant all on mina to Sandra; SELECT * FROM mina; UPDATE mina SET eesnimi = 'Jri' WHERE eesnimi = 'Juku'; CREATE GLOBAL TEMPORARY TABLE paha (nimi VARCHAR(40) NOT NULL, CONSTRAINT pk_paha PRIMARY KEY (nimi)) ON COMMIT PRESERVE ROWS; INSERT INTO paha (nimi) VALUES ('Mari'); SELECT * FROM paha; create table isik( Id integer not null default autoincrement primary key, Eesnimi varchar (50) not null, Perenimi varchar(50) not null, Isikukood varchar(11), Klubi integer, U...
--Taavet Tamm(a72028) --ylesanne 4. --1. Leida klubi Laudnikud liikmete nimekiri (eesnimi ja perenimi) tähestiku järjekorras. SELECT eesnimi, perenimi FROM isik, klubi WHERE klubi.nimi = 'Laudnikud' ORDER BY perenimi asc; --2. Leida klubi Laudnikud liikmete arv. SELECT COUNT(*) AS "Klubi Laudnikud liikmete arv" FROM isik WHERE klubi = '51'; --Leida V-tähega algavate klubide M-tähega algavate eesnimedega isikute perekonnanimed. SELECT distinct perenimi FROM isik, klubi WHERE klubi.nimi like 'V%' and eesnimi like 'M%' ORDER BY perenimi asc; --4. Leida kõige esimesena alanud partii algamise aeg. SELECT min(Algushetk) FROM partii; --5. Leida partiide mängijad (valge ja must), mis algasid 04. märtsil ajavahemikus 9:00 kuni 11:00. SELECT partii.ID AS "Partii ID", perenimi || ', ' || eesnimi AS "Nimi", isik.ID AS "Isiku ID", must, valge FROM isik, partii WHERE isik.id in (partii.must,partii.valge) AND partii.algu...
4 tegevdirektor - a Managing Cirector tootmisjuht - a Production Manager firma töötajad - employees at the firm kaadriülem - a group leader müügijuht - a Sales Manager tootmisinsener - a Production engineer 5 töökas, hõivatud kontor - working, busy office vastutustunne - responsibility algpalk - starting salary sõltuvalt east ja kogemustest - depending on age and experience edutamise väljavaated - promotion prospects kandideerima / soovi avaldama kohale - to apply for a post lisama väljavõtte kvalifikatsioonidest - to enclose an outline of qualification ma olen nõus proovima - I'm willing to try huumorimeel - a sense of humor võime hakkama saada - an ability to cope with (something) thuande krooni ulatuses - within rnge of võõrkeeled on eeliseks - foreign languages are an advantage kuulutus sekretäri kohale - an advertisment for a secretary teadmisi omandama - to obtain knowledge eelneva kontoritöö kogemus - a previous office experienc...
11.02.09 INGLISE KEEL Palju aega läheb. 10 nädalat aint. One of the ESP courses. What we are going to do, what is needed: · What we do - 1 test, on words. · 2 Essays, that means that we have to look into academic writing · Homereading we read a case from European Court of Justice thingy. · Oral thing. · 90% you have to attend · Have to prepare for class and take part of it etc What we learn: Terms Expressions / collocations (nt obey/abide by the law) Explaining AWOL absence without a leave Legal English can be divided into 3 levels. We learn the first one, which is needed for the other two! You have to know the vocabulary etc. Second level has to do with legal contracts... The third level both 1 and 2 and explaining... We learn the vocabulary + explaining. Process of law-making draft law/bill (seaduseelnõu) is developed draft is sent to the parl...
annaabi.ee 
