Oracle SQL: the Essential Reference by David C. Kreines

By David C. Kreines

Likes:
pretty whole on sql statements and functions

dislikes:
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)

Show description

Read Online or Download Oracle SQL: the Essential Reference PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте 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 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 Application Express 4 Recipes

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.

Additional info for Oracle SQL: the Essential Reference

Sample text

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 ( ).

Download PDF sample

Rated 4.20 of 5 – based on 47 votes