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

Can we insert data in view?

0 Answers  

How do you update a sql procedure?

0 Answers  

How do you update a value in sql?

0 Answers  

What is sap sql anywhere?

0 Answers  

Explain what is a database?

0 Answers  




How can I get the number of records affected by a stored procedure?

0 Answers  

What is memory optimized table?

0 Answers  

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

How many tables can a sql database have?

0 Answers  

how to create a new table by selecting rows from another table in mysql? : Sql dba

0 Answers  

Can we debug stored procedure?

0 Answers  

Which join condition can be specified using on clause?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories