11/04 (1장.Retrieving Data)

 Introduction

<Oracle10g의 구성요소>

1. Oracle Database 10g
2. Oracle Application 10g
3. Oracle Enterprise Manager 10g Grid Control

 

<Oracle 서버는 RDBMS이다>

 

•  정규화(Normalization) 정리하기

  - 강의홈 > 질문과답 > 정규화관련링크

 

<ERD- Entity Relationship Diagram>

 

Entity -> Table

Attribute -> Column

 

<Oracle's RDBMS?>

 

1장 - Retrieving Data Using the SQL SELECT Statement

 <SELECT statement의 기능>

1. Projection
2. Selection
3. Joining

 

<Arithmetic Expression - 산술식>

Arithmetic operators : Add, Subtract, Multiply, Divide

Operator Precedence

 

<Concatenation Operator>

 

<10g전용 Operator> - Alternative Quote(q) Operator

9i에서는

select 'I''m a boy..' from dual

10g에서는

select q'*I'm a boy..*' from dual;