How to ask. The content of the view batch query out-CodePudding

According to the condition of filter out a lot of views, and now I have to check the source of the view, such as what kind of DB_LINK, but there are LONG field ALL_VIEWS,
Unable to DISTINCT the WHERE cannot batch view,

Do you have any way to achieve

CodePudding user response:

 
- the processing method of LONG data: 

Connected to the Oracle Database 11 g Enterprise Edition Release 11.2.0.2.0 
Connected as test @ MSGDE 

SQL> 
SQL> The create view myview as select sysdate s from dual; 
The View created 
SQL> The create view v1 as select 1 rn from dual; 
The View created 
SQL> The create table myviews 
2 as 
3 the select view_name, to_lob (text) text from user_views; 
The Table created 
SQL> Select view_name, to_char (text) view_ddl from myviews; 
VIEW_NAME VIEW_DDL 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 
MYVIEW select sysdate s from dual 
V1 select 1 rn from dual 
SQL> Drop the view myview. 
The View dropped 
SQL> Drop the view v1; 
The View dropped 
SQL> Drop table myviews purge; 
Table dropped 

SQL>

CodePudding user response:

Thank the moderator,
Use TO_LOB can out,
But have another problem again, when encountered read-only users unable to create temporary tables,
I use PLSQL complains, use DB_LINK also does not support a LOB, want to be in another user take the past also can't do that, the USER_VIEWS

CodePudding user response:

Not to build a temporary table, that only through the external process, estimate is not what you want; In the website did not find the other way, you have time, you can also look for, have a new discovery in one thousand,