Interested to Buy Any Domain ? << Click Here >> for more details...
Fetch an entire row from the employees table for a specific
employee ID:
- 2 Answers
- 5176 Views
- I also Faced
- E-Mail Answers
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 trigger price?
Is and as keyword in pl sql?
Can we insert data in view?
What is data abstraction in sql?
What is the sql case statement?
What is the difference between the implicit and explicit cursors?
How do I run a script in sql developer?
What is pessimistic concurrency control? : Transact sql
Describe sql comments?
What is the usage of sql functions?
Why we use cross join?
What are the three pl sql block types?
Why is pl sql used?
What is mutating error?
what is a primary key? : Sql dba
