Run the following query in Query Builder to find the sql behind a view without having to go into SQL Developer or other Oracle database tool such as Toad :
SELECT text FROM all_views WHERE view_name = 'INSERT_VIEW_NAME'
QUERY/VIEW: Get the SQL behind a view via a query Print
Modified on: Tue, 25 May, 2021 at 11:19 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.