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
- 5264 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 an index in sql with example?
What does the file extension accdb stand for?
What are the limitations of sql express?
What is the use of non clustered index?
What is difference between inner join and self join?
what is rollback? : Sql dba
Mention what does the hierarchical profiler does?
What is sql used for?
What is difference between joins and union?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Which is better stored procedure or query?
What are the features of pl sql?
Define join and name different types of joins?
What are commit, rollback, and savepoint?
List out the acid properties and explain?
