HomeОбразованиеRelated VideosMore From: ORACLE TAUGHT

Using conversion function and condiional expressions

0 ratings | 93 views
Conversion Functions Conversion Functions and Conditional Expressions Conversion Functions have following points : 1.conversion functions 1.1.Implicit Data Type Conversion 1.2.Explicit Data Type Conversion 2.Nesting Functions 3.General Functions 4.NVL Function 5.Conditional Expressions 6.DECODE Function 1.Using Conversion Functions and Conditional Expressions Conversion Functions Implicit Data Type Conversion Oracle server can automatically perform data type conversion in an expression. For example, the expression hire_date ’01-JAN-90′ results in the implicit conversion from the string ’01-JAN-90′ to a date. Therefore, a VARCHAR2 or CHAR value can be implicitly converted to a number or date data type in an expression.
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.