Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives - 2011 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through June 17, 2011 * SQL Doubt - Please help urgent !!! < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Bewarse Legend
Username: Blazewada

Post Number: 17027
Registered: 08-2008
Posted From: 202.124.30.8

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 2:53 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:



twanksee bemmam baa.. its working. procedure update chesi test cheyali ika.
Mind lo Fix Aithey Blind gaa ellipotaa...CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15880
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:33 am:    Edit Post Delete Post View Post/Check IP
select * from (select original_client_order_id, qty, price, status, approved_time_stamp
from table_name
start with client_order_id = :1
connect by prior original_client_order_id = client_order_id) a
where a.status = 'APPROVED'
AND a.approved_time_stamp = ....

ala use chesuko bhayya..
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15879
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:31 am:    Edit Post Delete Post View Post/Check IP
Lilliput:

SQL lo 6 chapters sadhivaan annai .... asalu ee problem ento kuda ardham kaaledhu naaku MOVIEART--rt.thoo

edanna inter college ki prof lekka ellipovadam better anukunta



initial ga attage untadi kani once edo oka job join ayyaka edo okati atta research chesthunte solution ade vasthadi..MOVIEART--ali
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15878
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:30 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

neeku kavalsina query vachesi..

select original_client_order_id, qty, price
from table_name
start with client_order_id = :1
connect by prior original_client_order_id = client_order_id;

:1 bind variable is nothing but the client order that you are passing..

ee query ni tweek chesuko bhayya neeku kavalsinattu..



This will give the multiple rows data data as client_order_id original_client_order_id
TEST-1308029407077-21 TEST-1308029291243-20
TEST-1308029407077-21 TEST-1308029252872-19
TEST-1308029407077-21 TEST-1308029252872-18
TEST-1308029407077-21 TEST-1308029252872-17

and other columns..but based on other where conditions get your exact row,..

you may not use the where clause when you are using connect by start with..so once you get the data use where clause...
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Mudiripoyina Bewarse
Username: Penkonda_tiger

Post Number: 4931
Registered: 06-2005
Posted From: 82.157.134.169

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:26 am:    Edit Post Delete Post View Post/Check IP
Lilliput:

r u musugu namitha fan penkul annai



Mussugu Malashri fan here

MOVIEART--ali
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Lilliput
Celebrity Bewarse
Username: Lilliput

Post Number: 9543
Registered: 08-2010
Posted From: 76.185.40.73

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:26 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

SQL lo 6 chapters sadhivaan annai .... asalu ee problem ento kuda ardham kaaledhu naaku MOVIEART--rt.thoo

edanna inter college ki prof lekka ellipovadam better anukunta MOVIEART--bemmi.abba
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Mudiripoyina Bewarse
Username: Penkonda_tiger

Post Number: 4930
Registered: 06-2005
Posted From: 82.157.134.169

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:26 am:    Edit Post Delete Post View Post/Check IP
Bazeee , as mentioned by other bedars .. Hierarchical query can sort out ur problem ..
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15877
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:24 am:    Edit Post Delete Post View Post/Check IP
Lilliput:



MOVIEART--bemmi.angry nenu ee connect by start with prior untadi ani thelsukovataniki 2 days pattindi..evo patha code vethikithe dorikindi..research chesthe vaarni anukunna..adhiripoyindi anukunna. MOVIEART--bemmi.excited
Top of pagePrevious messageNext messageBottom of page Link to this message

Lilliput
Celebrity Bewarse
Username: Lilliput

Post Number: 9542
Registered: 08-2010
Posted From: 76.185.40.73

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:22 am:    Edit Post Delete Post View Post/Check IP
Penkonda_tiger:

r u musugu namitha fan penkul annai MOVIEART--bemmi.poy
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15876
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:22 am:    Edit Post Delete Post View Post/Check IP
neeku kavalsina query vachesi..

select original_client_order_id, qty, price
from table_name
start with client_order_id = :1
connect by prior original_client_order_id = client_order_id;

:1 bind variable is nothing but the client order that you are passing..

ee query ni tweek chesuko bhayya neeku kavalsinattu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Mudiripoyina Bewarse
Username: Penkonda_tiger

