SELECT *
FROM policy;
Policy_ID Customer_ID Policy_Type Policy_Details
--------- ----------- ----------- ------------------
541077 766492008 AU STD-CH-344-YXY-00
541008 246824626 AU STD-CH-345-NXY-00
541145 616035020 AU STD-CH-348-YXN-01
SELECT policy.*, validity
FROM Policy;
Policy_ID Customer_ID Policy_Type Policy_Details Validity
--------- ----------- ----------- ----------------- ------------------------
541077 766492008 AU STD-CH-344-YXY-00 ('09/12/21', '99/12/31')
541008 246824626 AU STD-CH-345-NXY-00 ('09/10/01', '99/12/31')
541145 616035020 AU STD-CH-348-YXN-01 ('09/12/03', '10/12/01')
適用期間を含むSEQUENCED VALIDTIME問合わせでvalid-time列を参照することはできません。