Oracle9i DBA JumpStart by BOB BRYLA

By BOB BRYLA

Attracted to a occupation as an Oracle database expert yet do not know the place to start? The Oracle9i OCA and OCP certifications are of the most well liked IT certifications round, and the Oracle9i DBA JumpStart from Sybex delivers you with the cast starting place in database management and programming fundamentals you will need sooner than embarking on a complete research software. The JumpStart sequence used to be constructed according to requests from technical running shoes trying to be certain a degree place to begin for college kids of their school rooms. the writer is an skilled Oracle teacher who presents basic, tangible factors to make the area of databases available to beginners to the IT box. you are going to find out about relational database recommendations, SQL*Plus or iSQL*Plus instructions, sorting and reporting concepts, safety, and masses extra. if you end up performed with this publication, you can be able to face the demanding situations of Oracle9i certification training.

Show description

Read or Download Oracle9i DBA JumpStart PDF

Similar databases books

Oracle9i DBA JumpStart

Attracted to a profession as an Oracle database expert yet have no idea the place to start? The Oracle9i OCA and OCP certifications are of the most popular IT certifications round, and the Oracle9i DBA JumpStart from Sybex supplies you with the cast origin in database management and programming fundamentals you will need prior to embarking on a entire research software.

Using FileMaker Bento

Get ok with the newest model of FileMaker Bento. Don’t simply examine it: See it and listen to it with step by step video tutorials and precious audio sidebars introduced during the loose net variation that incorporates each utilizing publication. For the cost of the ebook, you get on-line entry anyplace with an internet connection–no books to hold, up to date content material, and the advantage of video and audio studying.

Microsoft SQL server 2008 R2 master data services : implementation & administration

Most sensible Practices for Deploying and coping with grasp facts providers (MDS) successfully deal with grasp info and force greater determination making throughout your online business with particular guideline from MDS specialists. Microsoft SQL Server 2008 R2 grasp information prone Implementation ' management exhibits you ways to exploit MDS to centralize the administration of key facts inside your company.

Extra resources for Oracle9i DBA JumpStart

Sample text

GT Tests for greater than. >= GE Tests for greater than or equal.

MOD calculates the remainder in a division operation. For example, 60 MOD 7 = 4: 60 divided by 7 equals 8, with a remainder of 4. The result takes the sign of the dividend, thus: -17 MOD 4 = -1 -17 MOD -4 = -1 17 MOD -4 = 1 17 MOD 4 = 1 This is a Teradata extension to the ANSI SQL-99 standard. 2–6 + Add - Subtract + Unary plus (positive value) - Unary minus (negative value) Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ABS ABS arg ( ) KK01A010 ACOS ACOS arg ( ) KO01A020 ACOSH ACOSH ( arg ) KO01A021 ASIN ASIN ( arg ) KO01A022 Teradata RDBMS SQL/Data Dictionary Quick Reference 2–7 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ASINH ASINH ( arg ) KO01A023 ATAN ATAN ( arg ) KO01A024 ATAN2 ATAN2 ( x, y ) KO01A025 2–8 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ATANH ATANH ( arg ) KO01A026 CASE_N , A conditional_expression ( CASE_N A ) , NO CASE OR UNKNOWN , UNKNOWN UNKNOWN 1101A069 COS COS ( arg ) KO01A027 Teradata RDBMS SQL/Data Dictionary Quick Reference 2–9 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions COSH COSH ( arg ) KK01a001 EXP EXP ( arg ) KK01A002 LN LN ( arg ) KK01A003 LOG LOG ( arg ) KK01A004 2 – 10 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions NULLIFZERO NULLIFZERO ( arg ) 1101E225 RANDOM RANDOM ( lower_bound, upper_bound ) 1101B025 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 11 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions RANGE_N RANGE_N A ( test_expression start_expression * A BETWEEN AND end_expression AND * end_expression B EACH range_size * | range_list | B ) , NO RANGE OR UNKNOWN , UNKNOWN UNKNOWN range_list C start_expression AND end_expression AND end_expression EACH range_size * D C , start_expression AND D , start_expression AND end_expression EACH range_size EACH range_size end_expression * 1101A068 2 – 12 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions SIN SIN ( arg ) KK01A005 SINH SINH ( arg ) KK01A006 SQRT SQRT ( arg ) KK01A007 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 13 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions TAN TAN arg ( ) KK01A008 TANH TANH arg ( ) KK01A009 WIDTH_BUCKET WIDTH BUCKET ( value_expression, lower_bound, upper_bound, partition_count ) 1101A004 ZEROIFNULL ZEROIFNULL ( arg ) 1101E226 2 – 14 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Attribute Functions Attribute Functions BYTES BYTE byte_expression S FF07D174 CHARACTERS CHARACTERS ( string_expression ) CHARS CHAR FF07D165 CHARACTER_LENGTH CHARACTER_LENGTH CHAR_LENGTH (string_expression) FF07D088 FORMAT FORMAT ( column_name ) FF07D166 MCHARACTERS MCHARACTERS (string_expression ) FF07D217 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 15 Chapter 2: SQL Functions and Expressions Attribute Functions OCTET_LENGTH OCTET_LENGTH ( string_expression ) character_set_name FF07D218 TYPE TYPE ( expression ) FF07D169 2 – 16 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Built-In Functions Built-In Functions ACCOUNT ACCOUNT FF07R001 CURRENT_DATE CURRENT_DATE FF07D135 CURRENT_TIME CURRENT_TIME (fractional_precision ) FF07D136 CURRENT_TIMESTAMP CURRENT_TIMESTAMP (fractional_precision ) FF07D137 DATABASE DATABASE FF07R002 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 17 Chapter 2: SQL Functions and Expressions Built-In Functions DATE DATE FF07D134 PROFILE PROFILE KZ01A006 ROLE ROLE KZ01A007 SESSION SESSION FF07R003 TIME TIME FF07D271 USER USER FF07D272 2 – 18 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions CASE Expressions CASE Expressions Valued CASE Expression CASE A WHEN value_expression_1 value_expression_n A THEN scalar_expression_n B END B ELSE scalar_expression_m 1101A012 Searched CASE Expression CASE WHEN search_condition_n THEN scalar_expression_n A END A ELSE scalar_expression_m FF07D224 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 19 Chapter 2: SQL Functions and Expressions CASE Expressions COALESCE Expression , COALESCE ( 2 scalar_expression_n ) 1101E227 NULLIF Expression NULLIF ( scalar_expression1, scalar_expression2 ) HH01B094 2 – 20 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Comparison Operators Comparison Operators ANSI Operator Teradata Extensions = EQ Tests for equality.

