Querying and Manipulating Data
Querying and Manipulating Data 2-1
2
Querying and Manipulating Data
This section shows how to explore the database, retrieve information from it, change
the information in existing tables, and control transaction processing.
This chapter contains the following sections:
Exploring Database Objects
In addition to tables, Oracle Database has many other database objects types. While
some objects have many extensive management options, most of them have similar
properties. For example, every object in a database belongs to only one schema, and
has a unique name with that schema. For that reason, Oracle recommends that your
object naming conventions and practices support clear identification of new objects
and object types with appropriate schemas. All objects that you will use here belong to
the same
hr
schema. Generally, applications work with objects in the same schema.
When you create your own objects, remember that object names cannot exceed 30
characters, and must start with a letter.
Looking at Schema Object Types
In this section, you will further familiarize yourself with the
hr
sample schema and its
attributes, or database objects. You will learn how you can view these objects by
browsing with the Oracle SQL Developer.
Start by examining some of the types of objects that each schema has.
To browse the HR schema:
1.
Start Oracle SQL Developer.
2.
In the SQL Developer navigation hierarchy, under the Connections tab, click the
'plus' sign next to
hr_conn
.
3.
In the Connection Information dialog, authenticate the connection to the
hr
schema by providing the password. Click OK.
