OraFAQ Forum: SQL & PL/SQL » split a long column into two rows

Home » SQL & PL/SQL » SQL & PL/SQL » split a long column into two rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

split a long column into two rows [message #19931]

Thu, 18 April 2002 20:35

gopinath
Messages: 3
Registered: April 2002

Junior Member

i am having along datatype long in my legse system.. but i don't have an equalent column in my oracle databasse..so i want to split the long datatype column into two rows ........

Report message to a moderator

Re: split a long column into two rows [message #19939 is a reply to message #19931]

Fri, 19 April 2002 06:24

M. Salman Sabir
Messages: 5
Registered: March 2002

Junior Member

make use of union and split ur query as follows:

select substr(col1,1,200) ....
union
select substr(col2,201,500)....

Report message to a moderator

Previous Topic:	Very Urgent .....Pl help me
Next Topic:	Query performance please Help!!!!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 06:04:45 CDT 2024