SELECT view_name, column_name,COUNT (view_name) AS aa,text
FROM (SELECT a.view_name, b.column_name, a.text
FROM user_views a, user_col_comments b
WHERE a.view_name = b.table_name)
-- WHERE view_name = 'SV%'
GROUP BY view_name, column_name,aa,text
FROM (SELECT a.view_name, b.column_name, a.text
FROM user_views a, user_col_comments b
WHERE a.view_name = b.table_name)
-- WHERE view_name = 'SV%'
GROUP BY view_name, column_name,aa,text
SELECT view_name,
column_name, COUNT(view_name) AS aa,
text
FROM (SELECT a.view_name,
b.column_name,
a.text
FROM user_views a,
user_col_comments b
WHERE a.view_name = b.table_name)
-- WHERE view_name = 'SV% '
GROUP BY view_name,
column_name,
text;