Home » SQL & PL/SQL » SQL & PL/SQL » small doubt in sql
small doubt in sql [message #235063] Thu, 03 May 2007 23:44 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
hi,
i have table like


no
a
b
c
d
f
g
h
i
g

i want to 

no
abcdfghig



thanks
srinivas
Re: small doubt in sql [message #235066 is a reply to message #235063] Thu, 03 May 2007 23:48 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
You KNOW what we will ask, right?

[Edit: and please start chosing meaningful subjects. Some of your subjects so far:
small doubt in sql
sql help
sql null
sql help
basics step
sql swap
sql help
sql help
sql help
sql help
sql help
help sql [sic!]
sql help
sql help
sql help
sql help]

[Updated on: Thu, 03 May 2007 23:54]

Report message to a moderator

Re: small doubt in sql [message #235067 is a reply to message #235066] Thu, 03 May 2007 23:49 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
You have been following this site long enough to recognise this pattern. It is a pivot query. There are quite some examples around.
Re: small doubt in sql [message #235077 is a reply to message #235067] Fri, 04 May 2007 00:30 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
hi
frank
plase give me small example.
thanks
srinivas
Re: small doubt in sql [message #235078 is a reply to message #235077] Fri, 04 May 2007 00:37 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
I searched the board and came across this wonderful example
Maybe you should file a bug, because my search DID return 120 hits.
Previous Topic: Loading XML Type into ProC Variable
Next Topic: 10G Issue
Goto Forum:
  


Current Time: Sat Dec 14 15:28:23 CST 2024