一条sql语句可以同时插入,删除两张表的数据么,怎么写(不用触发器,存储过程) 1.用一条sql语句同时删除两张表的某条数据(不要有级联删除)。2.用一条sql语句同时向两个结构相同的表中插入数据不用触发器,存储过程这样的sql语句可以写么 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 多表插入用9i就可以实现,但多表删除好象Oracle没有这种sql支持INSERT ALL INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date, sales_sun) INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date+1, sales_mon) INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date+2, sales_tue) INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date+3, sales_wed) INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date+4, sales_thu) INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date+5, sales_fri) INTO sales (prod_id, cust_id, time_id, amount_sold) VALUES (product_id, customer_id, weekly_start_date+6, sales_sat)SELECT product_id, customer_id, weekly_start_date, sales_sun, sales_mon, sales_tue, sales_wed, sales_thu, sales_fri, sales_satFROM sales_input_table; 这是9i为了占领BI市场而推出的支持ETL的特性之一,上面的写法使用的是无条件多表,还有条件分支的多表,实现类似ETL工具中的ROUTER特性 String sql="delete table1,table2 from table1 LEFT JOIN table2 ON table1.id = table2.id where table1.id='1'";说明:table1的外键是id,id又是table2的主键 一个关于oracle用户授权管理的问题 Windows 7 怎样安装Oracle asp.net 与oracle问题 世界级Oracle专家权威力作 关于oracle两个很尴尬的问题 使用exp导出数据出错,请帮忙看一下! 各位xdjm们帮个忙呗。谢谢了。 如何每日自动备份 oracle怎么连接数据库客户端的地址登录上去 如何从千万记录数据中快速查询到结果-尽量短的时间内完成 oracle 日期相减得到的是什么类型的值? 启动失败,ORA-01122: 数据库文件 2 验证失败_急,请高手
INSERT ALL
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date, sales_sun)
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date+1, sales_mon)
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date+2, sales_tue)
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date+3, sales_wed)
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date+4, sales_thu)
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date+5, sales_fri)
INTO sales (prod_id, cust_id, time_id, amount_sold)
VALUES (product_id, customer_id, weekly_start_date+6, sales_sat)
SELECT product_id, customer_id, weekly_start_date, sales_sun,
sales_mon, sales_tue, sales_wed, sales_thu, sales_fri, sales_sat
FROM sales_input_table;
这是9i为了占领BI市场而推出的支持ETL的特性之一,上面的写法使用的是无条件多表,还有条件分支的多表,实现类似ETL工具中的ROUTER特性