Custom Folder dialog

Use this dialog to create custom folders. You do this by entering a SQL select statement. Like other folders, custom folders require joins in order for their data to relate to other data in the business area.

For more information, see:

"What are custom folders?"

"How to create custom folders"

Enter the SQL to define the custom folder

Use this field to enter the SQL statement that will define the folder. For example:

SELECT ENAME, JOB, SAL FROM EMP@ORCL

The Discoverer Administrator then creates items for each of the select list items. In Discoverer Plus, end users can use custom folders to build queries in exactly the same way as for other folders.

You can enter up to 2 billion characters in this field.

Name

Use this field to enter a name for the folder.

Validate SQL

Use this button to validate the SQL statement at any time before saving it. An invalid SQL statement prompts an error message.

OK

Use this button to validate the SQL statement and save the custom folder.

Notes

• Discoverer allows you to save the custom folder even if the SQL is invalid. This allows for situations where the SQL needs to be inserted into the EUL before the actual database objects are created or made available. However, users will not be able to query it until the SQL is corrected.

• If the SQL is invalid and you wish to correct it, select the custom folder in the Data tab and right-click to access its Properties dialog. Double-click on the Custom SQL field to display the Custom Folder dialog.

• The maximum length of the SQL statement you can enter in this field depends on the operating system and/or hardware specification of your machine.