Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Example for conversion functions, i need example queries to implicit data type conversion
thiyagusham
post 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..
Go to the top of the page
 
+Quote Post
burleson
post Mar 27 2012, 05:35 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,623
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
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 26th October 2014 - 01:54 AM