ocp-047-76

来源：互联网发布：编程思维青少儿编辑：程序博客网时间：2024/05/29 04:02

76. View the Exhibit and examine the structure of the ORDERS table.

Which UPDATE statement is valid?

SQL> UPDATE orders    2  SET order_date = '12-mar-2007',    3  order_total  IS  NULL    4  WHERE order_id = 2455    5  ;     UPDATE orders  SET order_date = '12-mar-2007',  order_total  IS  NULL  WHERE order_id = 2455     ORA-00927: 缺失等号  SQL> UPDATE  orders    2  SET order_date = '12-mar-2007',    3  order_total = NULL    4  WHERE order_id = 2455    5  ;     1 row updated      SQL> UPDATE orders    2  SET order_date = '12-mar-2007'    3  AND order_total  =  TO_NUMBER(NULL)    4  WHERE order_id = 2455    5  ;     UPDATE orders  SET order_date = '12-mar-2007'  AND order_total  =  TO_NUMBER(NULL)  WHERE order_id = 2455     ORA-00933: SQL 命令未正确结束SQL> UPDATE orders    2  SET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'),    3  SET order_total  =  TO_NUMBER(NULL)    4  WHERE order_id = 2455    5  ;     UPDATE orders  SET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'),  SET order_total  =  TO_NUMBER(NULL)  WHERE order_id = 2455     ORA-01747: user.table.column, table.column 或列说明无效