Hello, my name is Anju Gandhi, Product Manager for Toad for Oracle. Today we will review new features in Toad for Oracle version 12.0 and 12.1 specifically meant for the developers. The features covered will be connected intelligence, code analysis enhancements, the new jump search, integration with motion control system using the new team coding dashboard, resolving Oracle connectivity issues, simplifying your complicated SQL statements for performance tuning, or changing the syntax of SQLs using code refactor, export and import data from to multiple ODBC data sources.
Let's review the connected intelligence feature, which is the new forum window available in Help, Toad World, Forums. Before you access this forums window, you will need to sign in on the toadworld.com. If you do not have an account, registration is very simple. You just need to provide your email and very basic information to sign up. And you're all set to access the forums. Of course, you would need internet access while you're using Toad to connect to the forums.
Once you're in forums window, you have an ability to browse through multitude of forum posts by fellow users of toadworld.com, which is a community of over three million users. So you can click on any forum post and you can see there have been some replies to the posts and there has been a verified answer by our expert as well.
And if you want to reply to the post or you want to start a new discussion from here, you can do that as well. So this is a great way to interact with multiple users who have the same issue as you may have, or you may want to research on anything related to Toad or Oracle in general. If you have multiple blogs open you can close them using the Toad World content option.
The next feature we'll cover is the code analysis enhancements. Now, if you have any code open in editor, you will see that there are top 20 rules by default that are checked. Now, if I increase that to a more rigorous testing and say, I want to check against all of the rules that are being violated in the code that is open in editor right now, I switch to All Rules.
And if I click on here, you will see there's a specific rule-- this new rule was added in release 12.0-- which says, do not use the constants. Instead try using bind variables in your SQL queries. So this is how we make sure that while you're writing code, code analysis is actively able to give you feedback on the quality of your code and just tell you if they're going to be in need of precautions for it. You can research more about code analysis. It's a great way to make sure that your code quality stays up to the mark without investing too much time in it.
The next feature I'll cover is the jump search feature. Now, let's say I have mistakenly removed something from here and I'm trying to run this code. Now, this is going to return an error. Now, if you will see, in our standard error messages we have added the jump menu. What this does for you is if you have any error, you click on jump. It opens in the search bar here and searches for that error message across all the Toad World articles. You can also take this search out on the website. What this does for you is just shortens the time for you to resolve your issue.
Besides this, jump search feature in itself is very useful. To search where a specific window in Toad is, where a specific menus, options are located within Toad, and you can research for anything within Toad World as well. And this is going to search for blogs and user forum articles for you. So this is very useful to perform searches. Again, this is a new feature added in 12.0.
Now we'll move to the team coding dashboard. This is accessible via Utilities, Team Coding, Team Coding Dashboard. All these three browsers that we have here, the VCS browser, the code collections, and the controlled objects, used to be three separate menu items in three separate windows. And it has been now combined under Team Coding Dashboard. This gives a very easy way for you to perform check in, check out. And once you double click on it, it opens that code and the data for you. You can save it, check it back in, and come back to Team Coding Dashboard.
Also, in version 12.0 we have added support for team foundation server 2012. So when you consider team coding, you can see the support for 2012. Also, please make sure to check out the status handlers here. At any time of configuration, if there are any issues found, the respective status will display red cross mark. And if you double click on it, it will take you to the problem resolution area.
Let's move on to a new feature now which is added in release 12.1. Now while you're establishing connections, let's say you've added a new entry in TNS names ORA. And I am going to just remove the name and just let code tell me where the problem is. Now earlier, if I would have done that, would have received a standard ORA error message. Now, in 12.1 what we have added is enhanced diagnostics for making sure the regular culprits for making connections to Oracle are taken care of and respective messaging comes back to you.
Now in this case, if you see, it just has checked so many times and it has found out that the connector descriptor, which I had intentionally marked wrong, it could not find it in TNS names ORA file. Now in addition to that, this window also gives you a direct ability to go and modify your TNS ORA