Re: How to do the SELECT sql ?

From: Oracle NetNews <joey.ogalesco_at_bigfoot.com>
Date: Mon, 29 Mar 1999 23:34:22 -0500
Message-ID: <7e1hkr$kvi$1@mtinsc01.worldnet.att.net>

try to use the BREAK command.

e.g. in your PL/SQL

set break on pay_no on pay_amt ;

select a.pay_no, a.pay_amt, b.inv_no, b.inv_amt, b.inv_tax from payment a, invoice b
where a.pay_no = b.pay_no;

Violin wrote in message <37062e61.8048893_at_news.twsc.pouchen.com.tw>...
>Hello all,
>I have a SELECT question.
>If I have 2 tables : PAYMENT and INVOICE
>
>PAYMENT Example of PAYMENT
>--------------------------------- ---------------------------------
>pay_no CHAR(4) 0001 5500
>pay_amt NUMBER(6)
>
>INVOICE Example of INVOICE
>--------------------------------- --------------------------------
>pay_no CHAR(4) 0001 A00001 2850 150
>inv_no CHAR(10) 0001 A00002 2425 75
>inv_amt NUMBER(6)
>inv_tax NUMBER(6)
>
>How to have the result ?
>
>PAY_NO PAY_AMT INV_NO INV_AMT INV_TAX
>---------------------------------------------------------------------------

---

>0001 5500 A00001 2850 150
> A00002 2475
75 Received on Mon Mar 29 1999 - 22:34:22 CST