06 July, 2011

Toad Code Template

A lot of developers waste a long time writing repeated code,So Toad offers feature named "Code Template" that I can use it to overcome this.
To use code template in editor you must press CTRL+SPACE, it will show list of reserved code template as below, Then choose the required template

Here I will clarify how creating your own code template
1) From Menu View->Toad Options It will open the below window choose from left pane Editot->Behavior and from T-List choose PL-SQL and then press edit button as below

The following window will be shown, choose code template tab and then press add code as below 

    select column
    into variable
    from table
    where where_clause;
    when no_data_found then
        --no data found exception
    when too_many_rows then
        --too many rows exception
    when others then
To use that template in editor you click CTRL+Space it will show a list of template when you choose "select" it insert code that you entered before in editor.

 You can import and export your own code template from toad at your machine to another machine using Import and Export buttons as following photo

I hope that my post is helpful and useful.
If you have any question, Feel free to ask at email mahmoud_ahmed01@yahoo.com
Mahmoud Ahmed


  1. hey its really helpful...thanks :)

  2. Hi,

    This information is very useful...


  3. Mahmoud,

    Thanks for your post. I've been looking for this. I would have called it 'code snippets', but that is something else in Toad. Much appreciated!


  4. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work. hyip template

  5. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! website builder cheap

  6. Took me time to understand all of the comments, but I seriously enjoyed the write-up. It proved being really helpful to me and Im positive to all of the commenters right here! Its constantly nice when you can not only be informed, but also entertained! I am certain you had enjoyable writing this write-up. website builder best free

  7. This is an awesome motivating article.I am practically satisfied with your great work.You put truly extremely supportive data. Keep it up. Continue blogging. Hoping to perusing your next post mobile cleaner light

  8. I was taking a gander at some of your posts on this site and I consider this site is truly informational! Keep setting up.. Letheteaaccessories

  9. New site is solid. A debt of gratitude is in order for the colossal exertion. computrainer video courses

  10. If your looking for Online Illinois license plate sticker renewals then you have need to come to the right place.We offer the fastest Illinois license plate sticker renewals in the state. wigs London

  11. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog. Hollister Missouri

  12. wow, great, I was wondering how to cure acne naturally. and found your site by google, learned a lot, now i’m a bit clear. I’ve bookmark your site and also add rss. keep us updated. SIBO

  13. I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site. Vanity mirror

  14. You have done a amazing job with you website LED mini mirror

  15. I love the way you write and share your niche! Very interesting and different! Keep it coming! resist

  16. I read your post and I found it amazing! thank! ot

  17. Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place.. issey pour homme


ADF : Scope Variables

Oracle ADF uses many variables and each variable has a scope. There are five scopes in ADF (Application, Request, Session, View and PageFl...