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.
Read Online or Download Mastering Oracle SQL and SQL*Plus PDF
Similar oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.
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 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.
- OCP: Oracle8i DBA Architecture & Administration and Backup & Recovery Study Guide
- Oracle case management solutions
- Oracle PL/SQL: Expert Techniques For Developers and Database Administrators (Charles River Media Programming)
- RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach (Expert's Voice in Oracle), 1st Edition
Extra info for Mastering Oracle SQL and SQL*Plus
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.