Home » SQL & PL/SQL » SQL & PL/SQL » arrange
arrange [message #612156] Sun, 13 April 2014 15:34 Go to next message
ghosh898
Messages: 1
Registered: April 2014
Location: India
Junior Member
hi'
my table is like
create table product(P_ID varchar(20),P_NAME(30));

P_ID P_NAME
0/A Garments
0/A/1 kids
0/A/2 Male
0/B Electronics
0/B/1 kitchen appliance
0/A/1/1.1 Summer
0/B/1/1.1 Mixer
0/A/2/2.1 Shirt
0/A/1/1.2 Winter
0/A/10 Sports
0/A/10/10.1 Football

desired o/p:

0/A Garments
0/A/1 kids
0/A/1/1.1 Summer
0/A/1/1.2 Winter
0/A/2 Male
0/A/2/2.1 Shirt
0/A/10 Sports
0/A/10/10.1 Football
0/B Electronics
0/B/1 kitchen appliance
0/B/1/1.1 Mixer

i need your help to complete my project, please help..
thank u..
Re: arrange [message #612157 is a reply to message #612156] Sun, 13 April 2014 15:41 Go to previous messageGo to next message
BlackSwan
Messages: 23159
Registered: January 2009
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/
Re: arrange [message #612161 is a reply to message #612156] Sun, 13 April 2014 18:38 Go to previous message
Solomon Yakobson
Messages: 2079
Registered: January 2010
Senior Member
Read this topic.

SY.
Previous Topic: PL SQL prime number program explanation.
Next Topic: how to overcome mutating table error
Goto Forum:
  


Current Time: Sun Dec 21 22:19:00 CST 2014

Total time taken to generate the page: 0.10206 seconds