Toad Editor Shortcut Keys

-
Frequently Used Functions Description CTRL+N Opens a new editor window CTRL+PERIOD Displays the code completion list F9 Execute current statement F5 Execute all statements, in order, one at a time CTRL+K, CTRL+C Comments the selected line CTRL+K, CTRL+U Uncomments the selected line CTRL+J Collapses all code regions CTRL+M Expands all code regions ALT+PAUSE Stops script execution Bookmark Description CTRL+K, CTRL+K Sets or removes a general bookmark CTRL+SHIFT+0-9 Sets a numbered bookmark at the selected line CTRL+0-9 Goes to the numbered bookmark Case Description CTRL+SHIFT+L Converts the selected text to lowercase CTRL+SHIFT+U Converts the selected text to uppercase Clipboard Description CTRL+C Copies the selected text to the clipboard CTRL+X Cuts the selected text for pasting in the clipboard CTRL+V Pastes text from the clipboard Code Completion Description CTRL+PERIOD Displays code completion list ENTER Selects an item and close the code completion list CTRL+SPACE Selects an item without closing the code completion list CTRL+ Expands a node in the code completion list CTRL+ Collapses a node in the code completion list Comment Description CTRL+K, CTRL+C Comments the selected line CTRL+K, CTRL+U Uncomments the selected line Cursor Description HOME Moves the cursor to the beginning of the line CTRL+HOME Moves the cursor to the beginning of the file END Moves the cursor to the end of the line CTRL+END Moves the cursor to the end of the file Debugger Description SHIFT+F12 Step from cursor F7 Step into SHIFT+F7 Step out F8 Step over F11 Run to breakpoint F12 Run to cursor CTRL+B Set breakpoint CTRL+W Add watch at cursor Delete Description BACKSPACE Deletes the selected text (if text is selected); otherwise, deletes the previous character CTRL+BACKSPACE Deletes text to the beginning of the previous word CTRL+SHIFT+DELETE Deletes the entire script Find and Replace Description CTRL+F Finds text F3 Finds the next occurrence of text SHIFT+F3 Finds the previous occurrence of text CTRL+G Goes to line number CTRL+I Performs an incremental search CTRL+SHIFT+I Performs a reverse incremental search Indent Description TAB Indents the selected line SHIFT+TAB Outdents the selected line Macros Description CTRL+SHIFT+R Starts/Stops recording a macro CTRL+SHIFT+P Plays the recorded macro Miscellaneous Description F4 Invokes objects search F4+SHIFT Describes the object next to the cursor F6 Toggles between the Editor and Data Grid CTRL+D Sends SQL to Query Builder SHIFT+F8 Recalls the previous SQL statement CTRL+á Scrolls up the window. CTRL+â Scrolls down the window +SPACE Automatically replaces a misspelled word, inserts symbols, and expands text. Note: You can set autoreplace in Tools | Options | Editor | Autoreplace. CTRL+SPACE Displays the Code Snippets folder browser +CTRL+SPACE Inserts the code snippet template CTRL+DELETE Sets the column value for the current cell to Null in the data grid

Comments

Post a Comment

Popular posts from this blog

How to open and edit a large 250GB SQL file in Windows?

-
Image
  How to open and edit a large 250GB SQL file in Windows? Database administrators and programmers are often in a situation where they need to open or edit a large SQL file. These files are often created using the mysqldump utility, when generating cold backups of the database. The common simple text editors such as Notepad and Notepad++ will not be able to properly open large SQL files, especially when you reach sizes like 100-200GB of data. The reason they do not actually work with such large files is because they try to load the data to the computer's memory (RAM), and therefore they are somewhat limited to the amount of RAM you have in the computer (which is probably a lot less than 200GB). I can recommend that you'll try out  EmEditor , which according to their website can easily handle files up to 248 GB. Personally, I tried using it with a 70-80GB dump and it worked perfectly on my Windows dell laptop (8GB RAM, dual core CPU - nothing special). The reason EmEdi...
Read more

Project Management System ER Diagram

-
Image
  This article will discuss the step by step process on how to prepare the entity relationship diagram or ERD of the project entitled Project Management System. Project Management System is an information system that will manage the processes and transactions involved in monitoring and recording the updates of a project. The said project can be implemented in an offline settings but in most cases this is implemented in a live server or it simply means an online system. The first step in the development of the Project Management System is to prepare the ER diagram that will serve as the basis later on in the creation of the actual database. We will create and explain the process of making the entity relationship diagram of project management system. Let’s start from the symbols used in the ER Diagram. Entity is represented by the rectangle shape. The entity will be our database table of Project Management System later on. Attribute is represented by the oval shape. This will be the ...
Read more

Install and Configure OBIEE 12c on Linux VM

-
Image
Install and Configure OBIEE 12c on Linux VM · 1 Today we are going to be installing Oracle BI 12c on our Linux Virtual Machine. If you have not already created an Oracle Linux VM, I wrote a blog on how to do this  here . If you have not already installed Oracle Database 19c on your Linux VM, I wrote a blog on how to do this  here . This blog also assumes that you have access to the sample HR dataset that comes pre-installed with Oracle Database 19c. I covered how to access this in the Oracle 19c installation blog that I mentioned above. Before we begin, I just wanted to say good luck  and … Starting-up and opening the database If you have not already done so, log-in to your Linux instance’s GUI. Your screen should look like this. First, let’s start our listener and open-up our database. Open a new terminal window and execute the following command to start your listener, if it is not already started. If it has already been started, the terminal will let you know. lsnrctl s...
Read more