1.

Explain About Data Conversions In Oracle 7.3?

Answer»

In some cases, ORACLE supplies DATA of one datatype where it expects data of a DIFFERENT datatype. This is ALLOWED when Oracle can automatically convert the data to the expected datatype using one of the following functions:

  • TO_NUMBER()
  • TO_CHAR()
  • TO_DATE()
  • TO_LABEL()
  • CHARTOROWID()
  • ROWIDTOCHAR()
  • HEXTOCHAR()
  • CHARTOHEX()

In some cases, Oracle supplies data of one datatype where it expects data of a different datatype. This is allowed when Oracle can automatically convert the data to the expected datatype using one of the following functions:


Discussion

No Comment Found

Related InterviewSolutions