http___www.knjiga.ba_racunari_programiranje_oracle-10g-pl-sql-programiranje-k0624.html_1.xml
1.1 2.1 3.1 4.1 6.1 7.1 9.1 10.1 11.1 11.2 12.1 12.2 13.1 14.1 14.2 15.1 16.1 17.1 18.1 19.1 20.1 21.1 22.1 22.2 22.3 22.4 23.1 27.1 31.1 32.1 33.1
Learning Oracle PL/SQL Publisher: O'Reilly Media Keywords: oracle, learning Pages: 450 Language: English Category: Oracle, Databases, Computers & Internet, Binding: Paperback (1) List Price: 49.99 USD PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. Topics include: - PL/SQL--what is it, and why use it? Why use PL/SQL instead of Java? - Syntax and examples of all core language constructs - Creating, using, and reusing stored procedures, functions, and packages - Building web-based applications using PL/SQL features available "out of the box" (such as PL/SQL Server Pages) - Securing PL/SQL programs against attack - Benefits of third-party developer tools and integrated development environments - Connecting PL/SQL to email, Java, and the Internet Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i. Learning Oracle PL/SQL was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O'Reilly books (such as the bestselling Oracle PL/SQL Programming) very popular among Oracle developers worldwide. Learning Oracle PL/SQL is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein. - Export Citation(BiBTeX, EndNote, RefMan) - Download multimedia files (txt, html, PDF) - Learning_Oracle_PL_SQL.pdf - 0596001800.zip (currently not available) You can search on LeatherBound to download or purchase an ebook.
1.1 2.1 2.2 2.3 2.4 3.1 4.1 5.1 6.1 7.1 8.1 9.1 10.1 11.1 12.1 13.1 14.1 14.2 14.3 15.1 16.1 17.1 18.1 19.1 20.1 21.1 22.1 23.1 24.1 25.1 26.1 27.1 28.1 29.1 30.1 31.1 32.1 33.1 34.1 35.1 36.1 37.1 38.1
Detalji Napravite dinamičke klijent/server aplikacije koristeći PL/SQL i obimne informacije koje ćete pronaći u ovoj knjizi. Stručnjaci za Oracle opisuju osobine PL/SQL-a, objašnjavaju semantiku i sintaksu pitanja skripta i detaljno objašnjavaju funkcionalnost PL/SQL-a baze podataka Oracle 10g. Naučićete kako da napravite moćne PL/SQL programe, komunicirate sa bazama podataka Oracle, obavljate složena izračunavanja i obrađujete greške. Osim toga, dobićete savjete za programiranje i tehnike koje možete upotrijebiti, i praktične primjere iz svijeta Oraclea. - Napravite, podesite i debagujte PL/SQL programe u različitim okruženjima pomoću kojih se radi sa bazama podataka Oracle. Koristite PL/SQL blokovske strukture, promenljive, tipove podataka, izraze, operatore i iskaze. - Kontrolišite i oporavite bazu podataka od grešaka koristeći izuzetke i rutine za obradu grešaka. - Prosledite podprograme, procedure, funkcije, pakete i okidače. Ostvarite komunikaciju između sesija pomoću paketa DBMS_PIPE i DBMS_ALERT. - Napravite objektno-orijentisane PL/SQL aplikacije. - Obrađujte velike skupove podataka koristeći slogove i objekte PL/SQL-a. - Koristite Oracle Net Services, spoljašnje procedure, Java biblioteke i deljene bibilioteke koje su napravljene u programskom jeziku C. - Ostvarite objektno-orijetisano programiranje pomoću privremenih objekata, nasleđivanja, evoluiranja tipova podataka i promene atributa. - Automatizujte poslove baze podataka pomoću paketa DBMS_JOB i DBMS_SCHEDULER, a funkcionalnost prosledite elektronskom poštom pomoću paketa UTL_SMTP i UTL_MAIL. O autorima Skot Urman autor čije se knjige nabolje prodaju, član je tima za dijagnostiku i otklanjanje problema u Oracle korporaciji. Ron Hardmen, OCP viši analitičar podataka, Oracle Support Services. Majkl MekLaflin, D.CS. viši menadžer nadogradnje aplikacija, Oracle Application Development. Kratak sadržaj Deo I: Uvod 1 Uvod u programski jezik PL/SQL 2 Korišćenje alata SQL*Plus i JDeveloper 3 Osnove programskog jezika PL/SQL 4 Upotreba programskih jezika SQL i PL/SQL 5 Slogovi 6 Kolekcije 7 Obrada grešaka 8 Pravljenje procedura, funkcija i paketa 9 Upotreba procedura, funkcija i paketa Okidači baze podataka Deo II: Napredne osobine programskog jezika PL/SQL Komunikacija između sesija Spoljašnje rutine Dinamički SQL Uvod u objekte Objekti baze podataka Veliki objekti Planiranje poslova Deo III: Dodaci A Rezervisane reči programskog jezika PL/SQL B Vodič kroz ugrađene pakete Indeks