Write a program in PL/SQL to FETCH multiple records and more than one columns from the same table
- pl/sql
- 2021-09-28
- mhanasmh00489829403
الأجوبة
DECLARE
v_emp_rec employees%ROWTYPE;
CURSOR cur_emp_name IS
SELECT *
FROM employees;
BEGIN
OPEN cur_emp_name;
LOOP
FETCH cur_emp_name INTO v_emp_rec;
exit WHEN cur_emp_name%NOTFOUND;
dbms_output.Put_line('Name: '
|| v_emp_rec.first_name
|| ' :: Salary: '
|| v_emp_rec.salary);
END LOOP;
CLOSE cur_emp_name;
END;
/Sample Output:
SQL> / Name: Steven :: Salary: 24000 Name: Neena :: Salary: 17000 Name: Lex :: Salary: 17000 Name: Alexander :: Salary: 90 Name: Bruce :: Salary: 6000 Name: David :: Salary: 4800 Name: Valli :: Salary: 4800 Name: Diana :: Salary: 4200 Name: Nancy :: Salary: 12008 Name: Daniel :: Salary: 9000 ...
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة