Valdivia, John Christian B.

Programming oracle database/ John Christian B. Valdivia - Quezon City, Philippines: Phoenix Publishing House, 2016. - xi, 578 pages: Illustrations; 26 cm. - Technical Vocational livelihood series .

"Kto12 curriculum compliant--cover"

Writing sql queries to access stored data in an oracle database and customize output; and setting user access level and using scalar and correlated subqueries -- Retrieve data using the sql select statement -- Use single-row functions to customize output -- Display data from multiple table using joins -- Manipulate data -- Control user access -- Manipulate lage data sets -- Manage data in different time zones -- Retrieve data using subqueries -- Using and applying pl/sql programming language -- Pl/sql identifiers -- Interaction with the oracle server -- Handle exception -- Stored procedures -- Designing pl/sql code -- Using advanced interface methods -- Performance and tuning -- Implementing vpd with fine-grained access control


English text

9789710639359


Computer programming

001.64 / V146