Can we insert an alphanumeric data into numeric data type. If not how can I achieve this by converting or by using some functions?
Printable View
Can we insert an alphanumeric data into numeric data type. If not how can I achieve this by converting or by using some functions?
No. you can't insert alphanumeric data in numeric column. there are some functions to convert the data type like [COLOR=seagreen][B]to_number(), to_char(), to_date()[/B][/COLOR] in Oracle.
if your data is between 0-9 that is stored in a charactor column For Eg. your column is customer_id & is char as datatype, you can use it as number using [COLOR=seagreen][B]to_number(customer_id).[/B][/COLOR] But this is possible [COLOR=red]ONLY [/COLOR][U]when your data is pure numeric[/U] i.e.(0-9) if there is any charactor like A-Z a-z &/OR any special charactors, [B]this function won't work[/B].
You can turn the numeric data into charactor type using [COLOR=seagreen][B]to_char(columnname)[/B][/COLOR] or [COLOR=seagreen][B]to_char(value)[/B][/COLOR] but not vice versa.
The usage of the functions to_char, to_date and to_number is given below:
TO_CHAR - This transforms data type DATE or NUMBER into character string
TO_DATE - This transforms data type NUMBER, VARCHAR, CHAR into DATE
TO_NUMBER - This convert data type CHAR or VARCHAR into NUMBER