Select <exp>
From <t_name>
[where<cond>]
[group<col_name>]
[having by <group col_name>]
[order by <col_name>[asc|desc]];
Conversion Function in Oracle
These functions are required to convert the date from one type to another. ORACLE provides following primary data types either to declare column of a table or to declare a variable in PL-SQL. The data types are Char, varchar2, number, date Depending on the above data types ORACLE provides following conversion functions TO_NUMBER(),TO_DATE(),TO_CHAR() This is a conversion function required to convert date to char or number to char TO_CHAR(DATE/NUMBER,’FMT’) DATE TO CHAR: To convert date to char ORACLE provides a series of formatting strings are as follows DY Ã MON MONTH ...
0 Comments