CREATE OR REPLACE VIEW dd
(d1, d2)
AS
SELECT t1.d1, t2.d2 from aaa t1, bbb t2 where t1.z = t2.z
(d1, d2)
AS
SELECT t1.d1, t2.d2 from aaa t1, bbb t2 where t1.z = t2.z
'Db > Oracle' 카테고리의 다른 글
| Oracle row_number() sample (2) | 2010.04.06 |
|---|---|
| Oracle Cursor 관련 사용 예제모음 (0) | 2010.04.06 |
| Oracle Trigger Sample (1) | 2010.04.06 |
| Oracle Sequence Sample (2) | 2010.04.06 |
| Oracle Package Procedure Sample (2) | 2010.04.06 |