Updating fetch in plsql what is your opinion of online dating
DECLARE 2 CURSOR cur_get_employee IS 3 SELECT emp_id,emp_sal*0.01 bonus from employee; 4 BEGIN 5 FOR cur_get_employees_var INcur_get_employees LOOP 6 DBMS_OUTPUT.PUT_LINE(cur_get_employees_var.emp_id); 7 DBMS_OUTPUT. PUT_LINE(cur_get_employees_var.bonous); 8 END LOOP; 9 END; 10 / PL/SQL successfully executed.PLSQL Cursor is a name given to an area and can handle the memory used by oracle for processing the SQL statements.For instance, it is used to fetch a bunch of rows from the order table or update the year & revenue, and expense information in the DWS accounting tables.And, fetch the I_dept_id and I_dept_name into the syntax of PL/SQL, which is different from the sql statement.Here, it needs the number and type of variables to be declared to fetch the select column in the sql query.And, open the cursor to execute statements and then fetch the cursor record.After fetching, it will close the record and the cursor.
The developer cannot handle the implicit cursor if there is no explicit cursor associated with it.For example, fetching a single row from the department table.If we fetch more than one row like fetching the emp_id and emp_sal, it can be manipulated by 0.10.PLSQL Cursor is a fundamental and very important construct in PL/SQL.While issuing the select, update, insert or delete commands in SQL code, oracle creates an implicit cursor or an area in the memory to parse and execute the query and hold the results.
DECLARE 2 emp_rec emp_tbl%rowtype; 3 CURSOR emp_cur IS 4 SELECT * FROM WHERE salary>10; 5 BEGIN 6 OPEN emp_cur; 7 OPEN emp_cur; 8 FETCH emp_cur INTO emp_rec; 9 dbms_output.put_line(emp_rec.first_name||' '|| emp_rec.last_name); 10 CLOSE emp_cur; 11 END; 12 / PL/SQL program successfully executed In the above example, emp_rec has created the emp_tbl and a record with the cursor by altering the table name with the cursor name.