Very Computer

1. Oracle 7.34, 8.x, full outer join syntax

Can someone assist me? Sorry if this is too complicated.

I know the ansi syntax for full outer joins does not work in Oracle.
(I'm using ODBC BTW)

Can someone tell me
1) the syntax and
2) can I retrict the scope of the result set as mentioned below?

Thanks
Jeff Kish

table1 part (code, number, alt_num, AlphaNumeric)
table2 altpart(alt_num, AlphaNumeric)

table1 =        ('code1','part1','alt_num1','part1'),
        ('code2','part_2',NULL,','part2')
table2 =        ('alt_num1','altnum1'),
        ('altnum2','altnum2')

results of full outer join should be? 1st table1 row joined with 1st
table2 row and then 2nd table1 row and then 2nd table2 row, not
necessarily in that order:

'code1','part1','alt_num1','part1',     'alt_num1','altnum1'
'code2','part_2',NULL,'part2',  NULL,NULL
NULL,NULL,NULL,NULL,            'altnum2','altnum2'

About limiting the results, .. could I somehow get only entries which
were related to a certain value of number, say 'part1'

Thanks again,
Jeff Kish

2. CURSOR problems

3. Connecting to SQL Server 2000 from Oracle versions 7.34 and 8.1.7

4. Insert images in SQL

5. Personal Oracle 7.34

6. SQL Statement needs Performance Improvement

7. JDBC 2.0 / JDK 1.2 Drivers for Oracle 8.0x (not Oracle 8i)

8. DBA/Consultant Wanted

9. JDBC 2.0/3.0 Support Status/Strategies for JDBC drivers supplied by various vendors

10. JDBC Driver supported JDBC 2.0 features

11. Jdbc or odbc driver for paradox compatible with jdbc 2.0

12. How to Get Drivers to Use JDBC 2.0 with ORACLE