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.
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
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.
Very very Thank you sir.
I see many videos for arthicmatic operation but get answer only from your video.
Thank you.
Thankyou sir..... very well explained 🙏 you are best teacher
this is my best techer in world❤
Thanks for sharing ur knowledge...how many days will it take to complete the whole syllabus?
2 months
I completed in 2 days
@@mountainshad0w322 you are a genius
Nice explanation sir.
Fantastic explanation ❤
Sir please upload a video on BCA detail syllabus for 1st year.
You are studying in ccsu
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
Completely understood
Plz Explain File organizations and types
Thank u sir g..
How to delete duplicate data in SQL query . Plz Tell ?
Sir computer network pe vedio bnaiye MCQ chapter wise
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.
Are bhai ye 4th column ban nhi rha hai yr DOJ vala isme data type no like ya varchar ....batao yr
Emp table main doj type kese banaya
Sir please upload the program to calculate hra, da, gross and net by using pl sql
Sir accept operation bhi hota hai kya DBMS mai
nice
Sir DOJ ko konsa data type liya hai
Varchar ya fir number mere me error aa rha hai
Varchar lie hai kyonki single quotes me date maine insert kia jo ki string consider kia jata hai.
I hope smjh gye hoge
@@LearnCodingOfficial thanks ho gaya run👍
Koi problem ho puchho🙏
@@LearnCodingOfficial 👍
@@LearnCodingOfficial how long it would take to learn complete SQL ?
Sie ye table kaise create kiya vo batao mera laptop mai to nhi ho raha hai
Create command se
Sir hum direct bhi update karke 30000 kR sakte he n?
Sir.... Oracle Database ka practical kis par krke dikhate h... Kya download krna h... Plz btaye... Oracle Database practical ke liye kya download kare
Download Oracle 10g or 11g or 19c any version
@@LearnCodingOfficial pls give me link
Sir range sarching opators pe video upload kegea
Agar apko sab employee ki salary increase krni he to kaise krenge please reply..
UPDATE employees
SET salary = salary + 1000;
@@LearnCodingOfficial
Sir yahi Kiya tha lekin where clause ki error aarhi he.
Query type krie comment me jo aap lga rhe ho
Aur ha reply zarur dena
Nice sir
First view
I have a question how can I code html and css with mobile
Pls reply
@@harshyadav1140 your solution-ua-cam.com/video/lMKEUQt90lU/v-deo.html
Terrible talker