Opnion About inline view

[amerbaig]

I am working in very important sector in Canada and using Oracle widely. There is a group of experienced managers and developer who discourage to use inline views. They have some reasons in addition to (may be misleading) information pass on by Oracle. According to them Inline views are “devils work”. It gives wrong results and poor in performance. They also refer an oracle bug, which I believe is a misleading info by Oracle (probably same guy).

http://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=1227266

I have posted a question against that bug to Oracle (metalink.oracle.com) PL/SQL FORUM. I think Note:118978.1 is right and if we incorporate aliases we will never face problem. I have widely used inline views and never faced wrong results. In my opinion Inline views made life simple and easy. Its performance is excellent and save a lot of time rather to write multiple SQLs, which make the maintenance job difficult. Considering all of you an authority on Oracle. I want to seek expert opinion about Inline view. Please keep in mind that here we use lot of SQLs just to avoid inline views and some time convert some SQLs into real Views just to get rid of inline view. Your note could help me to convince my manager to allows us to use inline views.

I am sorry for writing you personally.

Regards,

Amer

 

[SantaMufasa]

Amer,

Does your manager also refuse to travel in a car because there is a risk of getting in an accident?

I agree with you that in-line views are an excellent mechanism. If there is a bug, then Oracle needs to fix the bug and offer a patch. I have heavily and successfully used in-line views for many years and would be very unhappy if I had to stop. I have never had incorrect results return from an in-line view.

Cheers,

Dave
Sandy, Utah, USA @ 17:13 GMT, 10:13 Mountain Time