SQL: Arithmetic, Relational, Concatenation and Logical Operators | Oracle Database

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

Рекомендации по теме
Комментарии
Автор

Thanks for informative content Sir.

Just in case anybody wants to dig into "How to update multiple rows in a single query?" Below is the answer:

UPDATE EMP SET ESAL= CASE EID
when 10 then ESAL+1100
when 20 then ESAL*2
when 30 then ESAL/2
else ESAL end
where EID in (10, 20, 30);

Use above query to update multiple rows in a single query. Hope it helps.

RavinderSingh-zxho
Автор

Sair bahut vedio dekhne ke bad ye vedio me samjh aa gya kya mast explain kya he ❤️ ...

Sair aek vedio sql download pe bhi bana dijiye na please sair

brainignite-i
Автор

Very very Thank you sir.
I see many videos for arthicmatic operation but get answer only from your video.

Thank you.

stevemarshall
Автор

Thankyou very well explained 🙏 you are best teacher

shivamsinha
Автор

Thanks for sharing ur knowledge...how many days will it take to complete the whole syllabus?

swapnahoney
Автор

Sir please upload a video on BCA detail syllabus for 1st year.

nalinraj
Автор

Plz Explain File organizations and types

smilyvanni
Автор

Sir computer network pe vedio bnaiye MCQ chapter wise

anushkasrivastava
Автор

Sir accept operation bhi hota hai kya DBMS mai

ranajyoti
Автор

How to delete duplicate data in SQL query . Plz Tell ?

PradipKumar-lcqt
Автор

Sir DOJ ko konsa data type liya hai
Varchar ya fir number mere me error aa rha hai

vinaykamble
Автор

Are bhai ye 4th column ban nhi rha hai yr DOJ vala isme data type no like ya varchar ....batao yr

kamalrana
Автор

Sie ye table kaise create kiya vo batao mera laptop mai to nhi ho raha hai

gauravpatil
Автор

Sir hum direct bhi update karke 30000 kR sakte he n?

atulpatel
Автор

Sir range sarching opators pe video upload kegea

goluaashiqofficial
Автор

The time i am writing this.I am a class 11 student and currently it is 10:16PM 20/09/2022 tomorrow is my computer half yearly exam.

karunam.g
Автор

Sir please upload the program to calculate hra, da, gross and net by using pl sql

NagamaniNagamani-bufs
Автор

Hello Learn Coding can you tell me how to create date column in table
i have try
create table Emp(EID Number, ENAME Varchar(20), ESAL Number, DOJ Date));
But its not work
SQL> create table Emp(EID Number, ENAME Varchar(20), ESAL Number, DOJ Date));
create table Emp(EID Number, ENAME Varchar(20), ESAL Number, DOJ Date))
*
ERROR at line 1:
ORA-00922: missing or invalid option

RajatSingh-igqr
Автор

Sir.... Oracle Database ka practical kis par krke dikhate h... Kya download krna h... Plz btaye... Oracle Database practical ke liye kya download kare

softskill
Автор

Agar apko sab employee ki salary increase krni he to kaise krenge please reply..

vijay_madane
visit shbcf.ru