Created
March 18, 2017 09:08
-
-
Save efiku/62c27dd4f9f24422c1a2851f93d2d150 to your computer and use it in GitHub Desktop.
Cwiczenia laboratoryjne z PDB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT * FROM CZYTELNIK; | |
SELECT ID_WYP,DATA_WYP FROM WYPOZYCZENIA WHERE DATA_ZWR IS NOT NULL; | |
SELECT * FROM CZYTELNIK WHERE NAZWISKO LIKE 'N%'; | |
/* | |
SELECT TYTUL, DATA_WYP | |
FROM KSIAZKA | |
INNER JOIN | |
WYPOZYCZENIA | |
ON WYPOZYCZENIA.ID_KS = KSIAZKA.ID_KS; | |
*/ | |
SELECT TYTUL, DATA_WYD | |
FROM KSIAZKA | |
WHERE LENGTH( REPLACE(TYTUL, ' ' ) ) > 10; | |
SELECT KSIAZKA.TYTUL as TYTUŁ, KSIAZKA.CENA as "CENA KSIAŻKI", KSIAZKA.L_STRON as "LICZBA STRON" | |
FROM KSIAZKA; | |
SELECT NAZWISKO, IMIE, ID_CZYT | |
FROM CZYTELNIK | |
ORDER BY NAZWISKO ASC; | |
SELECT | |
ID_WYP, | |
ID_KS, | |
ID_CZYT, | |
TO_CHAR(DATA_WYP,'DD/MM/YY') as "DATA_WYPORZYCZENIA", | |
TO_CHAR(DATA_WYP,'DD/MM/YY') as "DATA_ZWROTU" | |
FROM WYPOZYCZENIA | |
ORDER BY DATA_WYP ASC; | |
SELECT * FROM KSIAZKA | |
WHERE DATA_WYD > to_date('01-01-2010','DD-MM-YYYY'); | |
SELECT ID_CZYT, | |
NAZWISKO, | |
IMIE, | |
KOD_POCZTOWY, | |
MIEJSCOWOSC, | |
ULICA, | |
TELEFON | |
FROM CZYTELNIK | |
WHERE MIEJSCOWOSC != 'KRAKÓW' | |
AND TELEFON IS NULL; | |
SELECT ID_AUT, | |
NAZWISKO, | |
IMIE, | |
NARODOWOSC | |
FROM AUTOR | |
WHERE | |
NARODOWOSC != 'Polska'; | |
--- | |
--- 4 rekordy | |
--- | |
SELECT | |
NAZWISKO, | |
IMIE | |
FROM CZYTELNIK | |
WHERE | |
substr(ULICA, 2,1) = 'O' | |
OR | |
substr(ULICA, 2,1) = 'I' | |
AND | |
LENGTH(MIEJSCOWOSC) = 8; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment