网友您好, 请在下方输入框内输入要搜索的题目:
TheINV_HISTORYtableiscreatedusingthecommand:
SQL>CREATETABLEINV_HISTORY(inv_noNUMBER(3),inv_dateDATE,inv_amtNUMBER(10,2))partitionbyrange(inv_date)interval(numtoyminterval(1,’month’))(partitionp0
valueslessthan(to_date(’01-01-2005’,’dd-mm-yyyy’)),partitionp1valueslessthan(to_date(’01-01-2006’,’dd-mm-yyyy’)));
ThefollowingdatahasbeeninsertedintotheINV_HISTORYtable:
INV_NOINV_DATEINV_AMT130-dec-20041000230-dec-2005200031-feb-2006300041-mar-2006400051-apr-20065000
Youwouldliketostorethedatabelongingtotheyear2006inasinglepartitionandissuethe command:
SQL>ALTERTABLEinv_historyMERGEPARTITIONS
FOR(TO_DATE(’15-feb-2006’,’dd-mon-yyyy’)),FOR(TO_DATE(’15-apr-2006’))INTOPARTITIONsys_py;
Whatwouldbetheoutcomeofthiscommand?()
参考答案