DECLARE l_employee employees%ROWTYPE; BEGIN SELECT * I

Fetch an entire row from the employees table for a specific
employee ID:

Question Posted / suresh ku patra

2 Answers
5217 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

Please Help Members By Posting Answers For Below Questions

where are cookies actually stored on the hard disk? : Sql dba

1017

What is pl/sql table? Why it is used?

1024

What are the set operators in sql?

1056

Why use triggers in sql?

931

How do I write a sql query in pgadmin 4?

962

Explain the advantages and disadvantages of stored procedure?

1133

What are all the different normalization?

1024

what is the difference between truncate and delete statement? : Transact sql

1045

What is a constraint?

998

Why is %isopen always false for an implicit cursor?

1086

What is the difference between functions, procedures, and packages in pl/sql?

1024

How do I tune a sql query?

959

Define select, insert, create, delete, update, drop keywords

1035

Can we use ddl statements in stored procedure sql server?

990

Does inner join return duplicate rows?

962