1:06 - NVL - Means NVL will return the 1st Not Null Expression with only 2 inputs 2:02 - In Case both values are NULL 2:45 - NVL 2 4:25 - NULLIF 5:52 - Coalesce
Hi siva, I have got few more questions 1. Difference between local and global index 2. Before we go for partitioning table what are the things we should analyse 3.where should I declare a procedure which should not be accessed by anyone 4. How to dynamically pass parameters to one cursor from another cursor
Write a query to display Salesid , SalesNo ,discount ,price of a mobile. if there is no discount for a mobile the display it as"not applicable"......use COALESCE function...!Sir can u help me with this query?
Nice videos. Please include NULLIF(NULL, NULL) in this video. Obviously, the result we know based on previous example but it would be nice to include that.
Hi Thank you for the so much informative videos.. I was asked a question in interview about difference between varchar and varchar2 datatype in oracle. Can you explain the difference please?
Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand. It will be very thankful, if you make video on this. Thanks in advance cheers.
Managements wants to know the manager of each resort. Display resortid , resort name, manager name and his phone. Sort the output in ascending order of resort id. Give alias to manager name as MANAGERNAME and phone as PHONENO. If manager is not available then display manager name 'NA'. If phone number is not available then display as 'NA'. Sir can I get an answer for this please
@Anandhi, "NVL", and "coalesce" functions are widely used, and most of the SQL developers would have used it day to day sql queries, however nullif and nvl2 are rarely used, depends on the functionality. NVL - will be used when ever you want to have a default value for nulls, for eg, if the date is null, you can consider sysdate as default value. coalesce - To get the fist not null expression in the given list of values, for eg, NVL( mobile_no1,mobile_no2, LAN_LINE_NO, fax_no,0), to get the fist not null value of given list of contact numbers.....
These 4 5 7 minutes videos are better than reading hours and hours or going through 20 mins videos
I want this type of explanation to all concepts.....thanq.....
Complex concepts easy explanation thanks sir keep making such types of videos that helps to many students
Welcome Anil 🙂
1:06 - NVL - Means NVL will return the 1st Not Null Expression with only 2 inputs
2:02 - In Case both values are NULL
2:45 - NVL 2
4:25 - NULLIF
5:52 - Coalesce
1:06 - NVL
2:02 - In Case both values are NULL
2:46 - NVL 2
4:25 - NULLIF
5:52 - Coalesce
explanation is awesome and the way of teaching is very good to uderstand for the beginner
Welcome bro
Hi siva, I have got few more questions 1. Difference between local and global index 2. Before we go for partitioning table what are the things we should analyse 3.where should I declare a procedure which should not be accessed by anyone 4. How to dynamically pass parameters to one cursor from another cursor
@Bharathi, it's difficult to explain all of this in few lines, however I try my level best to answer in upcoming video
Hi sir your explanation is very well on each and every video and thank you very much to share with all
Welcome 🙏 🙏
Please make partitions, cluster's and ,inline view concepts in detailed sir
Thanks a lot.. very informative and easy to learn..
Welcome bro
Very useful information.. Thanks for this video
Welcome bro
Great explanation, thank you!
Thank you
What is different between varchar2 and varchar explain
very helpful information hatsoff sir
Write a query to display Salesid , SalesNo ,discount ,price of a mobile. if there is no discount for a mobile the display it as"not applicable"......use COALESCE function...!Sir can u help me with this query?
Thank you so much for good explanation video...!!
Thank you and welcome
What will be the result of below query :
Select nvl('',A) as result from dual;
Great explantions sir this content helped in interviews superbbb 😊😎
My pleasure 💐💐👍🙏
Please let me know how many parameters can we put in the COALESCE, GREATEST and LEAST functions ?
N numbers
Nice videos.
Please include
NULLIF(NULL, NULL)
in this video.
Obviously, the result we know based on previous example but it would be nice to include that.
Sure, for subsequent videos I will add all possible scenarios 👍
Result null
It throw inconsistent datatype..thumb rule for nullif is first parameter should not be null
As always in detail supeerrb !!!!
My pleasure bro
Thank you Sir, for your great explanation of these functions.
Welcome bro
excellent videos thank you sir
Welcome bro
can we get this as pdf ?
Hi Thank you for the so much informative videos.. I was asked a question in interview about difference between varchar and varchar2 datatype in oracle. Can you explain the difference please?
Hi sir, can you explain how to show nulls in all columns if I don't have queried data in a table.
Union with select null as col1, select col2 from dual
I need unix interview question ans production support related interview questions
What is the result of NULLIF( NULL,NULL)
since two nulls are not equal
As he said First argument should not have null. If so it throws error
Could you please make video on DBMS_parallel_execute and DBMS_jobs procedure.
Sure, please stay tuned
hi sir..can you take online classes
?
select coalsce('siva',1,2,3,4,5) as result from dual; why this one is not execute , tell me the reason
Data type of all the parameters should be consistent,
try this query
select coalesce('A','1','2','3','4','5') from dual;
Thank you so much
good
please make video on performance tuning
Thanks Sagar, Ya I am in process of creating PT with right examples, WIll be posting soon.
Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand.
It will be very thankful, if you make video on this.
Thanks in advance cheers.
Nice video ...very well explained
Welcome 🙏
Jay Ho Jay Hind 🇮🇳
Thank you som uch for the easy explanation
Welcome
Managements wants to know the manager of each resort.
Display resortid , resort name, manager name and his phone. Sort the output in ascending order of resort id. Give alias to manager name as MANAGERNAME and phone as PHONENO.
If manager is not available then display manager name 'NA'. If phone number is not available then display as 'NA'.
Sir can I get an answer for this please
select resortid , resort_name, nvl(manager_name,'NA') as "MANAGERNAME" , nvl(phone,'NA') as "PHONENO"
from table_name
order by resortid asc
What is difference between for and forall
Sure, please stay tuned, will add new video for this
in real time projects , where its been used.Please xplain bro
@Anandhi, "NVL", and "coalesce" functions are widely used, and most of the SQL developers would have used it day to day sql queries, however nullif and nvl2 are rarely used, depends on the functionality.
NVL - will be used when ever you want to have a default value for nulls, for eg, if the date is null, you can consider sysdate as default value.
coalesce - To get the fist not null expression in the given list of values, for eg, NVL( mobile_no1,mobile_no2, LAN_LINE_NO, fax_no,0), to get the fist not null value of given list of contact numbers.....
Nice understanding sir
My pleasure 💐
Thank You!!! Amazing explanation
Thanks for your comments 🙏 🙏🙏
Best Explanation!
Thank you 💐
Thank you so much Sir for your information
🙏🙏Welcome
Hi sir Please make partitions, cluster's and ,inline view concepts in detailed asap sir
Sure, please stay tuned
@@SivaAcademy tq sir
very good explanation
@Saptarishi, Thanks for your comment :-), --Siva
you nailed it sir thank you sir
Thank you
Nice explained
🙏🙏Thank you
Nice
Pls send for and forall
thnkx a lot
Welcome bro
I need unix interview question ans production support related interview questions