Post Number: 4929
Registered: 06-2005
Posted From: 82.157.134.169

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:21 am:    Edit Post Delete Post View Post/Check IP
Lilliput:

ast poster ki initiator ki confuse ayya ee saari



http://www.ndtv.com/album/listing/entertainment/review-in-pics-namitha-i-love-yo u-7343#/slide/9
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Yavvanam Kaatesina Bewarse
Username: Vja

Post Number: 2485
Registered: 12-2009
Posted From: 72.184.151.231

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:19 am:    Edit Post Delete Post View Post/Check IP
select clientorderid,qty,price,status
from temp
start with ORIGINALCLIENTORDERID is null
connect by prior clientorderid = ORIGINALCLIENTORDERID;
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Lilliput
Celebrity Bewarse
Username: Lilliput

Post Number: 9540
Registered: 08-2010
Posted From: 76.185.40.73

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:15 am:    Edit Post Delete Post View Post/Check IP
last poster ki initiator ki confuse ayya ee saari MOVIEART--bemmi6
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15875
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:15 am:    Edit Post Delete Post View Post/Check IP
example..

http://www.adp-gmbh.ch/ora/sql/connect_by.html

start with connect prior should give you that recursive data..
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15874
Registered: 06-2004
Posted From: 72.129.47.191

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:14 am:    Edit Post Delete Post View Post/Check IP
use start with connect by..
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Bewarse Legend
Username: Blazewada

Post Number: 17026
Registered: 08-2008
Posted From: 202.124.30.8

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:07 am:    Edit Post Delete Post View Post/Check IP
Vja:

got yaa 'which is last aproved'



yuppu. last approved di kaavali. BTW, Approval time stamp kooda undi. adi miss chesaa ee table lo.
Mind lo Fix Aithey Blind gaa ellipotaa...CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Yavvanam Kaatesina Bewarse
Username: Vja

Post Number: 2484
Registered: 12-2009
Posted From: 72.184.151.231

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:01 am:    Edit Post Delete Post View Post/Check IP
got yaa 'which is last aproved'
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Yavvanam Kaatesina Bewarse
Username: Vja

Post Number: 2483
Registered: 12-2009
Posted From: 72.184.151.231

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 1:00 am:    Edit Post Delete Post View Post/Check IP
ekkad o miss ayindi baaaji baa
second daanloo original lcient order id 17 ki client order id 17 kooda undi ... so 34000,123.32 kadaa display avvalsindi...25000,199.32 antavendii

MOVIEART--bemmi.thinking
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Blazewada
Bewarse Legend
Username: Blazewada

Post Number: 17025
Registered: 08-2008
Posted From: 202.124.30.8

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, June 14, 2011 - 12:48 am:    Edit Post Delete Post View Post/Check IP
I need to have a recursive sql which can fetch the Order details for the parent Order (which is last approved).

Like, kindunna tables lo, 1st table lo:

For client Order:TEST-1308029407077-19,

I should get output as:

TEST-1308029252872-17 , Quantity: 34000 , price: 123.32


Client Order IDOriginal Client Order IDOrder typeQtyPriceStatus
TEST-1308029252872-17 New34000123.32Approved
TEST-1308029291243-18TEST-1308029252872-17Amend25000199.32Rejected
TEST-1308029407077-19TEST-1308029291243-18Amend54000200.32Pending



For client Order:TEST-1308029407077-21,

I should get output as:

TEST-1308029291243-18 , Quantity: 25000, price: 199.32

Client Order IDOriginal Client Order IDOrder TypeQtyPriceStatus
TEST-1308029252872-17 New34000123.32Approved
TEST-1308029291243-18TEST-1308029252872-17Amend25000199.32Approved
TEST-1308029291243-19TEST-1308029252872-18Cancel25000199.32Rejected
TEST-1308029291243-20TEST-1308029252872-19Amend100000200.32Rejected
TEST-1308029407077-21TEST-1308029291243-20Amend54000200.32Pending
Mind lo Fix Aithey Blind gaa ellipotaa...CLIPART--smoke

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration