"what's wrong with separated statements?" Aha... well, if it would be for me, it's off course okay. But this script is for people who aren't DBA's, and therefor i want...

Hi Frank,

Thanks for your reply. Yes, I can make a count(*) , but my problem is the combination of the 2 queries:

1) give the name of each datefield in the...

Yes, but that would not return the number of value's, but the value's themselves. And i am suppost to make an sql script , and convert it to Oracle-syntax etc...