insert into test(fy1,fy2) (select sum(fy1) from table1,select sum(fy2) from table2);
解决方案 »
- PL/SQL 数据库里如何导出数据?
- Oracle监听问题(OracleOraDb10g_home1TNSListener)帮忙解决一下。
- 急急急 要写一个超长的sql语句 路过的指点一二感激不尽!
- 求ORACLE恢复的相关资料,本人想了解一下这方面的知识
- 数据类型转换问题 下午就要交了 谢谢 高手速赐教
- 通过定义文本格式实现数据从外部导入?
- oracle 求助帮写 存储过程 刚接触oracle
- 如何在oracle中建视图?帮忙看看这个语句对吗?
- 散分!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- centos静默安装oracle11g报错,求帮助
- ORA-12154: TNS: 无法处理服务名错误怎么处理?
- 如何创建一个Employee表
select fy1 ,fy2 from (select sum(fy1) as fy1 from table1,select sum(fy2) as fy2 from table2);
select fy1 ,fy2 from (select sum(fy1) as fy1 from table1,select sum(fy2) as fy2 from table2);
这样写吗?用insert into test(fy1,fy2) values(select sum(fy1) from table1,select sum(fy2) from table2)这样的格式难道真没法吗?
insert into test(fy1,fy2) values((select sum(fy1) from table1),(select sum(fy2) from table2));