Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

What is before and after trigger?

0 Answers  

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

what is the difference between where clause and having clause? : Sql dba

0 Answers  

What is constant in pl sql?

0 Answers  

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

How do I truncate a sql log file?

0 Answers  

What does truncate mean in sql?

0 Answers  

How does pl sql work?

0 Answers  

Explain what is a column in a table?

0 Answers  

What is a left join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories