Is there way, i can display query results in colum

Hello, Below is my requirement. Is there any way i can acheive that? If i fire the query " Select * from customer ", the o/p is like below(display is vertical): Customer_no : 101 Fname : Ravi Lname : Kumar ... ... ... My requirement is to display the results in horizontal way, like below... Customer_no Fname lname ... ------------------ ---------- --------- 101 Ravi kumar 102 Ajay xyz .... Thanks in advance for all your assistance. Regards, Ravikumar. --------------------------------- Here’s a new way to find what you're looking for - Yahoo! Answers

If you have the ability to create forms, you can display it on a screen for a user. If it's a print out, you can use ace report. The reason it goes vertical instead of horizontal is that it exceeds your environment for column width. In a text environment (i.e., nonGUI interface) it's usually 80 columns. Rob -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ravi kumar Sent: Wednesday, March 28, 2007 2:02 AM To: ids@iiug.org Subject: Is there way, i can display query results in c.... [8738] Hello, Below is my requirement. Is there any way i can acheive that? If i fire the query " Select * from customer ", the o/p is like below(display is vertical): Customer_no : 101 Fname : Ravi Lname : Kumar .... .... .... My requirement is to display the results in horizontal way, like below... Customer_no Fname lname ... ------------------ ---------- --------- 101 Ravi kumar 102 Ajay xyz ..... Thanks in advance for all your assistance. Regards, Ravikumar. --------------------------------- Here's a new way to find what you're looking for - Yahoo! Answers **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Excellent. Thanks for everyone who responded. I will try all the suggested solutions and will let the group know my result.. Thanks, Ravikumar. Rob Konikoff <rob.konikoff@us.army.mil> wrote: If you have the ability to create forms, you can display it on a screen for a user. If it's a print out, you can use ace report. The reason it goes vertical instead of horizontal is that it exceeds your environment for column width. In a text environment (i.e., nonGUI interface) it's usually 80 columns. Rob -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ravi kumar Sent: Wednesday, March 28, 2007 2:02 AM To: ids@iiug.org Subject: Is there way, i can display query results in c.... [8738] Hello, Below is my requirement. Is there any way i can acheive that? If i fire the query " Select * from customer ", the o/p is like below(display is vertical): Customer_no : 101 Fname : Ravi Lname : Kumar ..... ..... ..... My requirement is to display the results in horizontal way, like below... Customer_no Fname lname ... ------------------ ---------- --------- 101 Ravi kumar 102 Ajay xyz ...... Thanks in advance for all your assistance. Regards, Ravikumar. --------------------------------- Here's a new way to find what you're looking for - Yahoo! Answers **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Here’s a new way to find what you're looking for - Yahoo! Answers