Скачать с ютуб Detailed video on PLSQL Cursor (Hindi). в хорошем качестве

Detailed video on PLSQL Cursor (Hindi).

Thank you for your support, Please Like and Subscribe :-) -- Plsql Cursor ---------------------------------------Table Creation----------------------------------------------- CREATE TABLE EMP_IND (EMPLOYEE_ID NUMBER(6) NOT NULL ENABLE, FIRST_NAME VARCHAR2(20), SALARY NUMBER(8) ); ---------------------------------------Data Insert-------------------------------------------------- INSERT INTO EMP_IND (EMPLOYEE_ID, FIRST_NAME, SALARY) VALUES (101, 'John', 50000); INSERT INTO EMP_IND (EMPLOYEE_ID, FIRST_NAME, SALARY) VALUES (102, 'Alice', 60000); INSERT INTO EMP_IND (EMPLOYEE_ID, FIRST_NAME, SALARY) VALUES (103, 'Robert', 55000); INSERT INTO EMP_IND (EMPLOYEE_ID, FIRST_NAME, SALARY) VALUES (104, 'Sophia', 70000); INSERT INTO EMP_IND (EMPLOYEE_ID, FIRST_NAME, SALARY) VALUES (105, 'David', 65000); ---------------------------------------Select Query------------------------------------------------- Select * from EMP_IND; ---------------------------------------Cursor Example Code------------------------------------ / Set ServerOutput on; Declare V_Salary Number(8); V_Emp_Name varchar2(50):='John'; Cursor C1_Sal is SELECT Salary FROM EMP_IND WHERE First_Name = V_Emp_Name; Begin Open C1_Sal; Fetch C1_Sal into V_Salary; if C1_Sal%notfound then V_Salary := 9999; end if; Close C1_Sal; DBMS_OUTPUT.PUT_LINE('Employee Salary is ' ||V_Salary); End;