Mastering Oracle SQL and SQL*Plus by Lex deHaan

By Lex deHaan

SQL is the ANSI-standard language for getting access to and manipulating relational databases. somebody (programmers, directors, or designers) who paintings with a relational databases have to comprehend the SQL language. whereas such a lot books out there don't accurately hide the fundamentals, this booklet differs: it explains basics intimately, supported by means of life like examples.You will achieve complete competence to outline, entry, and control facts in an Oracle database.This e-book is a good device that you should write powerful SQL for the Oracle database. The textual content is totally compliant with the newest model of the ANSI SQL general, and entirely replace for the Oracle 10g database. This ebook is a translation of well known Netherlands collage textual content (currently in its 3rd edition). writer Lex de Haan is very skilled with the Oracle database, and has twenty-five years of educating event. de Haan can also be a member of the ANSI/ISO SQL standardization nationwide physique.

Show description

Read Online or Download Mastering Oracle SQL and SQL*Plus PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication let real-time details entry and information sharing throughout your dispensed framework utilizing the professional info during this Oracle Press advisor. Oracle Streams 11g facts Replication explains the best way to manage and administer a unified company facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes presents an example-based method of studying program exhibit - the ground-breaking, quick program improvement platform incorporated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes a great instance or to kick begin their pondering and get pointed within the correct path.

Extra info for Mastering Oracle SQL and SQL*Plus

Example text

31 32 CHAPTER 2 ■ INTRODUCTION TO SQL, i SQL*PLUS, AND SQL*PLUS The counterpart of GRANT is the REVOKE command. Figure 2-4 shows the syntax diagram for REVOKE. Figure 2-4. The REVOKE command syntax diagram Besides the two standard SQL commands mentioned in this section (GRANT and REVOKE), Oracle supports several additional commands in the security and data access area; for example, to influence the locking behavior of the DBMS, to implement auditing, and to set up more detailed user authorization.

If you insist on creating your own object names in Oracle SQL using any characters you like (including, for example, spaces and other strange characters), and you also want your object names to be case-sensitive, you can include those names within double quotes. The only restriction that remains is the maximum name length: 30 characters. Using this “feature” is discouraged, because you will always need to include those names in double quotes again in every interactive SQL statement you want to execute against those objects.

For example, every data definition command implicitly commits your current transaction. SQL offers two commands to control your transactions explicitly: • COMMIT, to confirm all pending changes of the current transaction • ROLLBACK, to cancel all pending changes and restore the original situation Note the following important differences between data manipulation and data definition: • DELETE empties a table; DROP removes a table. TRUNCATE allows you to delete all the rows in a table in an efficient (but irrevocable) way.

Download PDF sample

Rated 4.45 of 5 – based on 14 votes