The idea behind the SQL Automation features in Aqua Data Studio (the
"Automate" pull down menu) is to cut down on the amount of keystrokes you
make while writing SQL statements.
The most amount of time spent typing away is probably writing templates for
basic SELECT, INSERT and UPDATE statments ... including writing out the
columns.
So, here is an example of how to automate the writing of basic statements
...
Automate INSERT ...
1. Press CTRL-ALT-I --- this will ...
a. Introduce an INSERT template, "INSERT INTO () VALUES()"
b. Place the cursor at the "INSERT INTO ^() VALUES()" location
c. Popup a list of tables for autocompletion of the table name you want to
INSERT data into
2. Type out the table you want and move the cursor to the column location,
"INSERT INTO MYTABLE(^) VALUES()"
3. Press CTRL-ALT-C --- this will ...
a. Introduce all of the columns for the TABLE you have typed in a comma
separated list in the order of definition
4. Move cursor to the values definition location "INSERT INTO
MYTABLE(COLUMN1, COLUMN2, ...) VALUES(^)"
5. Press CTRL-ALT-V --- this will ...
a. Introduce stubbed values for the columns of the table according to data
type
6. At this point you have "INSERT INTO MYTABLE(COLUMN1, COLUMN2, ...)
VALUES('', 0, ...)"
7. You can now finish your statement
Automate UPDATE ...
1. Press CTRL-ALT-U --- this will ...
a. Introduce an UPDATE template, "UPDATE SET WHERE"
b. Place the cursor at the "UPDATE ^ SET WHERE" location
c. Popup a list of tables for autocompletion of the table name you want to
UPDATE
2. Type out the table you want and move the cursor to the column set
location, "UPDATE MYTABLE SET ^ WHERE"
3. Press CTRL-ALT-C --- this will ...
a. Introduce all of the columns and value stubs for the TABLE you have
typed in a comma separated list in the order of definition
4. At this point you have "UPDATE MYTABLE SET EMPLOYEEID=0, NAME='',
SALARY=0, TITLE=0, CREATEDDATE='2002-12-30 23:59:59.0' WHERE"
5. You can now finish your statement
Automate SELECT ...
1. Press CTRL-ALT-S --- this will ...
a. Introduce a SELECT template, "SELECT * FROM WHERE"
b. Place the cursor at the "SELECT * FROM ^ WHERE" location
c. Popup a list of tables for autocompletion of the table name you want to
SELECT
2. Type out the table you want and move the cursor to the column set
location, "SELECT ^* FROM MYTABLE WHERE"
3. Press CTRL-ALT-C --- this will ...
a. Introduce all of the columns for the TABLE you have typed in a comma
separated list in the order of definition
4. At this point you have "SELECT EMPLOYEEID, NAME, SALARY, TITLE,
CREATEDDATE FROM MYTABLE WHERE"
5. You can now finish your statement
All of the Automation functionality is in the Automate pull down menu.
|
