pivot query

[Tomislav Kokoska]

I'm using SQL Tools 1.4.1 Beta build 66..

With this tool i be able to rotate grid, so i can see data horizontal and
vertical...

********************************************
Example..
query returns 1 row and 30 columns..listing and printing is defective, so i
need to rotate data

select * from real_estate_atribute where id = :id

bind variable id = 15

id Name Adress City State
Floor_Numer Telephone ............ Credit Cost
Hire
15 Shop Stereet 1 New York Usa 5
1321635 ................. 100000 $ 10000000$ true

I need to display transpose data through sql query ..How should i write
query to see data as follows..

Column Atribute
Id 15
Name Shop
Adress Steet1
City New York
State USA
Floor_number 5
Telephone 21635321
Credit 1000000$
.....etc.....
Cost 10000000$
Hire true
**********************************
i was looking for pivoting query on the internet but i didn't find similar
example...So please help

[FredBear]

"Tomislav Kokoska" <tkokoska@varteks.com> a écrit dans le message de
news:d6a0q2$8v6$1@ss405.t-com.hr...
| I'm using SQL Tools 1.4.1 Beta build 66..
|
| With this tool i be able to rotate grid, so i can see data horizontal and
| vertical...
|
| ********************************************
| Example..
| query returns 1 row and 30 columns..listing and printing is defective, so i
| need to rotate data
|
| select * from real_estate_atribute where id = :id
|
| bind variable id = 15
|
| id Name Adress City State
| Floor_Numer Telephone ............ Credit Cost
| Hire
| 15 Shop Stereet 1 New York Usa 5
| 1321635 ................. 100000 $ 10000000$ true
|
| I need to display transpose data through sql query ..How should i write
| query to see data as follows..
|
| Column Atribute
| Id 15
| Name Shop
| Adress Steet1
| City New York
| State USA
| Floor_number 5
| Telephone 21635321
| Credit 1000000$
| ....etc.....
| Cost 10000000$
| Hire true
| **********************************
| i was looking for pivoting query on the internet but i didn't find similar
| example...So please help
|

Goto Tom Kyte site: http://asktom.oracle.com/
and search for print_table.

Regards
Michel Cadot