Re: ** SQL Query Ouput Format **

parag9i_at_gmail.com wrote:

> Dept No : 10 Accounting No of Employees : 2

Look up new value in your SQL*Plus reference manual.

> Employee Details :
>
> Emp Name Salary

Check out noprint/set heading off

>
> Clark 2600
> Miller 1300
>
> Commission : ( I want only those records which are having commision )
>
> Dept no 10 having no records so no records will appear hear other than
> heading commission
>
> ------------------ page break --------------------------------

Lookup page break <skip [+]nnn> in the manual
>
> Dept No : 20 Research No of Employees : 5
>
> Employee Details :
>
> Emp Name Salary
>
> SMITH 800
> JONES 2975
> SCOTT 3000
> ADAMS 1100
> FORD 3000
>
> Commission : ( I want only those records which are having commision )
A union, probably: select name, salary union select name nvl(comm,0)....
> ADAMS 400
>

-- 
Regards,
Frank van Bortel