Oracle语法: UPDATE TableName SET (column1[,column2...])= (SELECT column1,[,column2...] FROM TableName1 [WHERE where_definition])Oracel 示例:update t_fare_info t set (t.currency_code, t.fare_type, ...(more)
SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/u02/sheng/SYSTEM01.DBF'SQL> recover datafile 1;ORA-00283: recovery session canceled due t...(more)