how to create a view returning allways a value
hello,
I have a table A, with colums C,D,E....
On this table is run "select C,D,E from A where C= 'xxxx'" that gives me back a list of values for the fields C,D,E and also "select count(*) from A where C = 'xxxx'" clause wich gives me back 0 in case of no_data_found.
I need to create a view V_A on this table, where
1 the "select count(*) from V_A where C= 'xxx'" clause returns 1 (for example a fake string of chars ....) or the number of records counted,
allways ... never 0
and
2 the same list of values