just try,I think you can.
解决方案 »
- rman catalog的问题
- 关于ODBC链接oracle,在windows2008 64bit上
- 请教关于oracle中rman的问题
- 大数据量多表查询优化 求解~~
- 请问在linux下如何统计oracle所有进程的CPU和内存占用率
- 在Oracle 中创建存储过程时,要传递参数时要用数组,请问该怎么弄呢?
- 怎么查询oracle数据库连接的用户数
- 为什么出现‘NEW或OLD引用不允许在表层触发器中’的编译错误
- oracle大表关联怎样优化
- 一个比较基础的问题,不过找不到解决办法。。新手
- SOS,急急急。在redhat9下安装oracle9i时出现进度条后不能继续?
- update 多表关联。
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.
select fun1(tb1.col1),fun2(tb1.col2) from tb1 where fun3(tb1.col1) > 100
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是我自己定义的函数。