Example for conversion functions

Welcome Guest ( Log In | Register )

Example for conversion functions, i need example queries to implicit data type conversion

thiyagusham View Member Profile	Mar 27 2012, 12:20 AM Post #1
Advanced Member Group: Members Posts: 78 Joined: 16-March 12 From: Chennai from India Member No.: 46,939	Hi to all , Again i getting confused with conversion function especially Explicit data type conversions. some cases oracle server automatically converts the data to the required type. This is called IMPLICIT CONVERSION. Explicit conversions are done by using the conversion functions. Oracle Explicit Data Type Conversions are 1 TO_CHAR 2 TO_DATE 3 TO_NUMBER I read some books i need clear example Implicit , Explicit type conversions. (using to_char , to_date) Thank you..

burleson View Member Profile	Mar 27 2012, 05:35 AM Post #2
Advanced Member Group: Members Posts: 10,370 Joined: 26-January 04 Member No.: 13	Hi. >> i need clear example Implicit http://www.dba-oracle.com/t_advanced_sql_c...n_functions.htm http://www.dba-oracle.com/t_convert_number...ating_point.htm -------------------- Hope this helps. . . Donald K. Burleson Oracle Press author Author of Oracle Tuning: The Definitive Reference

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Time is now: 22nd May 2013 - 08:14 PM