Anyway, if your development environment is refreshed from production on a regular basis, objects and all, you'll need to redeploy those views. Naturally, you saved that ad-hoc like SQL in subversion or some other source control tool...oops, you didn't?
All is not lost.
First, it's relatively easy, if you have a magnifying glass, to pick out the deployed views, they look like this:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFHDzBy43F_o9nW9MH_Nh8AlAuunJTTFybdM5XwocXMwbkSEFZGpHn9Z4n1fJ5ARH9UuIiOj44FlezaoMzM4r9FjCNyz3Y6015Hk1E02D3kccMKz7IDjGyXXdq-YSe6mxNZX72hKQyni5F/s800/Screenshot-1.jpg)
Now, just go into the table properties, General tab and go to the dropdown box:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFiUrQ6HarDYUEvjo-XQXZkG7LElnevTPliBntfYRZfx-IyBqn02hWmEawKM14pnIvwwlSEQm_A1EVq0Wjwxr7lrnqV1T_RLzUfupxCsxLkvbMmiD47ttc7ZFk1nR5y7S9tT_-yqcHmyrb/s800/Screenshot.jpg)
Select the Select selection (hah!). If you're a bit uptight about putting it in the correct location (like I am), you may have to navigate to the appropriate database version. For me, Oracle 10g R2:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ2qejl_ZXcZDGyQQ1V48M7KLTwFUnh2u6Z64OxzAtJ8fW6vet50abuU3zgUimgzCYq3mVjS5GfX8aeIcPqEm6GkAvwaEDsM0ZC3r8mtxa6thX92QCfG6NIsxRoKSeubHlvixoivIX8lWr/s800/Screenshot-4.jpg)
VoilĂ !
Another option that you could use would be to Copy (Ctrl+C) the object in question and then paste (Ctrl+V) into notepad or some similar tool. Should be fairly easy to spot the SQL.
No comments:
Post a Comment