Toad World® Forums

Extract Source Code of a View from Oracle

Hi, I hope someone can help. I want to see the source code of a view exactly as it was formatted by the developer the last time it was "created or replaced" in the database.

Using Toad, the Script tab gives me the Toad-REformatted version, which is NOT what I want to see.

I can get the source in sql plus using:
select text from user_views where view_name='MY_VIEW_NAME';

I would like to see the same source code in Toad.

Go here. Uncheck.

1 Like

Perfect! Thanks so much!!

1 Like