1 / 7

CS422 Principles of Database Systems Introduction to Oracle

CS422 Principles of Database Systems Introduction to Oracle. Chengyu Sun California State University, Los Angeles. 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

hayesk
Télécharger la présentation

CS422 Principles of Database Systems Introduction to Oracle

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