oracle sql

[vikas12345]

can anyone tell me any example of implicit conversion from date/number to
char data-type in case of assignments in ORACLE SQL..????

send me reply at [REMOVED]

[Dave44]

oracle will make implicit conversions when it needs to but it will fall over if that conversion fails (as it should). Even for dates it will make an implicit conversion and if you luck out and have your default date format string match what you give then it will work.

In reality you should code your conversions EXPLICITLY, do not rely on oracle's attempt to convert it for you.

[125]SQL> SELECT *
  2  FROM   (SELECT '1' my_char
  3          FROM   DUAL)
  4  WHERE  my_char = 1;

M
-
1

Elapsed: 00:00:00.04
[125]SQL> SELECT *
  2  FROM   (SELECT 't1' my_char
  3          FROM   DUAL)
  4  WHERE  my_char = 1;
WHERE  my_char = 1
       *
ERROR at line 4:
ORA-01722: invalid number


Elapsed: 00:00:00.06

Elapsed: 00:00:00.07
[125]SQL> SELECT *
  2  FROM   (SELECT trunc(sysdate) my_char
  3          FROM   DUAL)
  4  WHERE  my_char = '23-Jul-2008';

MY_CHAR
---------
23-JUL-08

Elapsed: 00:00:00.04
[125]SQL> SELECT *
  2  FROM   (SELECT trunc(sysdate) my_char
  3          FROM   DUAL)
  4  WHERE  my_char = '20080723';
WHERE  my_char = '20080723'
                 *
ERROR at line 4:
ORA-01861: literal does not match format string


Elapsed: 00:00:00.06