VIEW - Simple View with examples | Oracle SQL tutorial in TAMIL

VIEW - Simple View with examples | Oracle SQL tutorial in TAMIL | SQL tutorial for beginners in Tamil ‪@learncodetodaytamil‬.
Channel link: / @learncodetodaytamil
Oracle SQL Playlist: • Oracle SQL in Tamil
Hello Guys welcome to Learn Code Today தமிழ் 👩‍💻
Give this video a Thumbs Up 👍
Share & Subscribe for More Videos😉
Click the bell icon to get notified for new videos 🔔
Feel free to drop your doubts in the comment section 📳
You can support me by buying a cup of coffee ☕ bit.ly/3wfnmrg
👍 Support: bit.ly/3Clr0E3
If u have any queries drop an email @ [e-mail] 📧
In this video we have covered, what is VIEW and explained its uses.
what is Simple View? Also explained how to use Simple View in oracle
Pseudo Column:
• PSEUDO COLUMN with exa...
Single Row subquery:
• SINGLE ROW SUB QUERY w...
Multi Row subquery:
• MULTI ROW SUB QUERY wi...
Inline View:
• INLINE VIEW with examp...
Oracle SQL in Tamil Playlist:
• Oracle SQL in Tamil
Foreign Key: • FOREIGN KEY - CONSTRAI...
Check Constraint: • CHECK - CONSTRAINT wit...
Unique Key : • UNIQUE KEY - CONSTRAIN...
Primary Key: • PRIMARY KEY - CONSTRA...
DML - Delete: • DML - DELETE with ex...
DML - Merge: • DML - MERGE with exa...
DML - Update: • DML - UPDATE with ex...
DML - Insert: • DML - INSERT with ex...
DDL part 2: • DDL - (ALTER - Add, M...
How to create table in oracle database
DDL part 1: • DDL - (Create, Renam...
Relational operators: • Relational Operators w...
Datatypes in Oracle: • DATATYPES in SQL | Ora...
#oracleintamil
#oraclesqlintamil
#oracledatabaseintamil
#oracletamiltutorials
#oracleviewexample
#typesofviewsinoraclewithexamples
#typesofviewsinoracle
#viewsinoraclesql
#advantagesofviewsinoracle
#whatisaviewinoracle
#howtocreateviewinoracle
#createorreplaceviewinoracle
#createviewinoracle
#Dropviewinoracle
#simpleviewinsql

[@sangavilogu5925]

Hi, Your video was awesome. You have clearly explained the complex topics in simple way. Kindly upload the triggers, cursors and packages concepts. It will really helps to learn!!

[@chilambarasan1213]

Good explanation bro

[@ezhumalai4991]

Good explain

[@jiivasiva6744]

Hi BRO, please upload SQL loader and external table....

[@meenameenukutti1086]

👍👍

[@allinall358]

Nalla solli kiduthinga bro ana ethana ok va

[@learncodetodaytamil]

Flow la varuthu bro. Don't worry will recreate the SQL series without ok va.

[@ramniki2795]

Hi bro video explanation is very nice.but I have one doubt.dml view use panna base table entha changes aakathu thana.please tell me

[@learncodetodaytamil]

What is view?
Complex query a database la store panrathuku view use panrom..
Where complex query getting data?
Normalla, yeppa ellam nama query run panromo Oracle gets data from the underlying base table. Incase of complex query namma multiple table use panni result ta get panrom... i.e view act as a 3rd party.. whenever we apply DML operation on view it will affect the base table bcoz view does not have/hold any data of its own instead getting data from base table... So it will affect base table....
While performing DML operation on view we have some restrictions... We cannot directly apply DML on the complex views(getting data from multiple table) in this case we have to use INSTEAD OF TRIGGERS to do DML operations

[@ramniki2795]

Thanks lot bro...

[@karthinsk4866]

Broo neega Institute yethachi run pantrigala?

[@learncodetodaytamil]

No, bro..