TOAD KEYBOARD SHORTCUTS

F1 ------------- Windows help file

F2 ------------- Toggle full screen editor

Shift+F2-------- Toggle full screen grid

F3---------------Find next occurrence

F4---------------Describe

F5---------------Set or delete a breakpoint in Proc Editor for
PL/SQL debugging or execute as script in SQL Editor.

F6---------------Toggle between SQL Editor and results panel.

F7-------------- Clear all text, trace into Proc Editor

F8---------------Recall previous SQL statement or step over in
Proc Editor for PL/SQL debugging.

F9--------------- Execute statement in SQL Editor compile in Proc Editor

Ctrl+F9---------- Verify statement without execution (parse) in SQL Editor, set parameters in Proc Editor for PL/SQL debugging.

Shift+F9--------- Execute current statement at cursor in SQL Editor or
execute current source in Proc Editor without PL/SQL debugging
F10-------------- Popup menu

F11------------- Run (continue execution) in Proc Editor for PL/SQL debugging

F12-------------- Run to cursor in Proc Editor for PL/SQL debugging.

ctrl+F12--------- Pass SQL or Proc Editor contents to specified external editor

ctrl+alt+B------- Display PL/SQL debugger breakpoints window

ctrl+D----------- Display procedure parameters

ctrl+alt+D------- Display PL/SQL debugger in DBMS output window

ctrl+E----------- Execute explain plan on current statement

ctrl+alt+E------- Display PL/SQL debugger evaluate/modify window

ctrl+G----------- Go to line

ctrl+L----------- Convert text to lowercase

ctrl+M----------- Make code statement

ctrl+N----------- Recall named SQL statement

ctrl+P----------- Strip code statement

ctrl+R----------- Find and replace

shift+ctrl+S---- Save file as

ctrl+alt+S------- Display PL/SQL debugger call stack window

ctrl+T------------ column dropdown

ctrl+U----------- Converts text to uppercase

ctrl+alt+W------- Display PL/SQL debugger watches window

ctrl+shift+z----- Redo last undo

alt+UP----------- Display previous statement

alt+DOWN--------- Display next statement (after alt+UP)

ctrl+HOME-------- In data grids, go to top of the recordset

ctrl+END--------- In data grids, go to end of the recordset

ctrl+TAB--------- Cycle through collection of MDI child windows

ctrl+(period)---- Auto completes tablenames

ctrl+ENTER-------- Execute current SQL (same as shift+F9)

SCD Type 6 Implementation

SCD Type 6 / Hybrid Implementation:

The Type 6 method combines the approaches of types 1, 2 and 3  (1 + 2 + 3 = 6). One possible explanation of the origin of the term was  that it was coined by Ralph  Kimball during a conversation with Stephen Pace from Kalido^{[citation needed]}.  Ralph Kimball calls this method "Unpredictable Changes with  Single-Version Overlay" in The Data Warehouse Toolkit^[1].

The Supplier table starts out with one record for our example  supplier:

Supplier_Key	Supplier_Code	Supplier_Name	Current_State	Historical_State
123	ABC	Acme Supply Co	CA	CA

The Current_State and the Historical_State are the same. The  Current_Flag attribute indicates that this is the current or most recent  record for this supplier.

When Acme Supply Company moves to Illinois, we add a new record, as  in Type 2 processing:

Supplier_Key	Supplier_Code	Supplier_Name	Current_State	Historical_State
123	ABC	Acme Supply Co	IL	CA
124	ABC	Acme Supply Co	IL	IL

We overwrite the Current_State information in the first record  (Supplier_Key = 123) with the new information, as in Type 1 processing.  We create a new record to track the changes, as in Type 2 processing.  And we store the history in a second State column (Historical_State),  which incorporates Type 3 processing.

If our example supplier company were to relocate again, we would add  another record to the Supplier dimension, and we would once again  overwrite the contents of the Current_State column:

Supplier_Key	Supplier_Code	Supplier_Name	Current_State	Historical_State
123	ABC	Acme Supply Co	NY	CA
124	ABC	Acme Supply Co	NY	IL
125	ABC	Acme Supply Co	NY	NY

Note that, for the current record (Current_Flag = 'Y'), the  Current_State and the Historical_State are always the same.