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)
How to get SELECT columns size with Perl DBI+DBD::Oracle? [message #641139] Tue, 11 August 2015 03:07 Go to next message
Michel Cadot
Messages: 65258
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

Re: How to get SELECT columns size with Perl DBI+DBD::Oracle? [message #641579 is a reply to message #641139] Tue, 18 August 2015 07:58 Go to previous message
Michel Cadot
Messages: 65258
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In the end, as you can see in the reference above, there is no way but to manually compute it.

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


Current Time: Mon Dec 18 13:42:24 CST 2017

Total time taken to generate the page: 0.03252 seconds