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