SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)

Показать описание

Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression.
● What Is Case Expression
● Syntax of Simple Case Expression
● Query 1. Column name of a table as Search expression in CASE
● Query 2. String as Search expression in CASE

Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄

-------------------------------------------------------------------------
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!
--------------------------------------------------------------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Рекомендации по теме

Комментарии

Gracias a tu ejemplo pude ver qué me faltaba una comillas, eres el mejor.

TheEduardoR

bro you should put this video in your pl SQL playlist for convenience of viewers, and please speak slowly so that we can understand, and your videos are very helpful for us and full of information, thanks 👍

SunilKumar-iejh

Hi Manish, your content was good but you have to speak slowly, while you explaining something then everyone can understand easily .

venkysfdcqa

Sir can u provide a tutorial for mapping like one to many

priyakumarijaiswal

IF I take a number in condition then error occur, how resolve this error ?
query:
SELECT ENAME, DEPTNO,
(CASE DEPTNO
WHEN 1O THEN 'IT'
WHEN 20 THEN 'COMP'
WHEN 30 THEN 'CIVIL'
WHEN 40 THEN 'ENTC'
ELSE 'OTHER'
END
) AS DEPT_NAME
FROM EMPLOYEE;
error :ORA-00905: missing keyword
00905. - "missing keyword"
*Cause:
*Action:
Error at Line: 140 Column: 17

pradnyeshdoshi

SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)

SQL tutorial 49: CASE - Simple Case Expression in Oracle Database (1/2)

49 Mastering SQL Server CASE Statement

Oracle SQL How to use CASE and DECODE Part 1 - Lesson 49

Intermediate SQL Tutorial | Case Statement | Use Cases

Writing CASE WHEN Statements in SQL (IF/THEN)

SQL tutorial 50: CASE - Searched Case Expression In Oracle (2/2)

SQL Tutorial - CASE Statements

SQL: CASE Statement (WHEN - THEN - ELSE)

Case Statement in SQL Server | SQL Case Statement Examples | SQL Case Statement Tutorial

PL/SQL tutorial 49: Declare user define exception using PRAGMA EXCEPTION_INIT in Oracle Database

CASE STATEMENT IN SQL WITH 3 EXAMPLES | SQL TUTORIAL FOR BEGINNERS

SQL CASE

SQL Tutorial - Nesting CASE statements

Advanced SQL Tutorial | String Functions + Use Cases

SQL Server Queries Part 5 - CASE Expressions

What is the use of CTE (common table expression) SQL Server Interview Questions ?

SQL Case Statement with Subquery | Temidayo Omoniyi

SQL Case Anweisung - SQL Tutorial #DEUTSCH/GERMAN

SQL tutorial: CASE - Simple Case Expression in Oracle Database

SQL Tutorial - Full Database Course for Beginners

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

#49 Exists Operator in SQL | SQL Tutorial

SQL Tutorial - Additive CASE statements

SQL Tutorial for Beginners