Re^2: 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)

Comment on Re^2: Extracting only required length in a column in perl DBI Download Code

Replies are listed 'Best First'.
Re^3: Extracting only required length in a column in perl DBI by marto (Cardinal) on Jan 17, 2013 at 10:31 UTC
OP stated they're using Oracle, `substring(col1 from 1 for 3)` doesn't work (ORA-00907). substr.	[reply] [d/l]