Single row funtions

Functions make the basic query block more powerful and are used to manipulate data values. This is the first of two lessons that explore functions. You will focus on single row character, number, and date functions, as well as those functions that convert data from one type to another, for example, character data to numeric. At the end of this lesson, you should be able to Explain the various types of functions available in SQL. Identify the basic concepts of using functions. Use a variety of character, number, and date functions in SELECT statements. Explain the conversion functions and how they might be used | 3 Single Row Functions ORACLG Objectives Explain the various types of functions available in SQL. Identify the basic concepts of using functions. Include a variety of character number and data functions in SELECT statements. Explain the conversion functions and how they might be used. Schedule Timing 55 minutes 40 minutes 95 minutes Topic Lecture Practice Total Class Management Note Files required for lesson are Demonstration Practice None 3-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives Functions make the basic query block more powerful and are used to manipulate data values. This is the first of two lessons that explore functions. You will focus on single row character number and date functions as well as those functions that convert data from one type to another for example character data to numeric. At the end of this lesson you should be able to Explain the various types of functions available in SQL. Identify the basic concepts of using functions. Use a variety of character number and date functions in SELECT statements. Explain the conversion functions and how they might be used. Single Row Functions .

Không thể tạo bản xem trước, hãy bấm tải xuống
TỪ KHÓA LIÊN QUAN
TÀI LIỆU MỚI ĐĂNG
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.