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

Is it important to partition hard disk?

0 Answers  

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

what is log shipping? : Sql dba

0 Answers  

what is the syntax for using sql_variant_property? : Transact sql

0 Answers  

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  




How to get list of all tables from a database?

0 Answers  

How do I install sql?

0 Answers  

How do you update a table in sql?

0 Answers  

What is a scalar value in sql?

0 Answers  

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

How do I sort a table in sql?

0 Answers  

What is the difference between delete, truncate and drop command?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories