难题，请问在建立视图的时候，能否调用用户自定义的function?

[c_g]

如
CREATE or replace VIEW v_zzsyb_gjj
AS
select
kjqj as ny,
udf_IncIncQuarter('40101',kjqj) as zfgjjcklxsr
from h_qjkzb
;

udf_IncIncQuarter为我定义的函数

[jiezhi]

just try,I think you can.

[beckhambobo]

Restrictions on the Defining Subquery of a View
The view subquery cannot select the CURRVAL or NEXTVAL pseudocolumns.
If the view subquery selects the ROWID, ROWNUM, or LEVEL pseudocolumns, those columns must have aliases in the view subquery.
If the view subquery uses an asterisk (*) to select all columns of a table, and you later add new columns to the table, the view will not contain those columns until you re-create the view by issuing a CREATE OR REPLACE VIEW statement.
For object views, the number of elements in the view subquery select list must be the same as the number of top-level attributes for the object type. The datatype of each of the selecting elements must be the same as the corresponding top-level attribute.
You cannot specify the SAMPLE clause.

[duanhui]

正确，没有问题：

this is my view
select fun1(tb1.col1),fun2(tb1.col2) from tb1 where fun3(tb1.col1) > 100

[蜗牛20008]

JUST TRY IT,OK

[LGQDUCKY]

可以：这是我建立的视图：如下
sql>create view aaaa as
2 SELECT "OA_PVT_APPENDIX"."BBH","OA_PVT_APPENDIX"."XH",
3 F_GET_APPENDIX("OA_PVT_APPENDIX"."APPENDIX" ,102,'01002','2003/12/31')
4 FROM "OA_PVT_APPENDIX"
5;

View created
sql>


F_GET_APPENDIX是我自己定义的函数。

[beckhambobo]

检查函数是否有问题

[f3611018]

友情up