Term: CREATE

Definition:
The CREATE keyword is used when creating tables, views, triggers, and indexes. For detailed information on using the Oracle CREATE keyword, click on any of these links:

• The Oracle CREATE_TABLE Statement
  
  
• The Oracle CREATE_VIEW Statement
  
  
• The Oracle CREATE TRIGGER Statement
  
  
• The Oracle CREATE_INDEX Statement
  
  
• The Oracle CREATE PARTITION Statement

• Create User - Create the account that will own the database objects required to run the applicati...
• Create test data - Instructions: Copy the create table ddl into SQL/Plus. Set the number o...
• Create DB Link - Shows how to create a link to another oracle database and connect to it.
• Create User example - Simple example to create a user.
• Create trigger in Oracle - The code associated with a trigger is fired when a specified event occu...
• Create Operator - Similar to built-in operators, a user-defined operator may support arguments of ...
• Create Function - Some examples of user-created functions.
• Create INDEX - Samples of index creation.
• Create Package - A sample of the two necessary components of an Oracle package.
• Create Sequence - This is the basic create statement for sequences.
• CREATE USER - How to create a user and grant privileges and roles.
• Create View - Basic syntax for creating a view.
• Create Table INSERT (CTAS) - Create a table with the results from a SELECT statement.
• SEQUENCE: Create sequence demo - A sequence is an object in Oracle that is used to generate an aut...
• Check Constraint: Create - A check constraint allows you to specify a condition on a column in a table.
• Create Database Link - A database link is a schema object in one database that enables you to acce...
• USERS: CREATE USER w/ authentication - This example shows the CREATE USER syntax to have the user ...
• TABLESPACE: Create temp tablespace - Temporary tablespaces are used to manage space for database s...
• FUNCTIONS: Create function - Example of how to create a simple function.