The book offers a systematic knowledge of Oracle SQL and PL/SQL to help students exploit the capabilities of the database in an effective and efficient manner. The book follows a step-by-step approach to the subject using real-world cases, examples and exercises in order to make it an easy, interesting and complete self-study guide. The book can be used for practical classes on Oracle version 8.0 onwards. The availability of an authorized Oracle database in conjunction with the book is sufficient to learn Oracle commands and syntaxes. It is designed to address the need of the laboratory classes on Oracle for the students of Computer Science, Information Technology and Computer Applications. The book will also be useful to professionals and academics alike for conducting training programmes on Oracle database.A SIMPLIFIED GUIDE RAJEEB C. CHATTERJEE. 14. Advanced. Join. Methods. 14.1 IntroductIon In Chapter 7 we discussed that the basic rule to display column values of relevant rows from more than one table is to equate all foreign keyanbsp;...
|Title||:||LEARNING ORACLE SQL & PL/SQL|
|Author||:||RAJEEB C. CHATTERJEE|
|Publisher||:||PHI Learning Pvt. Ltd. - 2012-03-17|