:Base obe60.hlp
:Title Query Builder Help
1 Welcome!
2 Using the online help=usehelp>about
2 Documentation roadmap=Help_on_Help>about
1 New Features
2 Oracle8 Support
3 Oracle8 Server support=Oracle8_Server_support>newfeat
3 Oracle8 datatypes supported=Oracle8_datatypes_supported>newfeat
3 Oracle8 large objects (LOBs)=About_Oracle8_large_objects_LOBs>newfeat
3 Oracle8 user-defined objects=User_defined_objects>newfeat
3 Scalability and performance with Oracle8=Scalability_and_performance_with_Oracle8>newfeat
3 Support for PL/SQL 8=Support_for_PL_SQL_8>newfeat
3 Oracle8 features not yet supported=Oracle8_features_not_yet_supported>newfeat
1 Introducing Forms and Reports Developer Query Builder
2 Overview of Query Builder
3 About Query Builder=About_Query_Builder>about
3 About queries=About_queries>about
3 About databases and Query Builder=Databases_and_Query_Builder>about
3 About the command line=About_the_command_line>about
3 About error messages=err_external>about
2 Query Builder User Interface
3 About the Query Builder interface=About_Query_Builder_windows>about
3 Elements of the User interface=Elements_of_the_User_Interface>category
3 The Query Window
4 The Query window=About_the_Query_window>about
4 About the Conditions panel=About_the_Conditions_panel>about
4 About the Datasource panel=About_the_Datasource_panel>about
3 The Results Window
4 About the Results window=About_the_Results_window>about
1 New Features: Forms and Reports Developer Query Builder
2 New Feature Descriptions
3 Oracle8 Server support=Oracle8_Server_support>newfeat
3 Oracle8 datatypes supported=Oracle8_datatypes_supported>newfeat
3 User-defined objects=User_defined_objects>newfeat
3 Scalability and performance with Oracle8=Scalability_and_performance_with_Oracle8>newfeat
3 Support for PL/SQL 8=Support_for_PL_SQL_8>newfeat
3 Oracle8 features not yet supported=Oracle8_features_not_yet_supported>newfeat
1 Building and Running Queries
2 Setting up Query Builder
3 Launching Query Builder=Launching_Query_Builder>howto
3 Building or dropping the Query Builder sample tables=Building_or_dropping_the_Query_Builder_sample_tables>howto
2 Working with Queries
3 Creating a Query
4 Building a new query=Building_a_new_query>howto
4 Adding a column to your query=Adding_a_column_to_your_query>howto
4 Adding a column to your query using the Display dialog box=Adding_a_column_to_your_query_using_the_Display_dialog_box>howto
4 Removing a column from your query=Removing_a_column_from_your_query>howto
4 Counting rows before running the query=Counting_rows_before_running_the_query>howto
4 Retrieving all rows into your query=Retrieving_all_rows_into_your_query>howto
4 Hiding duplicate records in your query=Hiding_duplicate_records_in_your_query>howto
4 Adding comments to your query=Adding_comments_to_your_query>howto
4 Granting or revoking access to a query=Granting_access_to_your_query>howto
4 About opening queries=About_opening_queries>about
4 Opening a query=Opening_a_query>howto
4 Deleting a query=Deleting_a_query>howto
4 Running a Query
5 About Cartesian products=About_Cartesian_products>about
5 About automatic query execution=About_automatic_query_execution>about
5 Running a query using the Display dialog box=Running_a_query_using_the_Display_dialog_box>howto
5 Running a query using the menu=Running_a_query_using_the_menu>howto
5 Automatically running a query=Automatically_running_a_query>howto
4 Saving and Storing Queries
5 About storing queries=About_storing_queries>about
5 Saving your query as a SQL statement=Saving_your_query_as_a_SQL_statement>howto
5 Saving a subquery in a parent=Saving_a_subquery_in_a_parent_query>howto
4 Recovering a Query
5 About query recovery=About_query_recovery>about
5 Recovering a query=Recovering_a_query>howto
3 Enhancing Query Results
4 Formatting the Query
5 About formatting columns=About_columns>about
5 About formatting query results=About_formatting_query_results>about
5 Formatting your query results=Formatting_your_query_results>howto
4 Creating Summary Operations
5 About summary operations=About_summary_operations>about
5 Creating a column summary=Creating_a_column_summary>howto
4 Sorting and Grouping Query Results
5 About sorts=About_sorts>about
5 About break columns=About_break_columns>about
5 Sorting the query results=Sorting_the_query_results>howto
5 Removing a sort from your query results=Removing_a_sort_from_your_query_results>howto
5 Performing a break=Performing_a_break>howto
5 Changing break priority=Changing_break_priority>howto
5 Removing a break=Removing_a_break>howto
4 Formatting a Column
5 Changing a column position=Changing_a_column_position>howto
5 Adjusting column width=Adjusting_column_width>howto
5 Changing the column title=Changing_the_column_title>howto
5 Aligning column titles=Working_with_column_titles>howto
5 Creating a column summary=Creating_a_column_summary
3 Working with Complex Queries
4 About subqueries=About_subqueries>about
4 About independent subqueries for ad hoc reporting=About_independent_subqueries_for_ad_hoc_reporting>about
4 About SQL in subqueries=About_SQL_in_subqueries>about
4 About function subqueries=About_function_subqueries>about
4 About correlated subqueries=About_correlated_subqueries>about
4 Creating a function subquery=Creating_a_function_subquery>howto
4 Creating a correlated subquery=Creating_a_correlated_subquery>howto
4 Saving a subquery in a parent query=Saving_a_subquery_in_a_parent_query>howto
3 Printing and Exporting Query Results
4 About printer headers and footers=About_printer_headers_and_footers>about
4 Printing your query results=Printing_your_query_results>howto
4 Printing a range of cells=Printing_a_range_of_cells>howto
4 Exporting query results=Exporting_query_results>howto
2 Working with Tables
3 About datasources=About_datasources>about
3 About the Data Dictionary=About_the_Data_Dictionary>about
3 About table and column comments=About_table_and_column_comments>about
3 Locating available tables to use in your query=Locating_available_tables_to_use_in_your_query>howto
3 Renaming a table=Renaming_a_table>howto
3 Finding tables in other accounts and databases=Finding_tables_in_other_accounts_and_databases>howto
3 Finding and including a related table=Finding_and_including_a_related_table>howto
3 Using Columns in Tables
4 About datatypes=About_datatypes>about
4 Defining a Column
5 About defined columns=About_defined_columns>about
5 Defining a column=Defining_a_column>howto
5 Deleting a defined column=Deleting_a_defined_column>howto
5 Hiding a defined column=Hiding_a_defined_column>howto
5 Creating an expression=Entering_an_expression>howto
4 Formatting a Column
5 About formatting columns=About_columns>about
5 Adjusting the column width=Adjusting_column_width>howto
5 Changing a column position=Changing_a_column_position>howto
5 Repositioning columns in a table=Repositioning_columns_in_a_table>howto
5 Changing the column title=Changing_the_column_title>howto
5 Aligning column titles=Working_with_column_titles>howto
3 Creating Relationships
4 About relationships=About_relationships>about
4 About multiple relationship paths=About_multiple_relationships_paths>about
4 About key references=About_key_references>about
4 About primary keys=Primary_key>about
4 About foreign keys=About_foreign_keys>about
4 Deleting a relationship=Deleting_a_relationship>howto
4 Finding and including a related table=Finding_and_including_a_related_table>howto
4 Activiating and deactiviating relationships=Activating_and_deactivating_relationships>howto
4 Creating Simple Relationships
5 About simple relationships=Simple_relationship>howto
5 Creating a simple relationship=Creating_a_simple_relationship>howto
5 Using a simple relationship=Using_a_simple_relationship>howto
4 Creating Self-relationships
5 About self-relationships=Self_relationship>about
5 Creating a self-relationship=Creating_a_self_relationship>howto
4 Creating Composite Relationships
5 About composite relationships=About_composite_relationships>about
5 Creating a composite relationship=Creating_a_composite_relationship>howto
4 Creating and Removing Unmatched Relationships
5 About unmatched (numm) rows=About_unmatched_null_rows>about
5 Creating an unmatching relationship=Creating_an_unmatched_relationship>about
5 Removing an unmatched relationship=Removing_an_unmatched_relationship>howto
3 Sharing Data
4 About Dynamic Data Exchange (DDE)=Dynamic_Data_Exchange_DDE>about
4 Creating a dynamic link=Creating_a_dynamic_link>howto
4 Updating a DDE link=Updating_a_DDE_link>howto
2 Using the Data Editor
3 About the Data Editor=Data_Editor>about
3 Navigating in the Data Editor=Navigating_in_the_Data_Editor>howto
3 Inserting rows=Inserting_rows>howto
3 Updating a row=Updating_a_row>howto
3 Inserting data from a file=Inserting_data_from_a_file>howto
3 Deleting a row=Deleting_a_row>howto
3 Committing a change to a table=Committing_a_change_to_a_table>howto
3 Reverting changes to your database=Reverting_changes_to_your_database>howto
2 Working with Conditions, Functions, and Operators
3 Working with Conditions
4 About conditions=About_conditions>about
4 About negating conditions=About_negating_conditions>about
4 Building a condition=Building_a_condition>howto
4 Building a condition with columns not in the query=Building_a_condition_with_columns_not_in_the_query>howto
4 Creating a nested condition=Creating_a_nested_condition>howto
4 Creating multiple conditions=Creating_multiple_conditions>howto
4 Editing a condition=Editing_a_condition>howto
4 Creating a negating condition=Creating_a_negating_condition>howto
4 Reversing a negating condition=Reversing_a_negating_condition>howto
4 Deactivating and reactivating a condition=Deactivating_and_re-activating_a_condition>howto
4 Deleting a condition=Deleting_a_condition>howto
3 Working with Operators
4 About operators=About_operators>about
4 Building a condition=Building_a_condition>howto
4 Changing the top-level operator=Changing_the_top_level_operator>howto
4 Using the concatenation operator=Using_the_concatenation_operator>howto
3 Working with Functions
4 About Query Builder functions=About_Query_Builder_functions>about
4 Entering arguments for a function=Entering_arguments_for_a_function>howto
4 Defining a column=Defining_a_column>howto
4 Creating a function subquery=Creating_a_function_subquery>howto
2 Changing Display Preferences of the Results Window
3 Viewing gridlines in the Results window=Viewing_gridlines_in_the_Results_window>howto
3 Creating panes in the Results window=Creating_panes_in_the_Results_window>howto
1 Query Builder Reference
2 Administration
3 Administrator setup=Administrator_setup>referenc
3 Database accounts=Database_accounts>referenc
3 Ownership and administration=Ownership_and_administration>referenc
3 National Language Support (NLS)=National_Language_Support_NLS>referenc
2 The Command Line
3 Using the command line=Using_the_command_line>referenc
3 Using a command file=Using_a_command_file>referenc
3 Command line options=Command_line_options>referenc
3 Command line error messages=Command_line_errors>referenc
3 Command references
4 Batch destination commands=Batch_destination_commands>referenc
4 CONNECT command=CONNECT_command>referenc
4 EXECUTE command=EXECUTE_command>referenc
4 Memory commands=Memory_commands>referenc
4 OPEN command=OPEN_command>referenc
4 OWNERLIST command=OWNERLIST_command>referenc
4 OWNERLIST command arguments=OWNERLIST_command_arguments>referenc
2 Datasources
3 Access to datasources=Access_to_datasources>referenc
3 Using a query as a datasource=Using_a_query_as_a_datasource>referenc
2 Relationships
3 Relationship types=Relationship_types>referenc
3 Keyboard commands for relationships=Keyboard_commands_for_relationships>referenc
3 Activating and deactivating relationships=Activating_and_deactivating_relationships>referenc
2 Query Management
3 Using a query as a datasource=Using_a_query_as_a_datasource>referenc
3 SQL conversion=SQL_conversion>referenc
3 Query naming conventions=Query_naming_conventions>referenc
2 Conditions
3 Condition syntax=Condition_syntax>referenc
3 Condition validation=Condition_validation>referenc
3 Multiple conditions=Multiple_conditions>referenc
3 Non-equal relationships as conditions=Non_equal_relationships_as_conditions>referenc
3 Condition Operators
4 Comparison operators=Comparison_operators>referenc
4 Arithmetic operators=Arithmetic_operators>referenc
4 Logical operators=Logical_operators>referenc
4 Top-level operators=Top_level_operators>referenc
2 Functions
3 Functions and arguments=Functions_and_arguments>referenc
3 Types of functions=Types_of_functions>referenc
3 Number functions=Number_functions>referenc
3 Character functions=Character_functions>referenc
3 Character functions returning numeric data=Character_functions_returning_numeric_data>referenc
3 Conversion functions=Conversion_functions>referenc
3 Date functions=Date_functions>referenc
3 Group functions=Group_functions>referenc
3 Other functions=Other_functions>referenc
3 Function-defined columns=Function_defined_columns>referenc
2 Query Formatting
3 Number format=Number_format>referenc
3 Number format elements affecting cell width=Number_format_elements_affecting_cell_width>referenc
3 Number format elements not affecting cell width=Number_format_elements_not_affecting_cell_width>about
3 Date format=Date_format>referenc
3 Date format element prefixes and suffixes=Date_format_element_prefixes_and_suffixes>referenc
3 Time format=Time_format>referenc
3 Time format indicators=Time_format_indicators>referenc
3 Character format=Character_format>referenc
3 Formats using SQL=Formats_using_SQL>referenc
2 Editing Data
3 Elements of the Data Editor=Elements_of_the_Data_Editor>referenc
3 Editable queries=Editable_queries>referenc
3 Updatable columns=Updatable_columns>referenc
3 Insertable rows=Insertable_rows>referenc
3 Uneditable rows=Uneditable_rows>referenc
3 Deletable rows=Deletable_rows>referenc
3 Locked and altered rows=Locked_and_altered_rows>referenc
2 Sharing Data
3 Dynamic Data Exchange (DDE)=Dynamic_Data_Exchange_DDE>referenc
3 Updating a DDE link=Updating_a_DDE_link>referenc
3 Using a DDE client-compliant application=Using_a_DDE_client_compliant_application>referenc
2 Printing Query Results
3 Codes in headers and footers=Using_codes_in_headers_and_footers>referenc
1 Troubleshooting
2 About error messages=err_external>about
2 Calling Oracle Customer Support=err_callsp>referenc
2 Query Builder messages=Query Builder messages>category