Home » SQL & PL/SQL » SQL & PL/SQL » Script in PL/SQL language
Script in PL/SQL language [message #292109] Mon, 07 January 2008 21:05 Go to next message
susuOra
Messages: 10
Registered: December 2007
Location: USA
Junior Member
Hey all,

I haven't use PL/SQL language before. Therefore I'm asking your help.
I need to write a script that let me output each tuple of a table in one line.
Can someone help me with it.

Thanks,
Re: Script in PL/SQL language [message #292117 is a reply to message #292109] Mon, 07 January 2008 22:15 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

This is called Pivot Technique, This could be done in SQL . It is adviced to the tasks in SQL whenever possible rarther than going for PL/SQL routines

Thumbs Up
Rajuvan
Re: Script in PL/SQL language [message #292345 is a reply to message #292109] Tue, 08 January 2008 11:21 Go to previous messageGo to next message
susuOra
Messages: 10
Registered: December 2007
Location: USA
Junior Member
Thanks for the replying but I didn't understand what do you mean.
Is pivot a technique that allow me to do that.
and what is converting col row to row. are these tasks the same.

Thanks

[Updated on: Tue, 08 January 2008 11:30]

Report message to a moderator

Re: Script in PL/SQL language [message #292348 is a reply to message #292109] Tue, 08 January 2008 11:39 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I need to write a script that let me output each tuple of a table in one line.

SELECT * FROM mytable;

Regards
Michel
Previous Topic: TO_DATE function returns undesirable format
Next Topic: Outer Join with a constatnt
Goto Forum:
  


Current Time: Sun Dec 04 08:55:38 CST 2016

Total time taken to generate the page: 0.13661 seconds