SQL

Jan 28

Extract

Which year did we have 300 days ago?

select extract (year from sysdate-300) from dual;

What Month did we have 10 days ago?

select extract(month from sysdate-10) from dual;

What day is today?

select extract(day from sysdate) from dual;

extract(xml-type-instance, 'xpath-expression')

extract(xml-type-instance, 'xpath-expression', 'name-space')

extract is similar to existsNode()