SQL Tutorial 51 Decode function in Oracle Database.
● What Is DECODE()
● DECODE ( ) vs CASE
● Syntax of DECODE()
● Query 1. String Matching using DECODE()
● Query 2. DECODE() comparing values form the COLUMN of the table
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
————————————————————————
►►►LINKS◄◄◄
Blog:
————————————————————————-
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
————————————————————————–
►Make sure you SUBSCRIBE and be the first one to see my videos!
————————————————————————–
Amazon Wishlist:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
You can also Email me at
RebellionRiderYT@gmail.com
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Nguồn: https://sangoivon.com
Xem thêm bài viết khác: https://sangoivon.com/cong-nghe/
How to apply decode based on multiple columns?
Thanku..
Manish I have a query…In the first column i have some IDs..I want to compare 1 id with 2nd…if they are equal then return a column value else return another column value…how do I do it?…it's basically if a2=a1 then u2 else x2 in excel language
Thanks a lot sir!
Thanks Manish …..
Awesome…The great thing about U is to make short tutorials still concept is Crystal clear..!!Thanks a ton!!
Hi Manish,Thanks for your time for oracle tutorial.I could not find date related funactions (to_date,to_char and to_number) functions.Please add those related vedios as well.
Manish do you have any pl/sql videos Thanks for your videos
Thanks A Lot !!! Liked and Shared ..
Hey Manish. Your videos are very clear to understand and thank your efforts
Please post the oracle sql interview point questions with answers for various scenarios
Manish we r earegly waiting for Oracle Architecture videos like Data files,Control files, Redo log files, SGA, PGA, Processes…..etc. We hope as early as possible u will upload them.
Once again thank U yar for helping us.
Hai Manish,
Ur videos r very useful to us. Thank U yar.