SELECT * FROM |
|
CREATE
TYPE OBJ_DICDB_ROWTYPE IS TRADE_DATE DATE, SDB_TRANSACTION_TYPE_CODE VARCHAR2(10 NUMBER_OF_SHARE NUMBER, BROKER_NAME VARCHAR2(50
TYPE TABLETYPE_DIC_DB IS
FUNCTION FN_DIC_DB_TAB RETURN TABLETYPE_DIC_DB PIPELINED;
END PKG_TEST; |
CREATE
FUNCTION FN_DIC_DB_TAB RETURN TABLETYPE_DIC_DB PIPELINED V_DIC_DB OBJ_DICDB_ROWTYPE; CUR_RETURN_DATA SYS_REFCURSOR; BEGIN
OPEN CUR_RETURN_DATA FOR SELECT 'S' SDB_TRANSACTION_TYPE_CODE, 100 NUMBER_OF_SHARE, 'Broker 1' BROKER_NAME FROM DUAL UNION SELECT 'B' SDB_TRANSACTION_TYPE_CODE, 200 NUMBER_OF_SHARE, 'Broker 2' BROKER_NAME FROM DUAL;
LOOP FETCH CUR_RETURN_DATA INTO V_DIC_DB; EXIT PIPE END RETURN; END; END PKG_TEST; |
相关文章
- no matching function for call to ‘std::basic_string
::assign(std::string&, int) - 优秀程序设计的Kiss原则(keep it simple,stupid)
- ecstore 安装后提示require function does not exist in....
- Android筆記-Linux Kernel Ftrace (Function Trace)解析(非常强悍的性能分析方法)
- 微信小程序--分享报错(thirdScriptError Cannot read property 'from' of undefined;at pages/index/index page onShareAppMessage function TypeError: Cannot read property 'from' of undefined)
- R reshape2 'Aggregation function missing: default to length' [duplicate]
- 关于损失函数——Loss Function
- 损失函数(loss function)
- 【转】POJ 3468 A Simple Problem with Integers:线段树 简单操作 注意更新到区间而非叶节点
- 机器学习六--回归--简单线性回归Simple Linear Regression