Beginning Oracle Programming
0. Korice
0. O autorima
0. Uvod
1. Upoznavanje Oracla
2. SQL*Plus i osnovni upiti (deo 1.)
SQL*Plus i osnovni upiti (deo 2.)
3. Pravljenje korisnika i tabela i upravljanje njima
4. Novi uzorci šema u verziji 9i
5. Arhitektura
6. Obrada naredbi u Oraclu
7. Tabele
8. Indeksi
9. Ovladavanje SQL*Plus-om
10. PL/SQL
11. Procedure, funkcije i paketi
12. Transakcije i istovremenost
13. Bezbednost
14. Pogledi
15. Okidači
16. Objekti
17. Napredne tehnike upita
18. Alati za podešavanje
19. Skup SQL alata
20. Studija slučaja 1 - Pronalaženje i otklanjanje PL/SQL grešaka
21. Studija slučaja 2 - Pronalaženje osoba
22. Referentna lista SQL funkcija
23. Isporučeni paketi
24. Data Dictionary (Rečnik podataka)
25. Instalacija uzoraka šema
26. Opcije i funkcionalne osobine
27. JDBC
28. Indeks (knjige)
00. Rečnik (korišćen kod prevođenja)
NOTE:
PLEASE USE THIS MATERIAL HERE ONLY AS AN ADDENDUM TO THE ORIGINAL BOOK
IF YOU WANT TO TEST EXAMPLES IN ORACLE 10g OR HIGHER
This is working material produced during book translation and technical reviewing.
It does not match correctly and completely the contents and the formatting of the official published version.
The book was originally written for Oracle 9i in 2002.
There is no newer version of this book for Oracle 10g and higher.
But, the contents of the book is still valid and it is very good for learning.
In 2008. I reviewed all examples again and tested most of them in Oracle 10g.
I provide here sample schema used in book while necessary changes and comments are embedded in text.
So you can use this material to try examples from the book in Oracle 10g or higher.
English original
https://www.amazon.com/Beginning-Oracle-Programming-Sean-Dillon/dp/186100690X
Newer version
https://www.amazon.com/Beginning-Oracle-Programming-Experts-Voice/dp/1590592867/ref=dp_ob_title_bk
Serbian translation
https://www.knjizara.com/Od-pocetka-Programiranje-u-Oraclu-grupa-autora-21728