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