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

What is the difference between Union and Union all. Which is faster.

0 Answers  

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

what are rollup and cube in t-sql? : Transact sql

0 Answers  

How do sql triggers work?

0 Answers  

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  




Is sql harder than python?

0 Answers  

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

what is explain plan?, given an example...

3 Answers   Polaris,

Explain Connect by Prior?

2 Answers  

what is user defined functions? : Sql dba

0 Answers  

how to findout the 100th maximum salary

28 Answers   Amdocs,

What is difference between pls_integer and integer?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories