'Round 45' diaporamas de présentation

Single-Row Functions

Single-Row Functions. Input. Output. arg 1. arg 2. Result value. arg n. SQL Functions. Function. Function performs action. Two Types of SQL Functions. Functions. Multiple-row functions. Single-row functions. Single-Row Functions. Manipulate data items

1.35k views • 96 slides

Introduction to Oracle

Introduction to Oracle. SQL and PL/SQL. ?? : Peter. Writing Basic SQL Statements. Basic SELECT Statement. SELECT [DISTINCT] {*, column [ alias ],...} FROM table;. SELECT identifies what columns. FROM identifies which table. Selecting All Columns. SQL> SELECT *

1.15k views • 94 slides

Single-Row Functions

Single-Row Functions. Objectives. After completing this lesson, you should be able to do the following: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2.

517 views • 51 slides

Ch. 3 Single-Row Functions

572 views • 45 slides

Single-Row Functions

Single-Row Functions. Objectives. After completing this lesson, you should be able to do the following: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2.

595 views • 44 slides

Single-Row Functions

Single-Row Functions. Objectives. At the end of this lesson, you should be able to: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2. Result value.

562 views • 42 slides

Single-Row Functions

Single-Row Functions. Objectives. After completing this lesson, you should be able to do the following: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2.

580 views • 42 slides

Single-Row Functions

Single-Row Functions. Objectives. At the end of this lesson, you should be able to: Describe various types of functions available in SQL Use character, number, and date functions in SELECT statements Describe the use of conversion functions. Input. Output. arg 1. arg 2. Result value.

430 views • 42 slides

Single-Row Functions

Single-Row Functions. SQL Functions Functions are a very powerful feature of SQL and can be used to do the following: Perform calculations on data Modify individual data items Manipulate output for groups of rows Format dates and numbers for display Convert column datatypes

608 views • 41 slides

544 views • 41 slides

SQL FUNCTIONS

SQL FUNCTIONS. NUMERIC, CHARACTER AND DATE FUNCTIONS. SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions written in PL/SQL.

3.64k views • 40 slides

Single-Row Functions

Single-Row Functions. Input. Output. arg 1. arg 2. Result value. arg n. SQL Functions. Function. Function performs action. Two Types of SQL Functions. Functions. Multiple-row functions. Single-row functions. Single-Row Functions. Manipulate data items

513 views • 36 slides