A comprehensive tutorial covering the fundamental concepts and ideas of SQL, and showing how these are implemented in both Oracle 9I and Access 2000 databases. John Patrick discusses how to create tables and views to divide a complex process into a series of simple steps, and covers topics such as inner joins, self joins and subqueries using easy-to-follow examples throughout. The work should help readers to write SQL queries that are easy to understand, verify, modify and extend. The accompanying CD-ROM includes a trial version of Oracle products.You can find additional information in the Oracle documentation, within the Utilities manual. Two files are required to run the loader: a Control ... The BAT file invokes the Load utility with the SQLLDR.EXE command. This is followed by severalanbsp;...
|Author||:||John J. Patrick|
|Publisher||:||Pearson P T R - 2002|