Create view sampleView as select city.countryCOde As abbr, country.Name As fullName from city;
Select * from sampleView;
Create view sampleView as [select city.countryCOde As abbr, country.Name As fullName from city;]
괄호로 만든다 테이블을 만들어서 뷰를 만든다.
'오락기 > OracleSQL' 카테고리의 다른 글
| cross join (0) | 2018.02.22 |
|---|---|
| CONSTRAINT (0) | 2018.02.22 |
| 조인과 서브 쿼리 비교 (0) | 2018.02.22 |
| group by / having (0) | 2018.02.22 |
| order by (0) | 2018.02.22 |