Wednesday, January 27, 2010

SQL: describe a select statement instead of table

QA asked me to put max lengths in input fields that would map to values that would eventually be inserted into the Oracle database. The problem was that these values were not going into a single table, but about 10 different tables, which were defined by a complex select statement. I didnt want to describe each individual table to find out the max lengths on the column names

Take the complex SQL statement and create a view with it:

Then describe the view, and drop the view when you are done with it.

No comments:

Post a Comment