Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / suresh ku patra

Answers were Sorted based on User's Feedback



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

Answer / suresh ramsing

select * from employees where employee_id='1381';

Is This Answer Correct ?    4 Yes 0 No

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

Answer / 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

More SQL PLSQL Interview Questions

How do I run a pl sql procedure in sql developer?

0 Answers  

What is pivot table in sql?

0 Answers  

what is Difference between Having and Where clause?

5 Answers   IBM,

What does “select count(1) from tab” result?

10 Answers   IBM,

Explain how can you save or place your msg in a table?

0 Answers  




what are the different functions in sorting an array? : Sql dba

0 Answers  

When should I use nosql database?

0 Answers  

what are the types of join and explain each? : Sql dba

0 Answers  

How much does sql cost?

0 Answers  

What is number function in sql?

0 Answers  

Why use truncate instead of delete?

0 Answers  

Does execute immediate commit?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories