Today I have faced interview and they have asked this question as well... Luckily I saw this video, before interview and immediately I have answered...Thanks A Lot dear for posting such a useful video... YOU WILL BE THERE IN EVERY CANDIDATE'S SMILE, WHEN THEY GET OFFER....
Start 0:09 - Decode and Case 0:45 - Understand Using Examples 2:00 - Same Thing Using Case Statement 2:45 - To Print Pass or Fail 4:01 - Exactly Same Functionality from Case statement 5:38 - Let us see with one more example 6:40 - Few more differences now 8:26 - Few More Example 9:25 - One more difference
Hi sir, Thanks for uploading videos! could please help me on 1)How pipeline function will work 2)How to make the non partitioned table into to partitioned 3)How select * from emp (How internally worked (Capgemini asking)) 4)Performance tunning related real time eg we want 5) Different pragmas in oracle 6) can we create index on view 7)can we create index on Materialized view 8)Can we create trigger insdide the procedure or can we create the procedure inside the trigger 9)How to calculate age of the person
Hi sir, when you use case in plsql in the declare section for variable you assigned value 'P' only but in the execution asking when 'F' then fail..... how it will work please explain
I really like your explanation...I should have viewd your videos in past which would be have been helpful to learn....I was expecting you to say how decode perform with order by clause in this video
@@SivaAcademy questions is column name payment status as values is 'sent' another one 'failed' and another column name is payment mode as 'web' and 'ivr' ...I want payment status sent then web and failed status then Ivr and again continuously payment mode web then D and ivr then I .....if you possible to get the records?
Hi Siva, Can you answer the below sql scenario based question. Write a SQL for below scenario - Table named Departures contains departure airport codes and Table named Arrival contains arrival airport codes.A person is travelling from airport A (&&dep) to airport B (&&arr),IF both the airport codes A and B are in Departures table, query should return D-DIF both the airport codes A and B are in Arrivals table, query should return A-AIF A is in Departures and B is in Arrivals table, query should return D-AIF B is in Departures and A is in Arrivals table, query should return A-D
Can you please put a sample data and expected output In excel format and send to my mail siva.k.academy@gmail.com, will post back once I am clear on requirement and expected output
Please make a video on joining methods like hash join ,nested loop and merge join although there are so many videos on you tube but there is no sense and hard to understand
Today I have faced interview and they have asked this question as well... Luckily I saw this video, before interview and immediately I have answered...Thanks A Lot dear for posting such a useful video... YOU WILL BE THERE IN EVERY CANDIDATE'S SMILE, WHEN THEY GET OFFER....
Its my pleasure 😊, best wishes bro 💐💐💐
Start
0:09 - Decode and Case
0:45 - Understand Using Examples
2:00 - Same Thing Using Case Statement
2:45 - To Print Pass or Fail
4:01 - Exactly Same Functionality from Case statement
5:38 - Let us see with one more example
6:40 - Few more differences now
8:26 - Few More Example
9:25 - One more difference
Simply superb
Thank you
Hi sir,
Thanks for uploading videos!
could please help me on 1)How pipeline function will work
2)How to make the non partitioned table into to partitioned
3)How select * from emp (How internally worked (Capgemini asking))
4)Performance tunning related real time eg we want
5) Different pragmas in oracle
6) can we create index on view
7)can we create index on Materialized view
8)Can we create trigger insdide the procedure or can we create the procedure inside the trigger
9)How to calculate age of the person
Please make few videos on debugging ora errors by making anonymous block
Nice Explanation
Thank you 🙏
Excellent sir
Welcome Raj
REALLY VERY NICE VIDEO, THANKS A LOT FOR EXPLANATION DEAR
@Aakash, thanks for your comments bro 🙏
Awesome explanation ... 👍
Thanks 🙂
Good information Provided
Thank you :-)
Do we have any limit for decofe
Which one is good in performance?
Loved all your tutorial videos and the in-depth knowledge you shared.. hope you share some videos on hints.. thanks 🙏
My pleasure, thank you 🙏, please stay tuned 👍
Awesome explanation.. thanks 🙏
Thank you 💐
Thank you sir.. explain very nicely 🙏
Welcome bro
Pls explain the procedure in pragma autonomous transaction in plsql
@Dinesh, will be posting soon on autonomous transaction, please stay tuned
How we can define parenthesis for each statement I have lot of confusion in defining parenthesis I.e,(commas,double quotes,colons,square brackets etc)
Sir really ur videos very useful for the interviews..keep do well...we are all supporting u
Thank you very much bro
Hi Sir
Can we use both (case ,decode ) in where clause
excellent bro...tq and love you
Welcome bro 💐💐💐
Could u pls make a video on clustered index and non clustured index if already exity pls share link
Thankuuu so much sir...u r doing great thing :)
Welcome
what about sql psql online classes plan shiva sir ..
sure bro, pls stay tuned
thq sir nice explaination
Welcome bro 💐🙏
Very nice. Thank you
It's my pleasure. Thanks for your comment :-)
Hi Sir, could u pls make a video on dirty read problem and their solution
Hi sir your fantastic tq somuch for ur effort #deepika
Welcome 💐🙏
Hi sir, when you use case in plsql in the declare section for variable you assigned value 'P' only but in the execution asking when 'F' then fail..... how it will work please explain
Awesome, thank you again Siva, your videos are the best!
Regards,
Sujaa
Thank you
Very good explanation.
I never got such examples.
Keep it up bro
@Prakash, Thanks for your comment bro.
why decode works with select statement in plsql procedure? any specific reason. how does it work internally?
can we call procedure through decode function in oracle?-- can u please create a video on it or reply in comment
No, we cannot
@@SivaAcademy thanks sir for quick response
Hi,
Can you please post the local index and global index
Sure, please stay tuned
Sir, thanks for the video.its helps alot..
Please post the query how to update 3 rows at one time with using decode and case clause.
Thank you
I really like your explanation...I should have viewd your videos in past which would be have been helpful to learn....I was expecting you to say how decode perform with order by clause in this video
Welcome bro
Super sir
Welcome 🙏 bro
Can't we use user definedfunction decode
fantastic job!
Thank you!
I need a queries for continuously two columns to change the data using dual
@Sharon, can you please elaborate your question with sample data and expected output
@@SivaAcademy questions is column name payment status as values is 'sent' another one 'failed' and another column name is payment mode as 'web' and 'ivr' ...I want payment status sent then web and failed status then Ivr and again continuously payment mode web then D and ivr then I .....if you possible to get the records?
Can you please post sample data and expected output you are looking for
@@SivaAcademy can you please give me your number and then I will contact you
Hi Sir Thank you for uploading useful videos like these
Sir Can you please help to answer the below question...
1.How to debug the code??
@Rupa, Sure, WIll post a seperate video on how to debug the code...Please stay tuned.
Thanks for your comment....Siva
Hi Sir, How to display Male and female values one by one row in a table, need 10 rows like this, please advice with query
Hi, can you please paste the souce table sample data and expected output format
Output is below
F
M
F
M
F
M
F
M
F
M
F
M
select case employees
when 'male' then 'M'
when 'female' then 'f'
else null
end as result
from employees
Can decode work with other datatype then String ?
Yes
Can you discuss about the performance of the above functions?
@Balaji, sure, will post performance in some other video, please stay tuned.
Can you please make video on Oracle server architecture with some best example
yeah, Please stay tuned.
Case & decode are like switch statement in java/c. Case allow expression evaluation
Hi Siva,
Can you answer the below sql scenario based question.
Write a SQL for below scenario -
Table named Departures contains departure airport codes and Table named Arrival contains arrival airport codes.A person is travelling from airport A (&&dep) to airport B (&&arr),IF both the airport codes A and B are in Departures table, query should return D-DIF both the airport codes A and B are in Arrivals table, query should return A-AIF A is in Departures and B is in Arrivals table, query should return D-AIF B is in Departures and A is in Arrivals table, query should return A-D
Can you please put a sample data and expected output In excel format and send to my mail siva.k.academy@gmail.com, will post back once I am clear on requirement and expected output
Decode can not be used in WHERE clause, while CASE can be, correct me if wrong.
Both are working in where conditions
Please make a video on joining methods like hash join ,nested loop and merge join although there are so many videos on you tube but there is no sense and hard to understand
Sure, please stay tuned, will cover in upcoming videos
Hello sir can u make some videos realted to plsql scheduling jobs and whats the neecessity of its in real practical life?
Sure please stay tuned
null=null is true when use decode function and it is false when use case statement
Hi sir.
Fantastic video.
Thank you .
1) How to find current week number?
To_char(sysdate,'w') , this returns the week of month, for more details, you can look into th-cam.com/video/E0NKvwuJu5c/w-d-xo.html
decode can use in DML statement .
Yes, we can use it...
Hi Siva, today in the interview they asked me that what if they dont want to use any of them,any substitute for case/decode?
if else, case bit more advance