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

What is a primary key called that is made up of more than one field?

0 Answers  

How much ram can sql express use?

0 Answers  

What is the difference between function and procedure in pl/sql?

0 Answers  

Is sql sequential or random?

0 Answers  

Can we debug stored procedure?

0 Answers  




PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

What is the purpose of the primary key?

0 Answers  

What is oracle and pl sql?

0 Answers  

What is inner join in sql?

0 Answers  

Why is a trigger used?

0 Answers  

What is difference between cursor and trigger?

0 Answers  

What is the difference between local variables and global variables?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories