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

display your age in months?

Question Posted / sowmya makkena

Answers were Sorted based on User's Feedback



display your age in months?..

Answer / sowmya makkena

select floor(months_between(sysdate,'22-mar-1995')) "age in months" from dual;

Is This Answer Correct ?    1 Yes 0 No

display your age in months?..

Answer / siddharthapenchala

select trunc(months_between(sysdate,'22-mar-1995')/12) as age from dual;

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

What is sharding in sql?

0 Answers  

What is cte?

0 Answers  

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

Show code of a cursor for loop.

0 Answers  

How can we make an if statement within a select statement?

0 Answers  

what is the difference between $message and $$message? : Sql dba

0 Answers  

How to trace the errors in pl/sql block code?

5 Answers   TCS,

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

What does cursor do in sql?

0 Answers  

What are crud methods?

0 Answers  

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

For more SQL PLSQL Interview Questions Click Here
Categories