[导入]Misconducted by my VB experience on Substr

There is a Substr funciton in Oracle as well as in Visual Basic. To have the first 4 characters of a string in VB I usually write code like
first_4_char = Substr(some_string, 4)
and I followed this approach in PL/SQL programming, what a big mistake.

It should be
first_4_char = Substr(some_string, 1, 4)
in Oracle PL/SQL.
文章来源:http://zouyu.blogspot.com/2005/09/misconducted-by-my-vb-experience-on.html