本人对SQLSERVER的存储过程比较了解,但对ORACLE都不懂.
请问在Oracle这些简单的存储过程怎么写.
insert into rooms(RoomRkey,roomlevel,total,roomprice,mansionrkey)
values('101','二等房','6','800','001')select * from rooms where roomrkey = '101'delete rooms where roomrkey = '101'update rooms set roomlevel = '一等房',roomprice = '1200' where roomrkey = '101'
本人对Oracel的刚入门,请高手赐教
分别把上面4个SQL语句改为4个带参数通用的存储过程.
请问在Oracle这些简单的存储过程怎么写.
insert into rooms(RoomRkey,roomlevel,total,roomprice,mansionrkey)
values('101','二等房','6','800','001')select * from rooms where roomrkey = '101'delete rooms where roomrkey = '101'update rooms set roomlevel = '一等房',roomprice = '1200' where roomrkey = '101'
本人对Oracel的刚入门,请高手赐教
分别把上面4个SQL语句改为4个带参数通用的存储过程.
解决方案 »
- timesten 11错误。。。 oracle连接失败。。
- 表数据的问题
- 数据库的国际化问题,请高手赐教
- 关于Oracle触发器的问题
- 新手求助:表比较大,又要多表查询,应该如何写sql语句
- (急,在线等)在linux下Oracle9i导出数据库出现942错误
- 请指教:关于Oracle文档?
- 请教关于表名的同义词的2个小问题。谢谢
- 这样的sql语句怎么写呢?
- 在局域网内安装和使用oracle8i有什么需要准备和设置的?
- Sequences备份恢复问题!!!急急急
- java.lang.IllegalStateException: Blobs may not be accessed after serialization
begin
insert into rooms
values(room_rkey,room_level,totals,room_price,mansion_rkey);
select * from rooms where roomrkey =room_rkey;
delete rooms where roomrkey =room_rkey;
update rooms set roomlevel ='一等房',roomprice = '1200' where roomrkey =room_rkey;
end;
/
execute proc_rooms('101','二等房','6','800','001');