Checking out Oracle Website with SQL*Plus
This section produced:
If you aren’t connected to Oracle collection as consumer HR from SQL*Plus, see “linking to Oracle collection as User hour from SQL*Plus” and then come back to this section.
Finding hour Scheme Items with SQL*Plus
With SQL*Plus, you can view the pieces that participate in the HR outline by querying the fixed info dictionary perspective USER_OBJECTS .
Model 2-2 reveals a way to view the figure and info different the pieces that belong to the HR scheme.
Illustration 2-2 Finding HR Outline Stuff with SQL*Plus
Result can be like most:
Oracle website mention for details about USER_OBJECTS
“Selecting desk facts” for details about using queries to watch desk info
“About taste scheme HR” for normal details about the schema HR
Monitoring PERSONNEL Desk Properties and Data with SQL*Plus
With SQL*Plus, you can utilize the SQL*Plus order DESCRIBE to watch the homes for the articles with the WORKERS dinner table inside HR outline along with SQL argument PICK to view the info. To view other qualities from the dinner table, utilize fixed reports dictionary perspective (including, USER_CONSTRAINTS , USER_INDEXES , and USER_TRIGGERS ).
Example 2-3 demonstrates strategy to look at the properties on the WORKFORCE dining table when you look at the HR scheme.
Example 2-3 Viewing WORKERS Desk Attributes with SQL*Plus
Illustration 2-4 displays just how to read some records inside the PEOPLE counter inside HR scheme.
Example 2-4 Watching WORKERS Dining Table Facts with SQL*Plus
Result can be like:
“choosing dinner table reports” for the informatioin needed for using issues to watch dining table info
Oracle collection research for details about stationary info dictionary views
Checking out Oracle Website with SQL Creator
This part produced:
Information: Monitoring hour Schema Toys with SQL Beautiful
This article reveals strategies for SQL creator to look at the objects that participate in the hour schemaa€”that is definitely, simple tips to browse the hour outline.
If you aren’t attached to Oracle Database as customer hour from SQL Developer, notice “attaching to Oracle databases as cellphone owner HR from SQL beautiful” following get back to this information.
To browse the HR outline:
From inside the links frame, left of hr_conn symbol, click on the positive sign (+) .
If you aren’t coupled to the website, the text data opening starts. If you’re linked to the collection, the hr_conn ideas enlarges (notice know-how that employs “select OK” in step two).
If your connections Facts windows clear:
In individual brand niche, type in hour .
Inside code subject, enter the password for that individual hr .
The hr_conn expertise stretches: The additionally indication becomes a minus sign (-), and under the hr_conn star, an index of schema thing sort appearsa€”dining tables, Views, Indexes, etc. (in the event you click on the without indicator, the hr_conn information breaks: The without indication ends up being advantageous evidence, along with number disappears.)
Oracle collection SQL beautiful customer’s instructions to read more regarding the SQL beautiful graphical user interface
“About design Schema HR” for general information about scheme HR
Guide: Watching PERSONNEL Dinner Table Residential Properties and Information with SQL Beautiful
This information demonstrates utilizing SQL beautiful to look at the properties and records with the STAFF table from inside the hour scheme.
If you are not browsing the hour schema, find out “Article: monitoring hour outline stuff with SQL designer” following return back this article.
To review the qualities and data of the STAFF MEMBERS desk:
In the associations structure, grow information .
Under Tables, an index of the tables in HR scheme looks.
Select the desk STAFF .
During the proper body with the Oracle SQL creator panel, in Columns pane, an index of all articles about this dining table appears. On the right for each line are actually its propertiesa€”name, data type, and many others. (ascertain all column belongings, go the horizontal scroll club on the right.)
In the best frame, click the tab facts .
The information pane shows up, showing a designated total of all captures video at this stand. (to view extra registers, shift the upright scroll bar lower. To view a whole lot more articles of this lists, relocate the horizontal scroll bar off to the right.)
From inside the proper frame, click on the loss regulations .
The limitations pane shows up, expressing an index of all regulations about dining table. Right of each and every limitation were the propertiesa€”name christian connection Profiel, sort, research problem, for example. (to check out all limitation homes, move the horizontal move pub to the right.)
Explore additional homes by hitting the correct tabs.