XR0ng

SQL Server 2008功能选择

set ORACLE_SID = ORCL; sqlplus /nolog connect sys/1234 as sysdba; alter tablespace tablespace_name offline; alter database rename file '......\tablespace_name.dbf' to '......\tablespace_name.dbf'

将hregright表中不存在hrno的记录，用house表中的hrno填充（house唯一的时候） declare cursor house_cur is select h.regno,h.hrno from house h where h.hrno is not null group by h.regno,h.hrno having count(h.r