Home » SQL & PL/SQL » SQL & PL/SQL » sql query (Oracle 9i)
sql query [message #314592] Thu, 17 April 2008 04:11 Go to next message
gurjarpankaj
Messages: 1
Registered: July 2005
Location: India
Junior Member
I want to display like following
Consider that using database scott/tiger

EMP_NAME Salary
FORD,SCOTT 3000

Report message to a moderator

Re: sql query [message #314596 is a reply to message #314592] Thu, 17 April 2008 04:24 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Search for the topic PIVOT

Report message to a moderator

Re: sql query [message #314598 is a reply to message #314592] Thu, 17 April 2008 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I recommend you to read the topics posted today, the answer is there.

Regards
Michel

Report message to a moderator

Re: sql query [message #314618 is a reply to message #314592] Thu, 17 April 2008 05:32 Go to previous message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
http://www.orafaq.com/forum/t/100914/111901/

Report message to a moderator

Previous Topic: SQL Query: Finding the Sum
Next Topic: is there something wrong with my variable?(pl/sql)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 08 04:08:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.