Write a simple program on cursors
Answers were Sorted based on User's Feedback
Answer / a.jyothsna
declare
cursor cur_t is select * from test;
var_t test%rowtype;
begin
open cur_t;
loop
fetch cur_t into var_t;
exit when cur_t%notfound;
dbms_output.put_line('a: ' || var_t.a || ', b: ' ||
var_t.b);
end loop;
end;
/
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / subhendu
CREATE OR REPLACE Function test( I_name IN varchar2 )
RETURN number
IS
CURSOR c1
IS
SELECT course_number,
instructor
from courses_tbl
where course_name = I_name
FOR UPDATE of instructor;
v_number courses_tbl.course_number%type;
v_instructor courses_tbl.instructor%type;
BEGIN
open c1;
fetch c1 into v_number,v_instructor ;
if c1%found then
UPDATE courses_tbl
SET instructor = 'SMITH'
WHERE CURRENT OF c1;
COMMIT;
end if;
close c1;
RETURN v_number;
END;
Is This Answer Correct ? | 5 Yes | 1 No |
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Does truncate require commit?
Why do we use %rowtype & %type in plsql?
What are all the different normalization?
What is the difference between rename and alias?
What are the data types allowed in a table?
In pl/sql, what is bulk binding, and when/how would it help performance?
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
What is an implicit commit?
What is pl sql variable?
What problem one might face while writing log information to a data-base table in pl/sql?
diff b/w function and procedure?