摘要： 1、创建视图CREATE OR replace VIEW my_view(id,stuname,stupassword)) AS SELECT s.id,s.stuame,item.stupassword FROM stu s,stu_item item WHERE item.fid=stu.id;2、使用视图SELECT * FROM my_view WHERE stuname='testname';3、查看视图创建语句SELECT TEST FROM my_view4、游标的创建和使用DECLARE CURSOR my_cur IS SELECT * FROM stu st 阅读全文