 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.
 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
Location: Blogs
Jeff Smith
|
|
| JeffSmith |
Tuesday, July 22, 2008 8:06 AM |
The editor window is probably where most users spend a majority of their time. In this blog, I’ll try to highlight the 10 features that will save you the most time when it comes to writing your SQL queries, SQL*Plus scripts, anonymous blocks, and PL/SQL stored procedures. Please note that all of these features are available in the standard edition of Toad for Oracle, version 9.6.
1. SQL Recall
By far one of the most popular features in Toad, but do you know how to take FULL advantage of this feature?
The basics:
- Every statement you execute gets recorded
- By default we remember the last 100 executed (configurable up to 999)
- F8 opens the SQL Statement Recall panel (also available under the View menu)
- ALT+PgUp/Dn will cycle through the most/least recently executed statements
- You can name your SQL for instant recall using the CTRL+N keystroke
Give your queries a name so you remember why you wrote them in the first place!
2. Code Templates
Ever experience déjà vu while typing out your code? This is your cue to save it as a template for use later. Toad gives you access to several dozen of these out of the box. You can also add your own or customize the existing ones. Use the CTRL+Spacebar keystroke to see the code you no longer have to type out manually.
Remember the code snippet names for instant recall, try typing ‘anon CTRL+Spacebar’ right now!
3. Code Insight (Dot Lookups)
When you want to write a SQL query or make a PL/SQL call, you probably spend a bit of time manually looking up the column names or command arguments required in the Schema Browser. Stop doing this right now! From now on, let Toad figure this out for you automatically in the editor.
The basics:
- Schema. – this will pop up a list of all objects in the current schema you may want to type
- Schema.Table. – this will pop up a list of columns for a given table. You don’t need to prefix the schema name if the table is in your current schema. Multi-select columns to get more than one, and we’ll comma separate the list for you automatically
- Package. – this will pop up a list of procedures, functions, variables, etc for that package.
- Stored Procedure( - this will pop up the list of input parameters to make the call. You can type while you reference the list. Entering the ‘)’ character will close the hint.
- Toad waits 1.5 seconds after seeing the ‘.’ or ‘(‘ character before popping up the list of items available for that object. This is configurable down to the millisecond for optimal usage.
- You can use aliases for your view/table names and the code insight feature will automatically include the alias when bringing back a list of columns.
4. F4 DESC
DESC, or Describe, is a SQL*Plus command that will display the table or view structure, e.g. a list of columns and their datatypes with size and precision. Toad has its own DESC command. You can invoke it immediately for ANY object in the database by typing that object in the editor, putting you cursor on it, and hitting ‘F4’. This is one of the most ‘borrowed’ features in an Oracle IDE. Do you find it curious that it’s always activated with ‘F4’? Imitation is surely flattering, even if it is poorly executed J
You can have multiple F4 dialogs open at a time. You can type away in the editor with the DESC dialogs available to you. Ever working on a query only to find out you need to add a column, update a row, or change the permissions on a table? Don’t go to the Schema Browser anymore, just use ‘F4’ for instant gratification.
Get instant access to any database object with the power of the Schema Browser immediately available.
5. Make/Strip Code
Turn any SQL statement into a Java, C++, Delphi, Perl, etc command in a single button click. Even better, take any embedded SQL statement and strip away the non-SQL syntax for instant execution in the Editor. This is one of the most over-looked features in Toad. No more REGEX search and replace to get your well-crafted SQL statement ready for your Eclipse or Visual Studio application.
Configure Toad to use the programming language of your choice!
Summary
Ok, I know we only covered five things, but my fingers are tired and I need to get back to my ‘real’ job. Look for the next five things you MUST know about Toad’s editor in an upcoming blog. And as always, feel free to share your own tips and questions using the blog comments feedback section.
Read Jeff's next five must know items
|
|
| Permalink |
Trackback |
Comments (1)
Add Comment
|
By MarkGaret on
Wednesday, November 12, 2008 5:36 AM |
Cialis
There are some people who say that top branded drugs are way more effective than the generic ones. However, this does not hold much truth when it comes to the generic medicines which are sold here. An online pharmacy which offers generic medicines at affordable prices. If you have been diagnosed with a sickness and your medication requires you to spend a lot for your medicines, you don't have to worry about this anymore. You can buy cialis and get a discount when you keep on buying the same drug. When you cannot tolerate the high price of branded medicines, your only option is an online pharmacy, since it is compassionate with your need for reasonably priced drugs.
If your medication calls for high-priced branded medicines, why not generic cialis? This is an alternative which is provided at your affordable online drug store. One of the advantages that you can get from this store is the fact that its medicines can be bought for very low prices. You can order generic drugs at the website. These medicines are formulated with ingredients which are equal to the ones which make up branded drugs. However, the prices of the two are entirely different. Even though the prices of generic drugs and branded drugs vary widely, the effects are still the same. This is due to the fact that the medicines which are sold at this online pharmacy have been approved by worldwide organizations. The effectiveness and the quality of the generic drugs are regarded as excellent. The legality of these drugs has been supported by international regulatory boards. Some of these authorities are South Africa MCC, USA FDA, and WHO.
When you buy cialis, the shipping service is offered for free. If you are residing within the European continent or at the other pole of the globe, the medicines that you have ordered will still be delivered to you. If you are a resident from the USA or from Europe, the duration of the shipping service can take fourteen days. One of the services that this online drug store provides its customers with is the chance to get a discount. Each time you order the same drug, you will be offered with a five-percent discount. Since the online pharmacy is compassionate with the plight of its sick patients, it does not charge you with hidden fees. Nor does it charge you when you consult with its physicians.
You can buy cialis when you are diagnosed with a sickness. Serious ailments such as cancer or manic depression can be treated with some of the medicines sold at this online pharmacy.
Author: Mark Garet http://www.onlinepharmacy.vg/catalog/-c-32_469.html
|
|
|
|
|
|
|
|
|
|
|