PL/SQL (MOSC)

MOSC Banner

how to create a view returning allways a value

edited Apr 15, 2014 7:58AM in PL/SQL (MOSC) 6 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center