CTRL+SHIFT+F<\/p>\n
Shift+B
CTRL+SHIFT+B<\/p>\n
or \u00a0It\u2019s listed under the Edit menu<\/p>\n
F4<\/strong> CTRL-E<\/strong><\/p>\n right click on the grid of results and select “record count<\/strong>“<\/p>\n SHIFT-F9<\/strong> CTRL-F9<\/strong> CTR + Z<\/strong> Undo<\/p>\n SHIFT + CTR + Z<\/strong> reapply the last Undo (Redo Last Undo)<\/p>\n Ctrl+Spacebar<\/strong> -Code Templates (zen coding) Ctrl+U<\/strong> – Converts Text to Uppercase Ctrl+A<\/strong> – Select All Text Ctrl+F –<\/strong> Find Ctrl+S<\/strong> – Save File Ctrl+E<\/strong> – Execute Explain Plan on the Current Statement Ctrl+Home<\/strong> – In the data grid: goes to the top of the record set F4<\/strong> – Describe Table, View, Procedure, Function <\/p>\n","protected":false},"excerpt":{"rendered":" Shortcut to Advanced Code formatting or beautify code in TOAD CTRL+SHIFT+F Shortcut to Comment\/Uncomment Selected Text in\u00a0TOAD Shift+BCTRL+SHIFT+B or \u00a0It\u2019s listed under the Edit menu Shortcut to Describe Selected Tables in TOAD F4This executes a \u201cdescribe\u201d on the object your cursor is adjacent to (i.e. a table). This is different from the \u201cdesc [tablename]\u201d command, […]<\/p>\n","protected":false},"author":2,"featured_media":7212,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31,51],"tags":[],"class_list":["post-7211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-data-warehouse","category-productivity-quality"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2020\/03\/toad.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/7211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=7211"}],"version-history":[{"count":5,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/7211\/revisions"}],"predecessor-version":[{"id":11467,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/7211\/revisions\/11467"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/7212"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=7211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=7211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=7211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
This executes a \u201cdescribe\u201d on the object your cursor is adjacent to (i.e. a table). This is different from the \u201cdesc [tablename]\u201d command, since it pops up a TOAD window that is well-designed with an easy UI for navigating the object \u2014 the \u201cdesc\u201d command in SQL will work similar to using SQL Plus where it will just show details in the result grid pane.<\/p>\nShortcut to execute an explain plan on the current statement.<\/h1>\n
How to prevent TOAD from displaying large numbers in exponential notation<\/h1>\n
\n
How to get total record count for a results set in TOAD<\/h1>\n
Run only the SQL that your cursor is on<\/h1>\n
This will run only the SQL that your cursor is on. You do not need to highlight the line or the entire SQL statement; simply place your cursor anywhere inside the SQL statement and click SHIFT-F9.<\/p>\n
This will verify (parse) the statement without executing it.<\/p>\nEditing Shortcuts<\/h1>\n
Ctrl+P<\/strong> – Strip Code Statement<\/p>\n
Ctrl+L<\/strong> – Convert Text to Lowercase<\/p>\n
Ctrl+C<\/strong> – Copy
Ctrl+X<\/strong> – Cut
Ctrl+V<\/strong> – Paste<\/p>\n
Ctrl+R –<\/strong> Find and Replace
F3<\/strong> – Find Next Occurrence
Shift+F3<\/strong> – Find Previous Occurrence
Ctrl+G<\/strong> – Goto Line<\/p>\n
Shift+Ctrl+S<\/strong> – Save File As<\/p>\n
F5<\/strong> – Execute SQL as a script
F8<\/strong> – Recall Previous SQL Statement
F9<\/strong> – Execute Statement
Ctrl+F9<\/strong> – Set Code Execution Parameters
Shift+F9<\/strong> – Execute Current SQL statement at Cursor
Ctrl+N<\/strong> – Recall Named SQL Statement
Alt+Up Arrow<\/strong> – Display Previous Statement
Alt+Down Arrow<\/strong> – Display Next Statement (After Alt+Up Arrow)<\/p>\n
Ctrl+End<\/strong> – In the data grid: goes to the end of the record set
Ctrl+Tab<\/strong> – Cycles through the Collection of MDI Child Windows<\/p>\n
Ctrl+T<\/strong> – Columns Drop-down
Shift+Ctrl+R<\/strong> – Alias Replacement<\/p>\n\n\n