Oracle Views Part -2 by Dinesh

DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [e-mail]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call [phone],[phone],[phone],[phone].
durgasoft.com
durgasoftonline...
/ durgasoftware
durgajobs.com
/ durgajobsinfo.... .

[@hassan3634]

Sir, You are simply great. I am really appreciate your laborious effort.

[@kanthvalluru5424]

No words to say .. hats of you Mr Dinesh

[@sumanreddyk7284]

Hi Sir, It's a neat and clean explanation. Now I have better understanding about views. Thanks for the wonderful session.

[@poonamghuge4707]

Thank you sir for best explanation

[@faisalshaikh2027]

hello ,' dinesh sir u are very well to explain the concepts , i m really happy to learn from ur vedios, no one teaches like this ,and by the way sir were is the next vedios of view,

[@DurgaSoftwareSolutions]

Hello Faisal. Thanks for your valuable feedback. It will boost us to do new things. Please subscribe to get updates about new videos. For Oracle all videos, Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@vikastiwari8935]

Wonderful explanation

[@ShubhamPandey-bb2ho]

Is it possible to change the column name of a view after it has been created? If yes then will you please help me out with the query.

[@DurgaSoftwareSolutions]

Hello Shubham. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@aamirmalla9898]

I think first we will apply inner join on first two tables by ON CLAUSE and then the resultant with 3rd table ? Am i right sir?

[@DurgaSoftwareSolutions]

Hello Amir. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@basavarajbirajdar3965]

dinesh sir u said that we can update and delete data from complex view but i am unable to do it

[@DurgaSoftwareSolutions]

Hello Basavaraj. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@Davincirajarp]

can i get the link for other videos for views.?

[@DurgaSoftwareSolutions]

Hello Davincirajarp. Plz contact our online team [e-mail] or call us on this number +918885252627,7207212427/28

[@basavarajbirajdar3965]

ORA-01779: cannot modify a column which maps to a non key-preserved table ORA-01779: cannot modify a column which maps to a non key-preserved table ORA-01752: cannot delete from view without exactly one key-preserved table

[@DurgaSoftwareSolutions]

Hello Basavaraj. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@suryaasurya2350]

sir in inner join.we will use on condition right?

[@jagajeettripathy2587]

Where is materialised view videoa

[@DurgaSoftwareSolutions]

Hello Tripathy. For materialised view video, Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28