[orajit]

Hi,
I wanted to list the all columns of a emp table .
The output should be comma seperated and list of column should come in brakets like (enam,sal,jdate,job). The below code gives me proper result.
But I am facing problem with last column name .It comes with coma and then braket . I dont want that comma with last column name .
Can u tell me how to achieve that .

Please refer below code ..

Thanks in advance

Expand|Select|Wrap|Line Numbers

1. Declare
2.       CURSOR c1
3.      IS
4.          SELECT column_name
5.            FROM cols WHERE table_name='EMP';
6.  
7.    BEGIN
8.            dbms_output.put_line('(');
9.             FOR r1 IN c1
10.             LOOP
11.                       dbms_output.put_line(r1.column_name||',');
12.                    END LOOP;
13.                       dbms_output.put_line(')');
14.           END ;
15. /
16.  

Output is as below


(
ENAME,
SAL,
JDATE,
JOB,
)

I wanted output as

(
ENAME,
SAL,
JDATE,
JOB
)


(job with no comma)

[debasisdas]

that can be easily done by using toad or any other gui tool.

[orajit]

Thanks for ur reply ..But I am using SQLplus . Could u tell me is there any other method to get that .

[Saii]

You can use substr function on the output string.

[orajit]

can u plz update my code and show me that

[r035198x]

Originally Posted by orajit

can u plz update my code and show me that

Why don't you look up the sustr function, try the code and post your code if you still get errors.

[orajit]

Thank you fr ur help