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

interval year to month

Ahmad raza answered on October 4, 2023 Popularity 1/10 Helpfulness 1/10

answer interval year to month

related interval year to month

interval year to month

Comment

CREATE TABLE candidates (
    candidate_id NUMBER,
    first_name VARCHAR2(50) NOT NULL,
    last_name VARCHAR2(50) NOT NULL,
    job_title VARCHAR2(255) NOT NULL,
    year_of_experience INTERVAL YEAR TO MONTH,
    PRIMARY KEY (candidate_id)
);
INSERT INTO candidates (
    first_name,
    last_name,
    job_title,
    year_of_experience
    )
VALUES (
    'Camila',
    'Kramer',
    'SCM Manager',
    INTERVAL '10-2' YEAR TO MONTH
    );
Code language: SQL (Structured Query Language) (sql)

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.oracletutorial.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 04 2023

Ahmad raza

0 Answers Avg Quality 2/10

Closely Related Answers

interval year to month

Comment

CREATE TABLE candidates (
    candidate_id NUMBER,
    first_name VARCHAR2(50) NOT NULL,
    last_name VARCHAR2(50) NOT NULL,
    job_title VARCHAR2(255) NOT NULL,
    year_of_experience INTERVAL YEAR TO MONTH,
    PRIMARY KEY (candidate_id)
);
INSERT INTO candidates (
    first_name,
    last_name,
    job_title,
    year_of_experience
    )
VALUES (
    'Camila',
    'Kramer',
    'SCM Manager',
    INTERVAL '10-2' YEAR TO MONTH
    );
Code language: SQL (Structured Query Language) (sql)

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.oracletutorial.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 04 2023

Ahmad raza

0 Answers Avg Quality 2/10

interval year to month

Contents

More Related Answers

interval year to month

Closely Related Answers

interval year to month

Grepper

Documentation

Social

Legal

Contact

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