1 / 7

Oracle Database Essentials: User Guide & Common Tasks

Learn about Oracle Database principles, data dictionary, SQL*Plus commands, and common tasks such as changing passwords and querying table schemas. Get started with Oracle 10g Enterprise Edition.

hayesk
Download Presentation

Oracle Database Essentials: User Guide & Common Tasks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CS422 Principles of Database SystemsIntroduction to Oracle Chengyu Sun California State University, Los Angeles

  2. Oracle on the CS Server • Oracle 10g Enterprise Edition • Release 10.0.1.3 • Database • Service name: orc.cs.calstatela.edu • SID: orc • Connect to the database • iSQL*Plus: http://cs.calstatela.edu:5560/isqlplus/ • SQL*Plus

  3. Data Dictionary • A collection of tables and views that contain the information about the schema objects in the database • USER_*: objects in user’s schema • E.g. USER_TABLES, USER_VIEWS, … • ALL_*: objects in the schemas that the user can access • E.g. ALL_USERS, ALL_TABLES, … • DBA_*: objects in all schemas

  4. Using Data Dictionary • Show tables • select table_name from user_tables; • Show table schema • describetable; • Show the tables in a different schema • select table_name from all_tables whereowner =schema;

  5. Common Tasks • Change password • alter userusernameidentifiedbynew_password; • Get current time • select sysdate from dual;

  6. Common SQL*Plus Tasks • Quit the client • exit or quit • Run script • @path/to/script • Format columns • columncolnameformat [a|9];

  7. Common Types • char(n), varchar(n), varchar2(n) • number(precision, scale) • int, integer, smallint • real, double, float • binary_float, binary_double • date, timestamp • clob, blob

More Related