What are the date, character, converstion functions in oracle?

Showing Answers 1 - 3 of 3 Answers

There are three types of conversions
1-  TO_DATE
2-  TO_CHAR
3-  TO_NUMBER

TO_DATE:
use to convert charector into data by giving format mask.

TO_CHAR:
use to convert number into charecter, and date into charecter

TO_NUMBER:
use to convert cherector into number by giving format mask.

If you want more clerification then reply, i will explain it with examples.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions