OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » arrange

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

arrange [message #612156]

Sun, 13 April 2014 15:34

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..

Report message to a moderator

Re: arrange [message #612157 is a reply to message #612156]

Sun, 13 April 2014 15:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: arrange [message #612161 is a reply to message #612156]

Sun, 13 April 2014 18:38

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

Read this topic.

SY.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:28:02 CDT 2024