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

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

What is the difference between sql and mysql?

0 Answers  

How run sql*plus commands that are stored in a local file?

0 Answers  

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

Explain autonomous transaction.

0 Answers  

What are analytic functions in sql?

0 Answers  

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

What are the sql commands?

0 Answers  

What is trigger price?

0 Answers  

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories