I was asked about implicit data conversion in the Oracle during one of my job interview. It is not good, but I forgot about this feature at that time. So, I give the next answer: "If i would be a team leader, I would have terribly scolded developer, who use implicit data conversion".
Certainly, I used more rude expression. What do you think about the snippet of code below? (p2 - is a column with NUMBER type)
Sure, Oracle is the best database server and it allows implicit data conversion. But also Oracle documentation gives us strong recommendations do not use such inefficient kind of code.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements002.htm
Certainly, I used more rude expression. What do you think about the snippet of code below? (p2 - is a column with NUMBER type)
SELECT * FROM some_table WHERE p2 = '520';
Sure, Oracle is the best database server and it allows implicit data conversion. But also Oracle documentation gives us strong recommendations do not use such inefficient kind of code.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements002.htm
No comments:
Post a Comment