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

If you only need the first three characters of each column, why not simply ask for that when doing your query? For example:

SELECT SUBSTR(COL1, 0, 3) FROM TABLENAME;
[download]

Consider using place holders where possible, See DBI and Bobby Tables.

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

Replies are listed 'Best First'.
Re^2: Extracting only required length in a column in perl DBI by Thomas Kennll (Acolyte) on Jan 15, 2013 at 12:48 UTC
That will work.. But, I actually wanted to extract 6 characters for the 3 column... How do I achieve that??	[reply]
Re^3: Extracting only required length in a column in perl DBI by marto (Cardinal) on Jan 15, 2013 at 12:53 UTC
Replace the 3 in my example with a 6, you should consider learning basic SQL.	[reply]
Re^4: Extracting only required length in a column in perl DBI by Thomas Kennll (Acolyte) on Jan 15, 2013 at 13:08 UTC
What I meant is something like this my ($ansb_cktid, $ansb_mcn, $ansb_soc) =unpack("A3 A3 A6")	[reply]
Re^5: Extracting only required length in a column in perl DBI by marto (Cardinal) on Jan 15, 2013 at 14:02 UTC
Re^2: Extracting only required length in a column in perl DBI by Anonymous Monk on Jan 17, 2013 at 07:32 UTC
Nitpick: even though substr() is implemented in most sql dialects, the standards-compliant function is `substring(col1 from 1 for 3)`	[reply] [d/l]
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]