OraFAQ Forum: Programming Interfaces » How to get SELECT columns size with Perl DBI+DBD::Oracle?

Home » Open Source » Programming Interfaces » How to get SELECT columns size with Perl DBI+DBD::Oracle? (Oracle: 10.2-11.2, Perl: 5.20.2, DBI: 1.633, DBD::Oracle: 1.74)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get SELECT columns size with Perl DBI+DBD::Oracle? [message #641139]

Tue, 11 August 2015 03:07

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

After you prepare and execute a SELECT the statement handle has some attributes set for each column: name, type, precision, scale...
I didn't find any attribute giving the fields size or their maximum size.

Is there a way to get this (without first fetching all the rows)?

[Cross-ref: http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=78082]

[Updated on: Tue, 11 August 2015 03:12]

Report message to a moderator

[Message index]

		How to get SELECT columns size with Perl DBI+DBD::Oracle? By: Michel Cadot on Tue, 11 August 2015 03:07
		Re: How to get SELECT columns size with Perl DBI+DBD::Oracle? By: Michel Cadot on Tue, 18 August 2015 07:58

Previous Topic:	insert into db via perl dbi
Next Topic:	How to SELECT XMLTYPE data with Perl DBD::Oracle?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:58:46 CDT 2024