Home » SQL & PL/SQL » SQL & PL/SQL » select query (unix)
select query [message #376637] Thu, 18 December 2008 02:34 Go to next message
fakru.y
Messages: 34
Registered: May 2007
Member
Hi All,

Can we retrieve records from a table in row wise.

example: if we are going to retrive single column from table it should display the result in rowwise not in column wise.

result should appear like this

NO:1 2 3 4 5 6 7 8 9

Thanks in advance.
Re: select query [message #376642 is a reply to message #376637] Thu, 18 December 2008 02:52 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
This is a classic and I will open with a classic obvious question for you: do you expect the result to be concatenated (as a single string) or do you expect separate columns? This could be a problem as you need to know how many columns you're selecting in advance.

Some search terms that might give you a clue: concat_all, pivot query, ...

MHE
Re: select query [message #376645 is a reply to message #376642] Thu, 18 December 2008 03:03 Go to previous messageGo to next message
fakru.y
Messages: 34
Registered: May 2007
Member
The result should not be concatenated.it shoul be in seperate columns.
Re: select query [message #376648 is a reply to message #376645] Thu, 18 December 2008 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway, search for this every week asked question.

Regards
Michel
Re: select query [message #376681 is a reply to message #376648] Thu, 18 December 2008 04:38 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Laughing And there I was, prepared to write a demonstration script when all of the sudden it struck me: I've done this before.

Yes I have. Enjoy!

MHE
Previous Topic: File on Client Machine
Next Topic: Calling EXE from PL/SQL(urgent)
Goto Forum:
  


Current Time: Fri Dec 09 23:14:15 CST 2016

Total time taken to generate the page: 0.05103 seconds