create function getproductmaininfo(v_productid integer,v_status integer) return sys_refcursor
is
v_result sys_refcursor;
v_definitionid btoc_product.definitionid%type;
v_table VARCHAR2(100);
v_sql VARCHAR2(32000); ---应该怎么写
is
v_result sys_refcursor;
v_definitionid btoc_product.definitionid%type;
v_table VARCHAR2(100);
v_sql VARCHAR2(32000); ---应该怎么写
mysql> CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
-> RETURN CONCAT('Hello, ',s,'!');
-> //
Query OK, 0 rows affected (0.00 sec)