Counting # of default values in a table

From: <umpaul18_at_cc.umanitoba.ca>
Date: 1998/03/10
Message-ID: <6e57if$pi1$1@nnrp1.dejanews.com>#1/1

G'day!

I need a way to get a count of the number of default values in a column. I found the default value in the COLS table, but it's declared as a LONG so it can't be used in a WHERE clause. Does anyone have any ideas (PL or SQL) on how to acomplish this?

None of our data is declared as a LONG, it's all smaller datatypes. I need this to work given any column in any table. It's part of an analysis proc I've written in PL.

Stay Casual,

Ken

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 10 1998 - 00:00:00 CST