Toad For Oracle Key
How can i define a primary foreign key(PFK) in Toad for Oracle ?
closed as not constructive by Blazemonger, Aziz Shaikh, Shree, rael_kid, MaerlynNov 20 '12 at 10:44
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
1 Answer
You have to add a foreign key under constraints after you have set up the table.a link to a picture of the constraint
Not the answer you're looking for? Browse other questions tagged databaseoracle11gddl or ask your own question.
Home > Articles > Data > Oracle
␡- Predefined Shortcuts
This chapter is from the book
This chapter is from the book
Predefined Shortcuts
Keyboard shortcuts are one of the features that make TOAD so powerful and easy to use. TOAD comes with a host of predefined shortcuts. These shortcuts save keystrokes and mouse actions and perform a variety of tasks such as issuing a describe on the current highlighted object, or find (find next, find previous, and so on). The shortcuts differ slightly between the SQL Editor and the PL/SQL Editor (covered in Chapter 4). This section focuses on the shortcuts for the SQL Editor only.
Table 3.1 shows all the shortcuts in keystroke order and Table 3.2 shows all the shortcuts in description order. The third column refers you to the figure in this chapter where the shortcut is illustrated.
Table 3.1 SQL Editor Shortcuts by Keystroke
Shortcut | Description | Illustration |
F1 | Windows Help File | |
F2 | Toggle Output Window | |
Shift+F2 | Toggle Data Grid Window | |
F3 | Find Next Occurrence | |
Shift+F3 | Find Previous Occurrence | |
F4 | Describe Table, View, Procedure, Function | |
F5 | Execute SQL as a script | |
F6 | Toggle between SQL Editor and Results Panel | |
F7 | Clear All Text | |
F8 | Recall Previous SQL Statement | |
F9 | Execute Statement | |
Ctrl+F9 | Set Code Execution Parameters | |
Shift+F9 | Execute Current SQL statement at Cursor | |
F10 or right-click | Pop-up Menu | Figures 3.4, 3.10 |
Ctrl+F12 | External Editor, Pass Contents | Figures 3.5, 3.6 |
Ctrl+A | Select All Text | |
Ctrl+C | Copy | |
Ctrl+E | Execute Explain Plan on the Current Statement | |
Ctrl+F | Find Text | |
Ctrl+G | Goto Line | |
Ctrl+L | Convert Text to Lowercase | |
Ctrl+M | Make Code Statement | |
Ctrl+N | Recall Named SQL Statement | |
Ctrl+O | Open a Text File | |
Ctrl+P | Strip Code Statement | |
Ctrl+R | Find and Replace | |
Ctrl+S | Save File | |
Shift+Ctrl+S | Save File As | |
Ctrl+T | Columns Drop-down | |
Shift+Ctrl+R | Alias Replacement | |
Shift+Ctrl+T | Columns Drop-Down no alias | |
Ctrl+Spacebar | Code Templates | |
Ctrl+U | Converts Text to Uppercase | |
Ctrl+V | Paste | |
Ctrl+X | Cut | |
Ctrl+Z | Undo Last Change | |
Ctrl+. | Display Pop-up List of Matching Table Names | |
Shift+Ctrl+Z | Redo Last Undo | |
Alt+Up Arrow | Display Previous Statement | |
Alt+Down Arrow | Display Next Statement (After Alt+Up Arrow) | |
Ctrl+Home | In the data grid: goes to the top of the record set | |
Ctrl+End | In the data grid: goes to the end of the record set | |
Ctrl+Tab | Cycles through the Collection of MDI Child Windows |
TIP
The competent TOAD user makes use of Shift+F9 to execute SQL statements one at a time out of a script, and F8 to recall the previous SQL statement. The TOAD user also makes use of cut and paste to move code between TOAD windows.
Shift+F9 executes single SQL statements.
F8 recalls the previous SQL statement.
Table 3.2 SQL Editor Shortcuts by Description
Description | Shortcut | Illustration |
Alias Replacement | Shift+Ctrl+R | |
Clear All Text | F7 | |
Code Templates | Ctrl+Spacebar | |
Columns Drop-down | Ctrl+T | |
Columns Drop-down no alias | Shift+Ctrl+T | |
Convert Text to Lowercase | Ctrl+L | |
Convert Text to Uppercase | Ctrl+U | |
Copy | Ctrl+C | |
Cut | Ctrl+X | |
Cycles through the Collection of MDI Child Windows | Ctrl+Tab | |
Describe Table, View, Procedure, Function, or Package | F4 | |
Display Next Statement (After Alt+Up Arrow) | Alt+Down Arrow | |
Display Previous Statement | Alt+Up Arrow | |
Display Pop-up List of Matching Table Names | Ctrl+. | |
Execute Current SQL Statement at Cursor | Shift+F9 | |
Execute SQL as a Script | F5 Jan 29, 2017 - A remake of the 2007 Telugu film Aadavari Matalaku Ardhale Verule.When he finds her, her life changes. But she doesn't accept him. Bangla Movies Seen So Far. Jeet and Biswanath Basu in 100% Love (2012) 100% Love (2012) Koyel Mallick in 100% Love (2012) Jeet and Koyel Mallick in 100% Love (2012) Jeet in 100% Love (2012). See full technical specs ». 100% love malayalam full movie. | |
Execute Explain Plan on the Current SQL Statement | Ctrl+E | |
Execute SQL Statement | F9 | |
External Editor, Pass Contents | Ctrl+F12 | |
Find and Replace | Ctrl+R | |
Find Next Occurrence | F3 | |
Find Previous Occurrence | Shift+F3 | |
Find Text | Ctrl+F | |
Goto Line | Ctrl+G | |
In the data grid: goes to the end of the record set | Ctrl+End | |
In the data grid: goes to the top of the record set | Ctrl+Home | |
Make Code Statement | Ctrl+M | |
Open a Text File | Ctrl+O | |
Paste | Ctrl+V | |
Pop-up Menu | F10 or RT-Mouse | Figures 3.4, 3.10 |
Recall Named SQL | Ctrl+N | |
Recall Previous SQL Statement | F8 | |
Redo Last Undo | Shift+Ctrl+Z | |
Save File | Ctrl+S | |
Save File As | Shift+Ctrl+S | |
Select All Text | Ctrl+A | |
Strip Code Statement | Ctrl+P | |
Toggle between SQL Editor and Results Panel | F6 | |
Toggle Full Screen Editor | F2 | |
Undo Last Change | Ctrl+Z | |
Verify Statement Without Execution (Parse) | Ctrl+F9 | |
Windows Help File | F1 |
Related Resources
- eBook (Watermarked) $31.99
- Book $43.99
- eBook (Watermarked) $35.19