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
- 5331 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
How do I count rows in sql query?
How do I edit a trigger in sql developer?
What is the use of count (*) in sql?
What does t sql mean?
what are the 'mysql' command line arguments? : Sql dba
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is schema in sql?
How do you create an update query?
What do you mean by query optimization?
Is sql injection illegal?
What is benefit of creating memory optimized table?
How to disable a trigger name update_salary?
How run sql*plus commands that are stored in a local file?
Does truncate need commit?
What is rowid in sql?
