| Author | Message | ||
     Jambalahaart_raja Side Hero Username: Jambalahaart_raja Post Number: 2586 Registered: 07-2008 Posted From: 68.39.7.247 Rating: N/A |
 gee lekkanna neek IT correst kaadu. neek management correst suit ayithadi!!!Three lessons for life - F**k, Don't give a F**k, Don't get F**ked!! - Robert Downey Jr. | ||
| Giriqwert Junior Artist Username: Giriqwert Post Number: 872 Registered: 09-2011 Posted From: 122.167.249.144 Rating: N/A |
tech studs..intha knawledge tho ela untaru annayyalu meeru..god promise kindaling kadu.. oka mukka artham kaledu code..  | ||
| Buduguuu Hero Username: Buduguuu Post Number: 13407 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
ee thread inka enduku nadustunnadi  Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
| Megastar Username: Twitter Post Number: 26662 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
u got it yeap this is my idea too ..for now instead of temp table i'm dumping into gtt..if i see any latency due to gtt then i will implement some in memory structure. | ||
| Jambalahaart_raja Side Hero Username: Jambalahaart_raja Post Number: 2580 Registered: 07-2008 Posted From: 68.39.7.247 Rating: N/A |
From what I can understand so far, and what I have read, watcher will give ref-cursor to a result-set, you want max-value from that result-set and your only option is to use that ref-cursor, and also return the ref-cursor undisturbed. If so, intha complicated requirement ki Pointer-program/logic saripodu. You have to dump the contents from the pointer to an in-memory entity like a PL/SQL table type. Three lessons for life - F**k, Don't give a F**k, Don't get F**ked!! - Robert Downey Jr. | ||
| Megastar Username: Twitter Post Number: 26660 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
ivvi oltp live tables eppatikappudu watcher will be watching if trx happened..if happens then get that result set ..ee result set data vere messaging / reporting ki vaadukovali, result set gui ki raaka mundhe maxid inko chota pettukovalani anthe..gui dhaaka vasthe chaala options untai adhi vere vishayam.. we are not concerned abt history data so between time slices ruled out. | ||
| Jambalahaart_raja Side Hero Username: Jambalahaart_raja Post Number: 2576 Registered: 07-2008 Posted From: 68.39.7.247 Rating: N/A |
Honest gaa seppalante requirement lo clarity ledu. High-frequency transactions jarigey tables and data-sets meeda antha sudden gaa max transaction value vunna Id teeyatam ayithe OK, mari result-set enti annattu?? Those high-freq transaction tables meeda time-slice, ante specific range between time-stamps choosi query run seskunte meeku result-set toh paatu max value vunna Id rendu vasthaayi kada? Three lessons for life - F**k, Don't give a F**k, Don't get F**ked!! - Robert Downey Jr. | ||
| Megastar Username: Twitter Post Number: 26659 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
requirement demanding raajaa..scenario cheptha choodu aa time lo jarigina trades naa cursor1 lo unnai , andhulo max id theeskoni inko chota store cheskovali, aa maxid kosam inko select raayakoodadhu endhukante ee lopu inko trade jarigi maxid veredhi vachhuddhi ala konni slip authai..andhukani first cursor1 lo unna max id kaavali..cursor1 ne loop thippi maxid theeskovocchu kaani once you open the cursor you have to close it that means you are disposing that, ikkada dispose cheyakoodadhu endhukante aa result set naaku return kaavali , ippudu cursor2 naa mindloki vacchindhi ..cursor1 tho kavalasina aatalu aadukoni cursor2 ni use resultset ga use cheskundham ani.. logic ledhantaava ? | ||
| Jambalahaart_raja Side Hero Username: Jambalahaart_raja Post Number: 2573 Registered: 07-2008 Posted From: 68.39.7.247 Rating: N/A |
Logic lo yendo tappu koduthonde. Idoka logical approach ayyi vunte Oracle would have provided this in the first place kaadaa??? Three lessons for life - F**k, Don't give a F**k, Don't get F**ked!! - Robert Downey Jr. | ||
| Megastar Username: Twitter Post Number: 26657 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
coming to your googling skills you are way better than me naakaithe dhorakaledhu aa link | ||
| Megastar Username: Twitter Post Number: 26656 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
correcto kadho ane vishayam pakkana pedithe ..chala complicated ga undhi aa types creation antha sollu la undhi ..inka edhanna vg paddhathi undhemo anukunna like .net lo oka dataset nundi inko dataset ki copy chesinattu..microsoft rocks yaa ee vishayam lo | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 6761 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
nenu ichina link useful aindo kaledo seppi..naa googling skills taggayemo ani davuting ga undi... ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Megastar Username: Twitter Post Number: 26655 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
yeah athyantha vg way temporary tables concept tho chesesaa ..first pani ayindhi chalu perf issues osthe tharvatha choodham | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 6760 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
correst kada?? http://ellebaek.wordpress.com/2011/03/29/copying-transformin g-a-ref-cursor-in-oracle-10g/ jai google thalli ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Buduguuu Hero Username: Buduguuu Post Number: 13403 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
annai swarry. ninna intiki ragane temple atu nundi cinema ki ellan. asalu kudarane ledu. resolve ayyindi annaru kabatti li8 teesukuntunna  Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
| Megastar Username: Twitter Post Number: 26639 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
ekkada dhorikindhi babu  edhi link unte pettu chooddham .. ee cursors tho dleka ee saariki gtt's tho laaginchale ..inka li8 thx .. budugai ki kooda thx | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 6756 Registered: 02-2010 Posted From: 68.48.62.237 Rating: N/A |
declare rc1 sys_refcursor; rc2 sys_refcursor; fetched_row ref_cur_copy_<seq>_t := ref_cur_copy_<seq>_t(null, ..., null); fetched_rows ref_cur_copy_<seq>_c := ref_cur_copy_<seq>_c(); n pls_integer := 0; ... begin rc1 := :rc1; loop exit when not rc1%isopen; fetch rc1 into fetched_row.<col1>, ..., fetched_row.<coln>; exit when rc1%notfound; n := n + 1; ---Jai Gugulu thalli ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Megastar Username: Twitter Post Number: 26638 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
avesapadi first method copying anukunna kani kadhu ga .. resultset report kosam kaavali andhuke ref cursor  | ||
| Megastar Username: Twitter Post Number: 26637 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
vacchesava babai ..let me try this first | ||
| Buduguuu Hero Username: Buduguuu Post Number: 13393 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
declare cursor abc is select * from dummy B ABC%ROWTYPE; procedure BAR (a number) as begin DBMS_OUTPUT.PUT_LINE (a); end; begin for a in ABC loop B :=a; bar(b.dummy); end LOOP; end; mee variables ni inko function or procedure ki pampali ante idi. Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
| Buduguuu Hero Username: Buduguuu Post Number: 13392 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
declare cursor abc is select * from dual; B ABC%ROWTYPE; begin for a in ABC loop B :=a; DBMS_OUTPUT.PUT_LINE (B.DUMMY); end LOOP; end; direct cursror variable declare chesi variables laane assign cheyachu ga. asalu ref cursor enduku? mottam results ni bulk ga assign cheyyakunda row wise assing cheste problem enti naku performance tuning pedda idea ledu. oka vela inni sarlu assign chesi function/prod calls waste anipiste intikelli ref cursor sample ista Coolmac : nanu comment sesey staayi ledhu neeku Biryani about Mahesh Babu | ||
| Megastar Username: Twitter Post Number: 26636 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
rendu selects raasi rendu curs thecchukovocchu kaani..select ki select ki madhyalo edhanna transaction jaragocchu aa latency lo edhaina anyaayam jaragocchu ..andhukani aa option ruled out. | ||
| Megastar Username: Twitter Post Number: 26635 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
babailoo oka ref cursor nundi inko ref cursor ki contents ela copy cheyyali say i have cur1 with 100 rows , i want to make copy of this cur1 to cur2. ela seyyali ? |
