Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- izmena tabele, dodata kolona
- ALTER TABLE faze_projekta
- ADD(datz DATE NOT NULL);
- -- brisanje tabele
- DROP TABLE faze_projekta;
- -- dodavanje nove n-torke u tabelu
- INSERT INTO radnik VALUES (250,'Stefan','Stefanovic',NULL,150000,1000,'28-7-1980');
- INSERT INTO radnik VALUES (260,'Bozo','Bozovic',250,100000,1000,'30-5-1966');
- -- brisanje postojećih
- DELETE radnik WHERE mbr = 260;
- -- modifikacija postojećih ntorki
- UPDATE radnik
- SET plt = plt*1.2;
- UPDATE radnik
- SET plt = plt*1.5
- WHERE mbr = 200;
- -------- UPITI --------
- -- sve kolone iz jedne tabele
- SELECT * FROM radnik;
- -- pojedine kolone
- SELECT ime, prz
- FROM radnik;
- -- samo različita obeležja
- SELECT DISTINCT ime
- FROM radnik;
- -- uslov selekcije
- SELECT mbr, ime, prz
- FROM radnik
- WHERE plt>25000;
- -- aritmetički izrazi
- SELECT mbr, ime, prz, plt*1.2 AS "povisica"
- FROM radnik;
- -- NULL vrednost
- SELECT mbr, ime, prz
- FROM radnik
- WHERE sef IS NULL;
- -- Between
- SELECT mbr, ime, prz, plt
- FROM radnik
- WHERE plt BETWEEN 24000 AND 30000;
- SELECT *
- FROM radnik
- WHERE god NOT BETWEEN '01-1-1953' AND '31-12-1975';
- -- like, uslov izgleda
- SELECT mbr, ime, prz
- FROM radnik
- WHERE prz LIKE 'M%';
- SELECT mbr, ime, prz
- FROM radnik
- WHERE ime NOT LIKE 'A%';
- SELECT mbr, ime, prz
- FROM radnik
- WHERE ime LIKE '_a%';
- SELECT mbr, ime, prz
- FROM radnik
- WHERE prz LIKE 'E%' OR prz LIKE '%e%';
- SELECT DISTINCT ime
- FROM radnik
- WHERE ime LIKE 'E%';
- -- IN
- SELECT DISTINCT mbr
- FROM radproj
- WHERE spr IN (10, 20, 30);
- SELECT mbr, ime, prz
- FROM radnik
- WHERE ime IN('Ana', 'Sanja');
- -- sortiranje, order by
- SELECT mbr, ime, prz
- FROM radnik
- WHERE sef IS NOT NULL
- ORDER BY prz;
- -- prvo po prz, pa onda po ime
- SELECT mbr, prz, ime, plt
- FROM radnik
- ORDER BY prz ASC, ime DESC;
- -- po koloni koja je predstavljena brojem
- SELECT mbr, prz, ime
- FROM radnik
- ORDER BY 3;
- -- preimenovanje kolone za prikaz
- SELECT mbr, prz, ime, plt PLATA
- FROM radnik
- ORDER BY PLATA DESC;
- -- uredjenje izlaznih rezultata
- SELECT mbr, ime || ' ' || prz "Ime i prezime", plt*1.18 Plata
- FROM radnik;
- -- ANY - makar jedan od (neka vrsta ili)
- SELECT mbr, ime, prz, plt
- FROM radnik
- WHERE ime = any('Pera', 'Moma');
- -- ALL - ispunjava sve (ili nijedan ukoliko !=)
- SELECT mbr, ime, prz, plt
- FROM radnik
- WHERE ime != ALL('Pera', 'Moma');
- -- skupovne funkcije
- SELECT mbr, plt + NULL
- FROM radnik;
- SELECT mbr, plt + pre
- FROM radnik;
- -- NVL - zamena null vrednosti
- SELECT mbr, plt + nvl(pre, 0)
- FROM radnik;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement