i have table ,in that some of null values.
output come like as follows.
24,'babu',67,67,87
26,,34,,89
25,,89,98,,
how we elimenates the ','
out put will come as follows
24,'babu',67,67,87
26,34,89
25,89,98
how this style of report will in output.
any one would know sends me
as soon as ,
bye
friends
Style of report?
-
- Posts: 40
- Joined: Tue Jun 12, 2007 11:25 am
- Location: India
- Contact:
-
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
Hi,
I haven't understand your output details which your provided. So that, please provides me following details:
1. Send Me Table Description using DESC <table-name>;
2. Send Me Output of the Table using SELECT * FROM <table-name>;
Both result can you past here. I will analyse the same and let you know shortly.
Is there any queries, please let me know.
I haven't understand your output details which your provided. So that, please provides me following details:
1. Send Me Table Description using DESC <table-name>;
2. Send Me Output of the Table using SELECT * FROM <table-name>;
Both result can you past here. I will analyse the same and let you know shortly.
Is there any queries, please let me know.
-
- Posts: 40
- Joined: Tue Jun 12, 2007 11:25 am
- Location: India
- Contact:
hello sir,
u may know about reports 6i in that
i have table in that table some of columns empty
their is no data in that column
may be u know the comma report
in that layout is one main frame and one repeat frame
taken the formula column like F_1.
if we can display total table which i have some of columns empty
so ,if we can display table
it shows "," for each column
column is empty then we see like example
no number(4),name varchar2(20),sub1 number(3),sub2 number(3),sub3 number(3)
203,'babu',90,96,97
204,,98,98,98
205,'vijay',99,87,,
it show like this
but i what to result like as follows
203,'babu',90,96,97
204,98,98,98
205,'vijay',99,87
help me sir
have a nice day
bye
u may know about reports 6i in that
i have table in that table some of columns empty
their is no data in that column
may be u know the comma report
in that layout is one main frame and one repeat frame
taken the formula column like F_1.
if we can display total table which i have some of columns empty
so ,if we can display table
it shows "," for each column
column is empty then we see like example
no number(4),name varchar2(20),sub1 number(3),sub2 number(3),sub3 number(3)
203,'babu',90,96,97
204,,98,98,98
205,'vijay',99,87,,
it show like this
but i what to result like as follows
203,'babu',90,96,97
204,98,98,98
205,'vijay',99,87
help me sir
have a nice day
bye
Who is online
Users browsing this forum: No registered users and 0 guests