06 July, 2011

Toad Code Template

SA,
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 


declare
begin
    select column
    into variable
    from table
    where where_clause;
exception
    when no_data_found then
        --no data found exception
    when too_many_rows then
        --too many rows exception
    when others then
        dbms_output.put_line(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
end;
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

17 comments:

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

    ReplyDelete
  2. Hi,

    This information is very useful...

    Thanks
    Jana

    ReplyDelete
  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!

    Hogan

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

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

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

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

    ReplyDelete
  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

    ReplyDelete

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...