Oracle基础语句
表server_hospital 有一个字段ID,设为自动增加(用触发器做的)
我要从wh_d_hospital查出数据插入到这个表里,下面的语句,总是提示我没有足够的值,求:应如何书写

insert into server_hospital select code as hospitalcode,name as hospitalname, '192.168.0.7 ' as serverip, '192.168.0.7 ' as servername, 'tjwy ' as databasename, 'sa ' as loginname, ' ' as password from wh_d_hospital



[解决办法]
insert into server_hospital(除id以外的字段)
select code as hospitalcode,name as hospitalname, '192.168.0.7 ' as serverip, '192.168.0.7 ' as servername, 'tjwy ' as databasename, 'sa ' as loginname, ' ' as password from wh_d_hospital