Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Iterating through designs tables in a given sequence?
I'm about to populate a metadata tool that I'm developing.
Some of the fields will be from a humungous (to me, at least) data hub. We're talking about 160 tables with at least 20 columns per table. Let's say a couple thousand fields.
There are lots more tables, but those are all the tables in four schemas that we're interested in.
I'd like to be able to write some SQL that will iterate through all the tables in a given schema, returning a row for each column in each table. That row would contain table name, field name, and various field properties like size, data type, default value...and so-forth.
Two weeks ago, I couldn't even spell "Oracle", now I need to do this. I've got a PSQL language ref, but don't know where to begin looking.
Could somebody point me in the right direction?
-- PeteCresswellReceived on Mon Dec 22 2003 - 18:26:38 CST