NULL FUNCTION with example | Oracle SQL tutorial in TAMIL
HTML-код
- Опубликовано: 21 окт 2024
- Oracle SQL tutorial in TAMIL | Null Function - Single row function | SQL tutorial for beginners in Tamil @learncodetodaytamil
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 📳
If u have any queries drop an email @ blog.learncode@gmail.com 📧
In this video we have covered, what is Null Function with examples.
also covered what is NVL,NVL2,NULLIF,COALESCE Function
Channel link: / @learncodetodaytamil
Oracle SQL Playlist:
• Oracle SQL in Tamil
Oracle PL/SQL Playlist:
• Oracle PL/SQL in Tamil
Oracle SQL & PLSQL Interview & Practical Questions Playlist:
• Oracle SQL & PLSQL Int...
➤ Single Row Function:
Null Function: • NULL FUNCTION with exa...
String Function: • STRING FUNCTION with e...
Number Function: • NUMBER FUNCTION with e...
Date Function: • DATE FUNCTION with exa...
Conversion Function: • CONVERSION FUNCTION wi...
➤ Aggregate Function: • AGGREGATE FUNCTION wit...
➤ Index:
Introduction: • INDEX - Introduction w...
B-Tree index: • B-TREE - INDEX with ex...
Bitmap index: • BITMAP - INDEX with ex...
Composite index: • Video
Unique index: • UNIQUE - INDEX with ex...
Function based index: • FUNCTION BASED - INDEX...
Index Organized index: • INDEX ORGANIZED TABLE ...
➤ Set Operator:
Introduction: • SET OPERATORS - Introd...
Union: • UNION - SET OPERATOR w...
Union All: • UNION ALL - SET OPERAT...
Intersect: • INTERSECT - SET OPERAT...
Minus: • MINUS - SET OPERATOR w...
➤ Materialized view
Complete Refresh: • COMPLETE REFRESH -MATE...
Fast Refresh: • FAST REFRESH - MATERIA...
Force Refresh: • Force Refresh - MATERI...
➤ Pseudo Column: • PSEUDO COLUMN with exa...
➤ Sub Query:
Single Row subquery: • SINGLE ROW SUB QUERY w...
Multi Row subquery: • MULTI ROW SUB QUERY wi...
Inline View: • INLINE VIEW with examp...
➤ Joins:
Cross join: • CROSS JOIN with exampl...
Equi join: • INNER JOIN with exampl...
Left outer join: • LEFT OUTER JOIN with e...
Right outer join: • RIGHT OUTER JOIN with ...
Full outer join: • FULL OUTER JOIN with e...
Self join: • SELF JOIN with example...
➤ Constraints:
Foreign Key: • FOREIGN KEY - CONSTRAI...
Check Constraint: • CHECK - CONSTRAINT wit...
Unique Key : • UNIQUE KEY - CONSTRAIN...
Primary Key: • PRIMARY KEY - CONSTRA...
➤ SQL Subsets - TCL: • TCL with examples | Or...
➤ SQL Subsets - DCL: • DCL with examples | Or...
➤ SQL Subsets - DML:
Delete: • DML - DELETE with ex...
Merge: • DML - MERGE with exa...
Update: • DML - UPDATE with ex...
Insert: • DML - INSERT with ex...
➤ SQL Subsets - DDL:
How to create table in oracle database
DDL part 1: • DDL - (Create, Renam...
DDL part 2: • DDL - (ALTER - Add, M...
➤ Relational operators: • Relational Operators w...
➤ Datatypes in Oracle: • DATATYPES in SQL | Ora...
#oracleintamil
#oraclesqlintamil
#oracledatabaseintamil
#oracletamiltutorials
#sqlfunctions
#sqlfunctionslist
#sqlfunctionexample
#createsqlfunction
#sqlfunctionarguments
#singlerowfunctioninoracle
#nullfunctioninsql
#nullfunctioninoracle
#nullfunction
#nullfunctionoracle
#nullfunctioninoracle
#nullfunctioninsqloracle
#sqlnvlfunctionoracle
#differencebetweennvlandnvl2functioninoracle
#differencebetweennvlandcoalescefunctioninoracle
#whatisnvlfunctioninoracle
#nvl2functioninoracleexample
#nvlnvl2nulliffunctioninoracle
#nvl2oracleexample
#oraclenulliffunctionexample
#whatisnullifinoracle
#nullifinsqlexample
#oraclesqlnulliffunction
#coalescefunctionoraclesql
#useofcoalescefunctioninoracle
#coalescefunctioninoracleexample
#sqlcoalescefunctionoracle
#whatiscoalescefunctioninoracle
Very clear explanation ..keep rocking
Thank u!!!
THANKS SIR VERY USEFUL VIDEO
100 like😊bro
Thank u!!!
Hey there, keep up the good work in this channel.
I have a general enquiry as a new sql learner.
What is the major difference between primary key and unique unique.. In what way they are different inside sql syntax?
Thanks for taking care of this.
Primary key will not allow duplicate and null values whereas unique key will not allow duplicate values and allow null values.
To know more about these check the below link
Primary key: ruclips.net/video/3Mwqb90z2b8/видео.html
Unique key: ruclips.net/video/zGZFxisDIBs/видео.html
Thank you sir.please post with interview questens oda video podunga sql functions sir.
The SQL series is to understand the basic concept. Will post the sql function interview questions in separate video
@@learncodetodaytamil ok sir.
Hi sir plsql course full video iruka sir
Sir... Please upload remaing funtions
Sure... pls check out the below links for other function
string function: ruclips.net/video/Ndqtpk3Y_tg/видео.html
number function: ruclips.net/video/pEOPs42g6Ao/видео.html
Date function will be uploaded today@6PM
conversion function will be available by tomorrow...