:Base obs60.hlp>about
:Title Schema Builder Online Help
1 Welcome!
2 Using the online help=usehelp>about
2 Documentation roadmap=Help_on_Help>about
1 Introducing Schema Builder
2 An Overview of Schema Builder
3 About Schema Builder=Brs25us_About_Schema_Builder>about
3 About databases and Schema Builder=Brs25us_Databases_and_Schema_Builder>about
3 Datasource object notation=Brs25us_Datasource_Object_Notation>about
3 Datatypes=Brs25us_Datatypes>about
3 Edit mode=Brs25us_Edit_Mode>about
3 The command line=CMNDLINE_About_the_Command_Line>about
3 The User Interface
4 The Datasource panel=Brs25us_The_Datasource_Layout_Panel>about
4 The Conditions panel=Brs25us_The_Conditions_Panel>about
2 Understanding Schemas
3 What is a schema?=Brs25us_What_is_a_Schema>about
3 Database relationships=Brs25us_Database_Relationships>about
3 Relationships and datatypes=Brs25us_Relationships_and_Datatypes>about
3 Primary-to-foreign key relationships=Brs25us_Primary_to_Foreign_key_Relationships>about
1 Building and Committing Schemas
2 Connecting/reconnecting to a database=SBSETUP_Connecting_Reconnecting_to_a_Database>howto
2 Using the Schema Builder Panels
3 Using the Datasource Panel
4 About the Datasource panel=Brs25us_The_Datasource_Layout_Panel>about
4 Resizing the Datasource panel=SBPANLS_Resizing_the_Layout_Panel>howto
4 Positioning datasource objects=SBPANLS_Positioning_Datasource_Objects>howto
4 Removing datasource objects from the Datasource Panel=SBPANLS_Removing_Datasource_Objects>howto
4 Cleaning up the layout=SBPANLS_Cleaning_Up_the_Layout>howto
4 Resizing datasource objects=SBPANLS_Resizing_Datasource_Objects>howto
4 Iconifying/deiconifying datasource objects=SBPANLS_Iconifying_Deiconifying_Datasource_Objects>howto
4 Changing the font of datasource objects=SBPANLS_Changing_the_Font_of_Datasource_Objects>howto
3 Using the Conditions Panel
4 About the Conditions panel=Brs25us_The_Conditions_Panel>about
4 Opening the Conditions panel=SBPANLS_Opening_the_Conditions_Panel>howto
4 Resizing the Conditions panel=SBPANLS_Resizing_the_Conditions_Panel>howto
3 Changing Display Preferences
4 Changing the split direction of the panels=SBPANLS_Changing_the_Split_Direction_of_the_Panels>howto
4 Setting display options for datasource objects=SBPANLS_Setting_Display_Options_for_Datasource_Objects>howto
4 Setting the default size of the Conditions panel=SBPANLS_Limiting_the_Default_Size_of_the_Conditions_Panel>howto
4 Setting default lengths for new columns=SBPANLS_Setting_Default_Lengths_for_New_Columns>howto
2 Building the Schema
3 Working with Datasource Objects
4 About datasource objects=datasrcs_About_Datasource_Objects>about
4 Creating Datasource Objects
5 Creating a table=datasrcs_Creating_a_Table>howto
5 Creating a view=datasrcs_Creating_a_View>howto
5 Creating a synonym=datasrcs_Creating_a_Synonym>howto
5 Creating a snapshot=datasrcs_Creating_a_Snapshot>howto
5 Including datasource objects in the schema=datasrcs_Including_Datasource_Objects_in_the_Schema>howto
5 Including related datasource objects in the schema=datasrcs_Including_Related_Datasource_Objects_in_the_Schema>howto
4 Copying Datasource Objects
5 About copying datasource objects=datasrcs_About_Copying_Datasource_Objects>about
5 Duplicating a datasource object=datasrcs_Duplicating_a_Datasource_Object>howto
5 Renaming datasource objects=datasrcs_Renaming_Datasource_Objects>howto
5 Clearing datasource objects=datasrcs_Clearing_Datasource_Objects>howto
5 Removing datasource objects from the schema=datasrcs_Removing_Datasource_Objects_from_the_Schema>howto
4 Defining Indexes
5 About indexes=datasrcs_About_Indexes>about
5 Creating indexes=datasrcs_Creating_Indexes>howto
5 Modifying indexes=datasrcs_Modifying_Indexes>howto
5 Deleting indexes=datasrcs_Deleting_Indexes>howto
4 Defining Columns
5 Creating new columns=datasrcs_Creating_New_Columns>howto
5 Adding new columns to a Table=datasrcs_Adding_New_Columns_to_a_Table>howto
5 Copying columns across datasource objects=datasrcs_Copying_Columns_Across_Datasource_Objects>howto
5 Renaming columns=datasrcs_Renaming_Columns>howto
5 Modifying columns=datasrcs_Modifying_Columns>howto
5 Deleting columns=datasrcs_Deleting_Columns>howto
5 Adding comments to datasource objects=datasrcs_Adding_Comments_to_Datasource_Objects>howto
3 Adding Constraints
4 Understanding Constraints
5 About constraints=CNSTRNTS_Understanding_Constraints>about
5 About constraint operators=oprators_About_operators>about
5 About functions in constraints=functns_About_functions>about
5 About multiple and nested constraints=CNSTRNTS_About_Multiple_and_Nested_Constraints>about
4 Applying Constraints
5 Defining a constraint=CNSTRNTS_Activating_the_Conditions_Panel>howto
5 Displaying constraints=CNSTRNTSDisplaying_constraints>howto
5 Editing a constraint=CNSTRNTS_Editing_a_Constraint>howto
5 Deleting a constraint=CNSTRNTS_Deleting_a_Constraint>howto
5 Changing the top level operator=CNSTRNTS_Changing_the_Top_Level_Operator>howto
5 Ungrouping constraints=CNSTRNTS_Ungrouping_Conditions>howto
5 Nesting constraints=CNSTRNTS_Nesting_Conditions>howto
5 Negating constraints=CNSTRNTS_Negating_Constraints>howto
5 Activating constraints=CNSTRNTS_Activating_and_Decactivating_Constraints>howto
3 Setting up Relationships
4 About relationships=RLNTSHPS_About_Relationships>about
4 Deleting relationships=RLNTSHPS_Deleting_Relationships>howto
4 Finding related tables=RLNTSHPS_Finding_Related_Tables>howto
4 Activating and deactivating relationships=RLNTSHPS_Activating_and_Deactivating_Relationships>howto
4 Creating Simple Relationships
5 Creating simple relationships=RLNTSHPS_Creating_Simple_Relationships>howto
4 Creating Self-relationships
5 About self-relationships=RLNTSHPS_About_self_relationships>about
5 Creating self-relationships=RLNTSHPS_Creating_Self_Relationships>howto
4 Creating Composite Relationships
5 About composite relationships=RLNTSHPS_About_Composite_Relationships>about
5 Creating composite relationships=RLNTSHPS_Creating_Composite_Relationships>howto
2 Saving and Discarding Changes to the Schema
3 Committing changes to the schema=SBSchema_Committing_Changes_to_the_Schema>howto
3 Discarding changes to the schema=SbSchema_Discarding_Changes_to_the_Schema>howto
3 Saving the schema as SQL=SbSchema_Saving_the_Schema_as_SQL>howto
3 Previewing the schema SQL statement=SBSchema_Previewing_the_Schema_SQL_Statement>howto
3 Granting privileges to other users, roles and PUBLIC=SBSchema_Granting_privileges_to_other_users_roles_and_PUBLIC>howto
1 Schema Builder Reference
2 Administration
3 Database accounts=sbsetup_Database_accounts>referenc
3 Ownership and administration=sbsetup_Ownership_and_administration>referenc
3 Structured Query Language=sbsetup_Structured_Query_Language>referenc
3 Database and object documentation=Database_and_object_documentation>referenc
3 Datasource object names=SBSETUP_Datasource_object_names>referenc
3 Key references=Key_references>referenc
3 National Language Support (NLS)=National_Language_Support_NLS>referenc
2 The Command Line
3 The command line=CMNDLINE_About_the_Command_Line>referenc
3 Using the command line with Windows=CMNDLINE_Using_the_Command_Line_with_Windows>referenc
3 Command line help=CMNDLINE_Command_Line_Help>referenc
3 Command line preferences=CMNDLINE_Command_Line_Preferences>referenc
3 Command line options=CMNDLINE_Types_of_Commands>referenc
3 Command line errors=CMNDLINE_Command_Line_Error_Messages>referenc
3 Command Line References
4 Connect command=CMNDLINE_Connect_command>referenc
4 Memory commands=CMNDLINE_Memory_commands>referenc
4 OWNERLIST command=CMNDLINE_OWNERLIST_command>referenc
4 OWNERLIST command arguments=CMNDLINE_OWNERLIST_command_arguments>referenc
2 Operators
3 Arithmetic operators=oprators_Arithmetic_operators>referenc
3 Comparison operators=oprators_Comparison_operators>referenc
3 Comparison rules=oprators_Comparison_rules>referenc
3 Logical (Boolean) operators=oprators_Logical_operators>referenc
3 Results of negated comparisons=oprators_Results_of_negated_comparisons>referenc
3 The concatenation operator=oprators_The_Concatenation_Operator>referenc
2 Functions
3 Functions and arguments=functns_Functions_and_arguments>referenc
3 Number functions=functns_Number_functions>referenc
3 Character functions=functns_Character_functions>referenc
3 Character functions returning numeric values=functns_Character_functions_returning_numeric_values>referenc
3 Conversion functions=functns_Conversion_functions>referenc
3 Date functions=functns_Date_functions>referenc
3 Other functions=functns_Other_functions>referenc
1 Troubleshooting
2 About error messages=err_external>about
2 Calling Oracle Customer Support=err_callsp>referenc
2 Schema Builder messages=Schema_Builder_messages>category