Відео

Thankyou..Very Helpfull Video....

please make the music a bit louder. thanks!

👌👌👌

Hi, can you please share video for Course id : 58896 final assessment?

Hi sir, could you please share it in pdf

Hi, can you please check for a course id : 58896 final assignment?

mcqs answers for same course

Eknumber.

Boring Study❌ Study with fun ✅

bride's name will start with Ms. or Mrs ? what if there is no change in name after marriage for bride ?

Why you explain in English?🤔

Mira bhayander ke liye kya process follow krana hai...plz help

How user nd ticket is 1 to many

How can i download this image

I have the same spec, CRAZY 😮

Peaceful PC

Course id

Bas itna paisa mangta hai ki aisa pc apun khareed sake bhidu 😌

ram is too expensive That motherboard not supported 6000mt/s

Buy Motherboard around 20k

👌👌👌🎉🎉

Nice

👌👌👌

Amazing 🎉

Where is elite hub?? Can you please share address

Great pc even I have to purchase

health care project

Mam please old age home management system er diagram please

Where we get mcq after handson ? Any one any idea

Hello Ma'am, second visit me dono ko jana jaruri hai kya ?

ER diagram for online cab booking management system

Hi Does anyone have solution for the latest test cases... Unable to pass the exam

Hi Mam, My buddy has joined on 8th May 2024, I received a confirmation email but still have not received the amount, what should be the reason?

When we got married my husband age was 20 years can we apply for marriage certificate.

Mam ,Can we select the particular appointment date?

Thank you so much for helping me cuz I was searching a video like this for many hours and I finally found it here 🤗🤗

Hi mam/sir all the 4 queries are showing as incorrect answer can you provide solution file for all 4 sql queries.

Mam marriage Mumbai me thi par marriage ke baad ab Navi Mumbai mei rehte hai Dono ke aadhar card pe bhi navi Mumbai ka address. We have to apply in navi Mumbai or Mumbai?

Maine surco champion board purchase kiya hai... Mere board me poweder jamm jati hai aur wo area rough ho jata hai... Any idea why its happening??

Can u pls share latest questions and Answers And one more doubt is there any camara while writing the Assessment??

Is it only admin based porject please tell me ???

Thank you so much

Solution for 3rd SET SERVEROUTPUT ON; DECLARE v_dept_id dept.dept_id%TYPE; v_dept_name dept.dept_name%TYPE; v_dept_head dept.dept_head%TYPE; v_mgr_name VARCHAR2(100); CURSOR emp_cursor IS SELECT emp_id, emp_fname || ' ' || emp_lname AS emp_name, emp_status FROM emp WHERE emp_status = 'Active' AND dept_id IS NULL; CURSOR dept_cursor IS SELECT dept_id, dept_name, dept_head FROM dept WHERE dept_id NOT IN (SELECT dept_id FROM emp WHERE dept_id IS NOT NULL); BEGIN OPEN dept_cursor; FETCH dept_cursor INTO v_dept_id, v_dept_name, v_dept_head; CLOSE dept_cursor; IF v_dept_id IS NULL THEN DBMS_OUTPUT.PUT_LINE('No available department without employees.'); RETURN; END IF; SELECT mgr_fname || ' ' || mgr_lname INTO v_mgr_name FROM mgr WHERE dept_head = v_dept_head; DBMS_OUTPUT.PUT_LINE('Emp_id Emp_name Emp_status Dept_id Dept_name Mgr_name'); FOR emp_rec IN emp_cursor LOOP UPDATE emp SET dept_id = v_dept_id, mgr_id = v_dept_head WHERE emp_id = emp_rec.emp_id; DBMS_OUTPUT.PUT_LINE(emp_rec.emp_id || ' ' || emp_rec.emp_name || ' ' || emp_rec.emp_status || ' ' || v_dept_id || ' ' || v_dept_name || ' ' || v_mgr_name); END LOOP; COMMIT; /*DBMS_OUTPUT.PUT_LINE('Employees have been assigned to the department.');*/ END; /

Solution for 1st question SET SERVEROUTPUT ON; DECLARE v_active_count NUMBER; v_terminated_count NUMBER; BEGIN -- Counting Active and Terminated Employees SELECT COUNT(*) INTO v_active_count FROM EMP WHERE EMP_STATUS = 'Active'; SELECT COUNT(*) INTO v_terminated_count FROM EMP WHERE EMP_STATUS = 'Terminated'; DBMS_OUTPUT.PUT_LINE('**Status Count**'); DBMS_OUTPUT.PUT_LINE('Active' ||' ' || v_active_count); DBMS_OUTPUT.PUT_LINE('Terminated' ||' ' || v_terminated_count); DBMS_OUTPUT.PUT_LINE('**Employees under Terminated Manager**'); DBMS_OUTPUT.PUT_LINE('emp_id emp_name Mgr_name Mgr_Status Mgr_Supervisor'); FOR r IN ( SELECT E.EMP_ID, E.EMP_FNAME || ' ' || E.EMP_LNAME AS EMP_NAME, M.MGR_FNAME || ' ' || M.MGR_LNAME AS MGR_NAME, M.MGR_STATUS, M.MGR_SUPERVISOR FROM EMP E JOIN MGR M ON E.MGR_ID = M.MGR_ID WHERE E.EMP_STATUS = 'Active' AND M.MGR_STATUS = 'Terminated' ) LOOP DBMS_OUTPUT.PUT_LINE(r.EMP_ID || ' ' || r.EMP_NAME || ' ' || r.MGR_NAME || ' ' || r.MGR_STATUS || ' ' || r.MGR_SUPERVISOR); END LOOP; END; /

1,2,3 showing errors for me

thnx

500gms nahi..5gms

My friends number and email id already registered so when i am creating his profile, it is saying that the info already existed and profile is not creating. What can i do in this case?

Mam priest ki details nhi hai to kya kare aur wo is duniya me bhi nhi hai to kya kre mam please reply

isiliye to mai shadi nhi karra hun...