The result takes the sign of the dividend, thus: -17 MOD 4 = -1 -17 MOD -4 = -1 17 MOD -4 = 1 17 MOD 4 = 1 This is a Teradata extension to the ANSI SQL-99 standard. 2–6 + Add - Subtract + Unary plus (positive value) - Unary minus (negative value) Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ABS ABS arg ( ) KK01A010 ACOS ACOS arg ( ) KO01A020 ACOSH ACOSH ( arg ) KO01A021 ASIN ASIN ( arg ) KO01A022 Teradata RDBMS SQL/Data Dictionary Quick Reference 2–7 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ASINH ASINH ( arg ) KO01A023 ATAN ATAN ( arg ) KO01A024 ATAN2 ATAN2 ( x, y ) KO01A025 2–8 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions ATANH ATANH ( arg ) KO01A026 CASE_N , A conditional_expression ( CASE_N A ) , NO CASE OR UNKNOWN , UNKNOWN UNKNOWN 1101A069 COS COS ( arg ) KO01A027 Teradata RDBMS SQL/Data Dictionary Quick Reference 2–9 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions COSH COSH ( arg ) KK01a001 EXP EXP ( arg ) KK01A002 LN LN ( arg ) KK01A003 LOG LOG ( arg ) KK01A004 2 – 10 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions NULLIFZERO NULLIFZERO ( arg ) 1101E225 RANDOM RANDOM ( lower_bound, upper_bound ) 1101B025 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 11 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions RANGE_N RANGE_N A ( test_expression start_expression * A BETWEEN AND end_expression AND * end_expression B EACH range_size * | range_list | B ) , NO RANGE OR UNKNOWN , UNKNOWN UNKNOWN range_list C start_expression AND end_expression AND end_expression EACH range_size * D C , start_expression AND D , start_expression AND end_expression EACH range_size EACH range_size end_expression * 1101A068 2 – 12 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions SIN SIN ( arg ) KK01A005 SINH SINH ( arg ) KK01A006 SQRT SQRT ( arg ) KK01A007 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 13 Chapter 2: SQL Functions and Expressions Arithmetic Operators and Functions/Trigonometric/Hyperbolic Functions TAN TAN arg ( ) KK01A008 TANH TANH arg ( ) KK01A009 WIDTH_BUCKET WIDTH BUCKET ( value_expression, lower_bound, upper_bound, partition_count ) 1101A004 ZEROIFNULL ZEROIFNULL ( arg ) 1101E226 2 – 14 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Attribute Functions Attribute Functions BYTES BYTE byte_expression S FF07D174 CHARACTERS CHARACTERS ( string_expression ) CHARS CHAR FF07D165 CHARACTER_LENGTH CHARACTER_LENGTH CHAR_LENGTH (string_expression) FF07D088 FORMAT FORMAT ( column_name ) FF07D166 MCHARACTERS MCHARACTERS (string_expression ) FF07D217 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 15 Chapter 2: SQL Functions and Expressions Attribute Functions OCTET_LENGTH OCTET_LENGTH ( string_expression ) character_set_name FF07D218 TYPE TYPE ( expression ) FF07D169 2 – 16 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Built-In Functions Built-In Functions ACCOUNT ACCOUNT FF07R001 CURRENT_DATE CURRENT_DATE FF07D135 CURRENT_TIME CURRENT_TIME (fractional_precision ) FF07D136 CURRENT_TIMESTAMP CURRENT_TIMESTAMP (fractional_precision ) FF07D137 DATABASE DATABASE FF07R002 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 17 Chapter 2: SQL Functions and Expressions Built-In Functions DATE DATE FF07D134 PROFILE PROFILE KZ01A006 ROLE ROLE KZ01A007 SESSION SESSION FF07R003 TIME TIME FF07D271 USER USER FF07D272 2 – 18 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions CASE Expressions CASE Expressions Valued CASE Expression CASE A WHEN value_expression_1 value_expression_n A THEN scalar_expression_n B END B ELSE scalar_expression_m 1101A012 Searched CASE Expression CASE WHEN search_condition_n THEN scalar_expression_n A END A ELSE scalar_expression_m FF07D224 Teradata RDBMS SQL/Data Dictionary Quick Reference 2 – 19 Chapter 2: SQL Functions and Expressions CASE Expressions COALESCE Expression , COALESCE ( 2 scalar_expression_n ) 1101E227 NULLIF Expression NULLIF ( scalar_expression1, scalar_expression2 ) HH01B094 2 – 20 Teradata RDBMS SQL/Data Dictionary Quick Reference Chapter 2: SQL Functions and Expressions Comparison Operators Comparison Operators ANSI Operator Teradata Extensions = EQ Tests for equality.

Download PDF sample

Rated 4.07 of 5 – based on 15 votes