Oracle SQL: the Essential Reference by David C. Kreines
By David C. Kreines
pretty whole on sql statements and functions
why arrange it into "data definition" and "data manipulation" sections? Why not only positioned all of the statements in a single alphabetically equipped section?
missing part on operator priority (at least, accding to the index. perhaps it truly is in there someplace)
Read Online or Download Oracle SQL: the Essential Reference PDF
Best oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте PL/SQL на полную мощь.
Grasp Oracle Streams 11g Replication let real-time details entry and information sharing throughout your dispensed framework utilizing the professional details during this Oracle Press advisor. Oracle Streams 11g information Replication explains easy methods to organize and administer a unified firm info sharing infrastructure.
Oracle program convey four Recipes offers an example-based method of studying software exhibit - the ground-breaking, speedy program improvement platform incorporated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply desires a very good instance or to kick begin their pondering and get pointed within the correct path.
- Oracle Goldengate 11g Complete Cookbook
- Unix for Oracle Dbas Pocket Reference
- Protecting Oracle Database 12c
- The Pocket Oracle and Art of Prudence
- SAP Basis Installation on UNIX with Oracle Database (SAP 4.6)
Additional info for Oracle SQL: the Essential Reference
Table 1-1 lists the arithmetic operators available in SQL. This is the Title of the Book, eMatter Edition Copyright © 2000 O’Reilly & Associates, Inc. All rights reserved. Relational Operators 15 Table 1-1. 1 / Division sal / 12 – Negation –sal + Identity +sal Concatenation Operator The concatenation operator (||) combines two character strings. Consider the following SQL statement: SELECT fname || ' ' || lname FROM employee_master; This statement returns (for each row) a single string consisting of the first name, a space, and the last name.
If one of two concatenated strings is NULL, the result is a non-NULL string. The NULL string is treated as an empty string. If both strings being concatenated are NULL, then the resulting string is NULL. If either of the operands is a VARCHAR2 datatype, the resulting string is a VARCHAR2 datatype as well. A concatenated string may not be longer than 2000 characters if the operands are CHAR datatypes, or 4000 characters otherwise. Other character types, like LONG and CLOB, cannot be concatenated.
Relational Operators 15 Table 1-1. 1 / Division sal / 12 – Negation –sal + Identity +sal Concatenation Operator The concatenation operator (||) combines two character strings. Consider the following SQL statement: SELECT fname || ' ' || lname FROM employee_master; This statement returns (for each row) a single string consisting of the first name, a space, and the last name. Although most Oracle platforms use solid vertical bars (||) as the concatenation operator, some platforms, most notably IBM platforms using the EBCDIC character set, use the broken vertical bars ( ).