Get weired table row reflections. How do I get rid of it?

[patilanjana]

Hi

Dynamic isql programming.

I am trying to present the query results. I get the desired results. But I also get greenish extra blank rows before my populated rows.

I hope you are understanding what I mean.

Thanks
Anjana.
----------------------------------------------------------------------

 
set serveroutput on
set echo off
set markup html entmap off
 
declare 
n number;
nparts number;
snparts number;
 
begin
  dbms_output.disable;
 
  dbms_output.put_line('<table border=1>');
  dbms_output.put_line('<tr>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('SNUM');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('SNAME');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('STATUS');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('CITY');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('TOTAL QTY');
  dbms_output.put_line('</th>');
  dbms_output.put_line('</tr>');
  dbms_output.put_line('<tr>');
for x in (select * from s order by s#)
loop
  select sum(qty) into snparts from spj where s#=x.s#; 
 
 
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.s#);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.sname);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.status);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.city);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(snparts);
  dbms_output.put_line('</th>');
  dbms_output.put_line('</tr>');
 
 
end loop; 
    dbms_output.put_line('</table>'); 
 
end;
 
 

[amitpatel66]

Could you give the sample data indicating your blank lines??
Is it something like few blank rows in a table that you are generating??

[subashsavji]

Try this May be helpful to you.....

 
DECLARE
n NUMBER;
nparts NUMBER;
snparts NUMBER;
BEGIN
  --dbms_output.disable;
  dbms_output.put_line('<table border=1>');
  dbms_output.put_line('<tr>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('empno');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('ename');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('job');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('mgr');
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line('Total_sal');
  dbms_output.put_line('</th>');
  dbms_output.put_line('</tr>');
  dbms_output.put_line('<tr>');
FOR x IN (SELECT * FROM emp where deptno=&deptno ORDER BY empno)
LOOP
  SELECT SUM(sal) INTO snparts FROM emp WHERE deptno=x.deptno;
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.empno);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.ename);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.job);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(x.mgr);
  dbms_output.put_line('</th>');
  dbms_output.put_line('<th>');
  dbms_output.put_line(snparts);
  dbms_output.put_line('</th>');
  dbms_output.put_line('</tr>');
END LOOP;
    dbms_output.put_line('</table>');
END;
/
 

and this also

 
 
SELECT xmlelement("Name",first_name), xmlelement("id",id), xmlelement("Date", start_date)
    FROM employee;
 
 

[amitpatel66]

Subashsavji,

Inspite of telling you so many times, you are repeatedly not using CODE TAGS for the source code.

You have also been requested to use CODE TAGS by PM, but I think you are not taking this seriously.

This will be last time I am requesting you to use the CODE TAGS, else I will need to give you official warning for not using CODE TAGS.

If you dont know about the guidelines of this forum, Check POSTING GUIDELINES

MODERATOR

[patilanjana]

Could you give the sample data indicating your blank lines??
Is it something like few blank rows in a table that you are generating??

Thank you for the response. There are no blanks rows in the table.

Lets take just one row of data,

'S1', 'SAM', 10,'Delhi', 500

Anjana

[patilanjana]

Subashsavji,

Inspite of telling you so many times, you are repeatedly not using CODE TAGS for the source code.

You have also been requested to use CODE TAGS by PM, but I think you are not taking this seriously.

This will be last time I am requesting you to use the CODE TAGS, else I will need to give you official warning for not using CODE TAGS.

If you dont know about the guidelines of this forum, Check POSTING GUIDELINES

MODERATOR

Did you mean to say,

 actual code 

. If yes, I will adhere to it next time. Sorry.

Anjana

[patilanjana]

I haven't learned xml yet. Programming it in isql, Can you help me with it?

Thank you.

Anjana

[amitpatel66]

Did you mean to say,

 actual code 

. If yes, I will adhere to it next time. Sorry.

Anjana

Hi Anjana,

Thats right. CODE tags need to be used every time source code is post in this forum

MODERATOR