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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 21 09:54:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.