Characteristics
You use number functions to accept numeric input. The number functions return numeric values.
Function Names
The three most commonly used number functions are the following:
* ROUND: Rounds a column, an expression, or a value to n decimal places
* MOD: Returns the remainder of x divided by y
* TRUNC: Truncates a column, an expression, or a value to n decimal places
Number Functions
Sunday, January 31, 2010
by
Abdul Majid Niazi
·
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(53)
-
▼
January
(52)
- Creating Groups: Part 1
- Using the Grouping Functions
- Group Functions: Part 2
- Group Functions: Part 1
- Group Functions: Part 1
- Working with Groups of Data
- Using the NVL Function
- Using the NVL Function
- Formatting Dates
- Formatting Dates
- Using Date Functions
- Date Functions: Part 2
- Date Functions: Part 1
- Using Numeric Functions
- Number Functions
- Using Character Functions
- Character Functions: Part 2
- Character Functions: Part 1
- Using Functions to Customize Reports
- Joining Multiple Tables
- Joining Multiple Tables
- Applying Additional Conditions to a Join
- Applying Additional Conditions to a Join
- Joining Tables and Identifying Columns
- Joining Tables and Identifying Columns
- Simple Joins
- Simple Joins
- Joining Tables
- Retrieving Rows
- Retrieving Rows
- Retrieving Columns
- Retrieving Columns
- Writing a Basic Query
- Writing a Basic Query
- Building Queries
- Building Queries: Part 2
- Building Queries
- Accessing Data
- Removing a Copy of a Table
- Removing Tables
- Implementing Business Rules
- Creating Constraints
- Identifying Constraints
- Managing Constraints
- Adding a New Column
- Modifying Tables
- Creating a Copy of a Table
- Creating Tables Using SQL
- Creating Tables by Using the Object Browser
- Creating Tables
- Working with Database Objects
- Relational data base
-
▼
January
(52)
0 comments:
Post a Comment