TY - BOOK AU - Valdivia,John Christian B. TI - Programming oracle database T2 - Technical Vocational livelihood series SN - 9789710639359 U1 - 001.64 PY - 2016/// CY - Quezon City, Philippines PB - Phoenix Publishing House KW - Computer programming N1 - "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 ER -