存储过程和函数.docVIP

存储过程和函数 create function my_function return varchar2 is names varchar2(50); begin select name into names from biao return names; end; create proc proc_name as begin Create table users ( name varchar(20), age int, position varchar(20), ) Insert into users values(111,11,11111) Insert into users values(112,12,11112) Insert into users values(113,18,11113) Insert into users values(114,19,11114) Insert into users values(115,15,11115) Insert into users values(116,20,11116) select * from users where age 18 end go exec proc_name %@ page contentType=text/html;charset=utf-8% %@taglib uri=/struts-tags prefix=s% %@page import=com.xlwzsoft.webconfig.WebConfig% %@page import=com.opensymphony.xwork2.util.ValueStack% %@page import=com.xlwzsoft.util.business.LabelValueInfo% %@taglib uri=/AccessoryPackage prefix=accessoryPackage% %@page import=com.xlwzsoft.tender.consts.DocumentTypeConst% %@page import=java.util.*% %@taglib uri=jstlc prefix=c% % String path = request.getContextPath(); % !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=utf-8 / meta http-equiv=x-ua-compatible content=ie=7 / title无标题文档/title link rel=stylesheet href=%=path%/skin/skin_default/bk_cmm.css type=text/css / link rel=stylesheet href=%=