Save and Reuse Tables
Do you frequently create the same type of complex table, such as a financial table or tables to use for custom page layouts? If so, you can save that table for easy insertion into any document by storing it in the Quick Tables gallery. Here’s how:
Select the table, and then press ALT+F3 to open the Create New Building Block dialog box. Type a name for your table, click the Gallery drop-down arrow, and then choose Tables from the list. You can set other options as well, such as choosing or creating a category for your table, which affects where in the Quick Tables gallery it is stored. By clicking the Save in drop-down arrow, you can indicate the template in which you want to store the table. However, if you leave the default Building Blocks.dotx as the Save in location, your table will be available to you for use in any document.
To access your saved table, on the Insert tab, click Table, and then point to Quick Tables.
r-onlineinformation.blogspot.com Tips for running queries on Oracle We encourage the use of PostgreSQL for the labs, to expose students to an excellent open source database. However, if your syllabus forces you to use Oracle (and all participants at your remote centre are also from universities where they are forced to use Oracle), you can do assignments on Oracle. Our model solutions will often give syntax errors on Oracle due to non-support for some SQL features in Oracle. Below are some tips on how you can rewrite the queries to work on Oracle. Oracle SQL Tips: non-standard features, and limitations The following issues are for Oracle 10, and may or may not apply to later versions of Oracle. Oracle does not support the as clause, except as part of the "with" statement. In all other cases, just use the same syntax without the "as" keyword, and things should work. To use a single quote in a string, use two consecutive single qu...
Comments