Full text search - views

[cobets]

Why for full text search on views PLSQLDev execute all views
(I can see it on session sql text window) ?
Full text search for views is for Full text search on data returned by views or for text search on view's text (user_views.text) ?

thank you

 

[Marco Kalter]

It does not execute the views, it merely "describes" the select statement of the view to determine if column aliases are used.

 

[cobets]

So, you right. PlSQLDev does not execute views,
but it parses views. And searching time
depends on parsing time.
Can you add to PLSQLDev some options for search on
views, for example search on views body only (all_views.text)

Thanks

 

[Marco Kalter]

I have added this to the list of enhancement requests.