The book teaches the basics of the Oracle database from a beginner s perspective to the advanced concepts using a hands-on approach. Each and every concept has been elaborated with suitable practical examples along with code for clear and precise understanding of the topic. Using a practical approach, the book explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing, and stored functions and procedures. The book is suitable for undergraduate engineering students of Computer Science and Information Technology, B.Sc. (Computer Science/IT), M.Sc. (Computer Science/IT) and students of Computer Applications (BCA, MCA, PGDCA, and DCA). Besides, the book can be used as a reference by professionals pursuing short-term courses on Oracle Database and students of Oracle Certified Courses.2. complete(a#39;ca#39;) a Re-create the materialized view from scratch. 3. force(a#39;?ca#39;) a First attempt fast if fails then use complete. Refreshing all materialized views All Materialized Views can be refreshed in a single command as in Figure 17.23.
|Title||:||Oracle Database 11g : Hands-On Sql & Pl/sql|
|Publisher||:||PHI Learning Pvt. Ltd. -|