Creating a View avoiding some null columns from a table.greenspun.com : LUSENET : DBAzine : One Thread |
HiMy application has a table with more than 700 columns. Of which 220 odd is null.
Normally we specify the columns one after the other in the select statement of the view defnition . I wnat to know if there is a simple way to create a view avoiding these null columns?
thanks and regards Navaneeth.
-- Navaneeth (navaneeth_kumar@hotmail.com), February 04, 2004