everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

Other Tools

01 02 03 04 05
<< Previous

Chapter # 01

Next >>


 

Introduction to Schema Builder

 

Introduction

Schema Builder allows you to define the tables, views, snapshots, synonyms, constraints, and table relationships that will make up your database. You can visualize your database design, including the tables, columns, data types, and relationships, and then execute that design.

 

Hands-On

In this Hands-On, you will learn how to: Create the “students” table, Define columns, Define attributes, Define Primary key, Define require field, Define Unique Key, Grant Privileges to public, Check what other users can access, Remove table, and Check table access.

 

Open Schema Builder tool

Open the “Schema Builder” tool.

Login as “oracle” password “learning,” and click on “connect.”

 

Click on the “OK” button.

 

Maximize the window if needed.

 

Create a table

Choose the “Schema” option, select “Create Table”, then click on ”Table.”

 

You should see the ‘+’ sign next to your cursor. Drag your “+” sign cursor and release it.

Resize your object if needed.

 

Rename a table

Choose the “Data” option and click on “Rename Table.”

In the ‘Rename Table’ window, change the “Table1” name to “Students,” and then click “OK” to rename the table.

 

Add columns and attributes

Click on the plus sign next to the ‘COLUMN1’ object to add new columns.

In the ‘Define Column’ window in the ‘Column Name’ box, type “Student_id;” its column attributes; and make it a Primary Key. Use any reasonable attributes to your column (Data type, Length, Default value, Primary key, Unique Key, or Required). Notice on the different attribute options available to you in the ‘Data Type’ box.

 

Click on "new column."

Type "first_name," its column attributes; and make it a required field.

 

Click on "new column."

Type "last_name," its column attributes; and make it a required field.

 

Click on "new column."

Type "ssn" for social security number, its column attributes; and make it an unique key.

 

Click “OK.” Your table will be created.

 

SQL statement

To check on the SQL statement, choose the "schema” option, and click on "Show SQL." Now, you should be able to see your SQL statement in the ‘Schema Editor: Show SQL’ window.

 

Save table in the database

To save your table in the database, click on “COMMIT” to create the table, and then

Close the window.

 

Now, the table was created.

Grant access privileges

To assign or grant privileges to others to access to your tables, choose the "File" option, and click on "Set privileges.”

 

In the ‘Set Schema Privileges’ window, you will see all your tables and all the Roles privileges that you are able to grant.

Assign the “Students” table to the public. Select the ‘Students’ table and the ‘PUBLIC’ role by highlighting them. Notice that the ‘Privileges’ box will change to white from gray.

Give select and insert privileges to the public by check mark them.

Click on "apply," and then close the window.

 

Now, the public users can only “insert” and “select” from the table.

Drop a table

Now, let’s drop the table.

Choose the “Schema" option and click on “Remove.”

 

The gray color indicates the object was removed.

 

Exit from “schema builder," and Click on "yes" to commit changes.

 

Questions:

Q: How can you create a table using the "Schema Builder" tool?

Q: How can you define a column, attribute, and primary key using the "Schema Builder" tool?.

Q: How can you define a required field and unique key using the "Schema Builder" tool?.

Q: How can you grant an object privilege to the public using the "Schema Builder" tool?

Q: How can you check what other users can access using the "Schema Builder" tool?

Q: How can you remove a table using the "Schema Builder" tool?

     Reviews and Templates for FrontPage
     

Copyright © everythingOracle.bizhat.com 2006 All Rights Reserved.