DCL with examples | Oracle SQL tutorial in TAMIL
HTML-код
- Опубликовано: 18 фев 2022
- DCL 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
In this video we have covered, what is DCL and explained its use with examples.
Also, discussed the below points
1. How to create user and grant permission
2. What is role in oracle?
3. how to set a table to public?
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
#whatisconstraintinoracleintamil
#grantinoracleintamil
#DCLintamil
#oracletamiltutorials
#whatisroleintamil
#revokeinoracle
#advantagesofdclintamil
#dclwithexampleintamil
#all_users
#grantandrevokeintamil Наука
🙏🏽
Need More Plsql Topics Sir..
Clear Explanation Sir..Thank You..
NICE EXPLANATION SIR..😍
Thanks
Super na nalla purichathu well teaching and I am waiting for more videos.finally tq and one doubt enkitta oracle 10g software than irukku athu la intha maari tab option illa appo eppadi naa other user poyi type (coding) panna mudiyum.
Thanks! Neenga cmd(command prompt) use pannalam. Probably next video(TCL) la yeppadi use pannalam nu light ta solli irrukan...
Nice explanation 👌 sir.
Thank u
Bro sql developer which version u r using bro? Plzz reply
Database Oracle 11g Release 2
SQL Developer version 4.1.4.21
What is the role and responsibility of a Oracle DBA?
They are the ones who manages the DB and some of the roles & responsibility include DB upgrade, monitor and maintain the DB performance, data restore incase of system failure etc..
so schema and user name both are same
we call it according to developer or user
if we create a new user it will be a different schema
am I right?
Yes u r correct...
Hi bro antha left side la iruka connection table show aagala. Epdi thirumba enable panrathu
Go to view --> connections
Bro insufficient privileges error 01031 eppadi clear pantradhu
privilege grant pannunga bro... Neenga enna operation panringalo athukana privilege grant pannunga...
@@learncodetodaytamil ok bro thank you..🌝
@@learncodetodaytamil grant all privileges to user_name kuduthen varla bro command ena kudukurathu