Breaking News: Grepper is joining You.com. Read the official announcement!

calcul age

Mossaâb Baccouch answered on May 6, 2022 Popularity 3/10 Helpfulness 1/10

answer calcul age

calcul age

Comment

SET SERVEROUTPUT ON
DECLARE
  --v_birthday_year         NUMBER(4)    := &v_birthday_year;
  v_dob                   DATE      := &v_dob 
  v_your_age              NUMBER(3, 1);
BEGIN
  v_your_age := TRUNC(MONTHS_BETWEEN(SYSDATE, v_dob))/12;  
  DBMS_OUTPUT.PUT_LINE ('Your age is ' || v_your_age);
END;
/

Popularity 3/10 Helpfulness 1/10 Language sql

Source: askcodez.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on May 06 2022

Mossaâb Baccouch

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

calcul age

Contents

More Related Answers

calcul age

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.