Do you know where your variables are? | |
PerlMonks |
Re: DBI + Oracle describe problemby unixwzrd (Beadle) |
on Feb 22, 2001 at 14:08 UTC ( [id://60173]=note: print w/replies, xml ) | Need Help?? |
If what you want is lots of information about the columns
in a particular table that you can view, try this:
You can adjust what information you want by selecting additional columns from the ALL_TAB_COLUMNS view. Lots of goodies there. I use this for dynamically creating persistent instances of objects and building the class attributes dynamically. Once I tighten up the code a bit more, I'll be posting my DB_Object class module here. The reason for the select distinct is that in Oracle, if there is a SYNONYM, it will be listed along with the table information and it will be identical. COLUMN_NAME and COLUMN_ID are the minimums to get away with for the distinct. Mike "The two most common elements in the universe are hydrogen... and stupidity." Harlan Ellison
In Section
Seekers of Perl Wisdom
|
|