Fetch an entire row from the employees table for a specific
employee ID:
Answer Posted / suresh ku patra
DECLARE
l_employee employees%ROWTYPE;
BEGIN
SELECT *
INTO l_employee
FROM employees
WHERE employee_id = 138;
DBMS_OUTPUT.put_line (
l_employee.last_name);
END;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is timestamp in mysql? : Sql dba
What is the difference between partition and index?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is before and after trigger?
what is a field in a database ? : Sql dba
Why do we use partitions in sql?
What is the meaning of disabling a trigger?
What is replication id?
What is sql comments?
What is query execution plan in sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Explain what is a database?
What is trigger types of trigger?
Why partition by is used in sql?
What operators deal with null?