oracleocpsqlintroduction(英文版)(完整版)
【正文】 oration, 2023. All rights reserved.Entity Relationship Modeling ConventionsEntitySoft boxSingular, unique nameUppercaseSynonym in parenthesesAttributeSingular nameLowercaseMandatory marked with “*”O(jiān)ptional marked with “o”Unique Identifier (UID)Primary marked with “”Secondary marked with “()”EMPLOYEE* number* nameo job titleDEPARTMENT* number* nameo locationassigned toposed ofI17 Copyright 169。 Oracle Corporation, 2023. All rights reserved.SQL StatementsSELECT INSERTUPDATEDELETEMERGECREATEALTERDROPRENAMETRUNCATECOMMITROLLBACKSAVEPOINTGRANTREVOKE Data retrieval Data manipulation language (DML)Data definition language (DDL)Transaction controlData control language (DCL)I24 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Summary? The Oracle9i Server is the database for Inter puting.? Oracle9i is based on the object relational database management system.? Relational databases are posed of relations, managed by relational operations, and governed by data integrity constraints.? With the Oracle Server, you can store and manage information by using the SQL language and PL/SQL engine.I26 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Relating Multiple Tables? Each row o
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1