The View should not contain distinct keyword,rownum keyword,group by clause to perform dml operations through it.
Type: Posts; User: subravin; Keyword(s):
The View should not contain distinct keyword,rownum keyword,group by clause to perform dml operations through it.
I heard that using the co-related subquery will degrade the performance of the whole query lot. then why we can go for that, is there is any alternate option in oracle to do the same thing as...