On to page three. Now that the tables are all setup it is time to introduce the 3 basic types of joins to our audience. When the users of the tutorial we are creating runs the queries there is going to be a problem since the natural join will produce more resulted than are returned by default. To get around this problem the tag 'SQLExecutionOptions' is used. On the previous page you had a look at the option available in the Ad hoc SQL. This tag lets you get all available options within the Ad Hoc on page change. With that in mind option set on one page of a tutorial will be reverted to the default if no new setting are given for the transitioning page.
Available options:
- xml
- retrieve xml data 'true|false'
- clob
- retrieve clob data 'true|false'
- xmlinline
- embed the retrieved xml data in the result table 'true|false'
- clobinline
- embed the retrieved clob data in the result table 'true|false'
- blob
- retrieve blob data 'true|false'
- dbclob
- retrieve dbclob data 'true|false'
- termChar
- SQL statement termination character ';'
- commitPerStmt
- Commit per statement if false all statements will be run in a single transaction and rolled back on any errors
- numRowReturned
- Number of rows per result set to return
Steps to complete:
- Copy the contents of tab 'tutorialScript.xml' located to the right into the file 'tutorialScript.xml'.
- Save the file, but do not close it
- Create a file called 'joinBasics.html' in the folder './tutorials/tableJoins/HTML'
- Copy the contents of tab 'joinBasics.html' located to the right into the new created file.
- Save & close the file
- Create a file called 'joinBasics.sql' in the folder './tutorials/tableJoins/SQL'
- Copy the contents of tab 'joinBasics.sql' located to the right into the new created file.
- Save & close the file
- Reload the 'About table joins' tutorial you should now have and be able to navigate to page two.