Home » SQL & PL/SQL » SQL & PL/SQL » SQL output
icon8.gif  SQL output [message #200753] Wed, 01 November 2006 03:48 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi

I have a table of five columns with values like:
A    B    C   D     E     
__  ___  __ ___  __ 
1     2     4   5     t
4     5     3   4    g


My question is,

If i select two colums values then , it should display the output like this:

A       B
__     ___

"1"      "2"
"4"      "5"


Is this possible ?if yes, please tell me how?

Thanks

-Raaj
Re: SQL output [message #200762 is a reply to message #200753] Wed, 01 November 2006 04:22 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Very simple - you just do:

select '"'||column||'"'
from table

[Updated on: Wed, 01 November 2006 04:25]

Report message to a moderator

Re: SQL output [message #200764 is a reply to message #200753] Wed, 01 November 2006 04:27 Go to previous messageGo to next message
white
Messages: 13
Registered: October 2006
Junior Member



hi, i have one query here,
see whether will it works for u or not.
ok


SQL> select '"'||a||'"','"'||b||'"' from <tablename>;
icon14.gif  Re: SQL output [message #200769 is a reply to message #200753] Wed, 01 November 2006 04:44 Go to previous message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi

Thanks for ur prompt reply . All it works fine.
-Raaj Cool
Previous Topic: CREATE PROCEDURE change in 10G.
Next Topic: How specify more than 1000 values in IN operator
Goto Forum:
  


Current Time: Mon Dec 05 21:12:35 CST 2016

Total time taken to generate the page: 0.06059 seconds