Re^2: Extracting only required length in a column in perl DBI

[Anonymous Monk]

in reply to Re: Extracting only required length in a column in perl DBI
in thread Extracting only required length in a column in perl DBI

Nitpick: even though substr() is implemented in most sql dialects, the standards-compliant function is substring(col1 from 1 for 3)

[marto]

OP stated they're using Oracle, substring(col1 from 1 for 3) doesn't work (ORA-00907). substr.