CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- From: "Rumpi Gravenstein" <rgravens@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Oct 2007 09:49:31 -0400
I've been looking at the Oracle CAST function vs. a TO_NUMBER or TO_CHAR or
.... Where both the CAST and TO_ functions result in equivalent answers, is
there a preferred choice?
--
Rumpi Gravenstein
- Follow-Ups:
- Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- From: Jared Still
Other related posts:
- » CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- » Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- Re: CAST vs. TO_NUMBER or TO_CHAR or TO_DATE or ...
- From: Jared Still