Chained full outer join in oracle 9# Database - 数据库
h*s
1 楼
Hi there,
I have a werid problem for chained full outer join in oracle.
I have following three tables:
SQL> desc part
Name Null? Type
----------------------------------------- -------- -----------------
PART_ID NOT NULL VARCHAR2(4)
SUPPLIER_ID VARCHAR2(4)
SQL> select * from part;
PART SUPP
I have a werid problem for chained full outer join in oracle.
I have following three tables:
SQL> desc part
Name Null? Type
----------------------------------------- -------- -----------------
PART_ID NOT NULL VARCHAR2(4)
SUPPLIER_ID VARCHAR2(4)
SQL> select * from part;
PART SUPP