Discovering Oracle Database with SQL*Plus
This segment includes:
If you aren’t linked to Oracle databases as individual hour from SQL*Plus, notice “joining to Oracle collection as cellphone owner hour from SQL*Plus” after which return to this section.
Finding hour Schema Items with SQL*Plus
With SQL*Plus, you can view the stuff that participate in the hour scheme by querying the stationary data dictionary check out USER_OBJECTS .
Instance 2-2 shows suggestions view the titles and records kinds of the items that belong to the HR scheme.
Example 2-2 Finding HR Outline Toys with SQL*Plus
Outcome is similar to:
Oracle databases research for details about USER_OBJECTS
“picking desk Data” for information on making use of problems to see dining table information
“About trial scheme HR” for general details about the outline HR
Viewing STAFF Dining Table Qualities and Information with SQL*Plus
With SQL*Plus, you may use the SQL*Plus command DESCRIBE to view the attributes associated with columns on the WORKFORCE dining table through the HR outline as well as the SQL argument CHOOSE to see the data. Explore additional homes belonging to the dining table, use stationary facts dictionary views (case in point, USER_CONSTRAINTS , USER_INDEXES , and USER_TRIGGERS ).
Sample 2-3 indicates just how to look at the attributes of the WORKFORCE dining table through the HR schema.
Example 2-3 Finding WORKFORCE Counter Hotels with SQL*Plus
Situation 2-4 displays simple tips to see some reports for the PEOPLE dining table into the hour schema.
Case 2-4 Browsing STAFF Desk Data with SQL*Plus
Effect can be like:
“Selecting counter information” for details about using question to see desk facts
Oracle website mention for the informatioin needed for stationary reports dictionary views
Discovering Oracle Database with SQL Developer
This area produced:
Faq: Monitoring HR Schema Elements with SQL Creator
This guide demonstrates using SQL Developer to watch the stuff that belong to the HR schemaa€”that is, tips look at the hour scheme.
If you aren’t linked with Oracle databases as cellphone owner hour from SQL designer, notice “joining to Oracle data as owner HR from SQL designer” thereafter go back to this information.
To have a look at hour schema:
In the links framework, to the left on the hr_conn symbol, click on the additionally evidence (+) .
If you aren’t attached to the collection, the Connection Facts gap opens up. If you’re linked to the databases, the hr_conn details enlarges (start to see the ideas that observe “select OK” in step two).
If the association Ideas opening clear:
Inside consumer Name industry, key in hour .
Inside the code discipline, enter in the password for its cellphone owner hr .
The hr_conn know-how extends: The positive indication will become a negative sign (-), and beneath the hr_conn star, a long list of outline thing varieties appearsa€”information, looks, Indexes, etc .. (Should you go through the without signal, the hr_conn information breaks: The minus notice gets advantageous signal, in addition to the checklist vanish.)
Oracle website SQL beautiful User’s Guidebook have a look at concerning the SQL creator user interface
“About design outline HR” for common the informatioin needed for scheme HR
Guide: Finding WORKERS Dinner Table Attributes and Facts with SQL Developer
This tutorial demonstrates strategies for using SQL creator to enjoy the properties and facts of WORKERS dining table through the hour outline.
If you’re not checking the hour scheme, discover “information: watching hour Schema stuff with SQL designer” after which come back to this guide.
Explore the hotels and data of the STAFF MEMBERS stand:
Within the associations structure, develop game tables .
Under information, a list of the dining tables from inside the HR schema looks.
Choose the dinner table WORKERS .
Into the best framework associated with Oracle SQL beautiful panel, inside Columns pane, an index of all articles in this desk appears. To the right of each line were their propertiesa€”name, information kinds, and many others. (To see all column attributes, relocate the horizontal scroll pub on the right.)
Into the suitable frame, go through the tab reports .
The info pane sounds, featuring a numbered selection of all it offers video recording in this table. (observe more registers, shift the vertical browse bar out. To determine additional columns of information, transfer the horizontal scroll pub to the right.)
When you look at hookup site New Orleans the proper frame, click the bill Constraints .
The restrictions pane seems, display the all limitations on this particular dinner table. To the right of each and every restriction are actually its propertiesa€”name, type, google search disease, etc. (To see all constraint hotels, relocate the horizontal browse bar on the right.)
Examine the other homes by simply clicking the correct tabs.
Add a Comment