| Author | Message | ||
Driverramudu Side Hero Username: Driverramudu Post Number: 9943 Registered: 02-2009 Posted From: 166.137.210.46 Rating: N/A |
driver.ramudu79 @gmail.com looking fwd for ur mail with details  Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
Megastar Username: Twitter Post Number: 24814 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
adho peddha kadha le babai ..email id padei | ||
Driverramudu Side Hero Username: Driverramudu Post Number: 9941 Registered: 02-2009 Posted From: 166.137.210.49 Rating: N/A |
y dont u xplain conceptually so that i would try to come with query if you feel comfortable Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
Megastar Username: Twitter Post Number: 24813 Registered: 10-2009 Posted From: 192.193.216.147 Rating: N/A |
ee cursors tho kastam ani approach marchesa GTT's vaadaka thappaledhu .. ila cursors vaadukuntoo pothe konni vandhala loops authunnai ..brokkaipoddhi.. neways thx for your help. | ||
Driverramudu Side Hero Username: Driverramudu Post Number: 9938 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
based on urs intital post and based on my understanding this code examle might be useful but remember it is using ref cursor which is not good performance point of view.. http://www.devshed.com/c/a/Oracle/Working-with-REF-CURSOR-in -PL-SQL/3/ Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
Buduguuu Hero Username: Buduguuu Post Number: 10693 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
ma telangana maaggavale  | ||
Sachin Legend Username: Sachin Post Number: 33545 Registered: 04-2008 Posted From: 151.151.16.5 Rating: N/A |
babu twitter...asalu aa error vasthunna declaration neeeku akkarledu... rendo cursor enduku ante seppav...asalu eti kavalo enduku kavalo seppakundaa etla vayya neeku solution seppedi share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Sachin Legend Username: Sachin Post Number: 33544 Registered: 04-2008 Posted From: 151.151.16.5 Rating: N/A |
neneti sesaaaanu... share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Buduguuu Hero Username: Buduguuu Post Number: 10690 Registered: 01-2012 Posted From: 199.249.176.251 Rating: N/A |
ee taadu ni muuseyyandi. twitter annai code snippet pettakunda error ante kattam  | ||
Driverramudu Side Hero Username: Driverramudu Post Number: 9937 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
  Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
Kish Megastar Username: Kish Post Number: 28590 Registered: 02-2008 Posted From: 8.34.148.198 Rating: N/A |
 ||  || PK || JP || MODI || CBN || SACHIN || JDLN || EENADU || HYDERABAD || | ||
Driverramudu Side Hero Username: Driverramudu Post Number: 9935 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
let me know the requirement Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
Kaisersooze Moderator Username: Kaisersooze Post Number: 7471 Registered: 04-2009 Rating: N/A |
enduku? data entha vundhi table lo? edhina values compare cheyali antae table type use chesi process cheyachu...performance kosam aithae use bulk cursor.. | ||
Jodhaa Megastar Username: Jodhaa Post Number: 25575 Registered: 02-2008 Posted From: 69.174.58.140 Rating: N/A |
parthuuuu..  | ||
Kaisersooze Moderator Username: Kaisersooze Post Number: 7470 Registered: 04-2009 Rating: N/A |
declare cursor cml is select first, last, address, d_phone from customers; Begin for cus_row in cml loop dbms_output.put_line(cus_row.first||' ' ||cus_row.last||' '||cus_row.address||' '||cus_row.d-phone) end loop; end; | ||
Sachin Legend Username: Sachin Post Number: 33542 Registered: 04-2008 Posted From: 151.151.16.5 Rating: N/A |
 share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Megastar Username: Twitter Post Number: 24812 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
cursors ki alternative cheppannai , how abt using table types /varrays etc ? do i still have that flexibilty of using types as sql tables ? | ||
Driverramudu Side Hero Username: Driverramudu Post Number: 9934 Registered: 02-2009 Posted From: 76.95.148.203 Rating: N/A |
Assal first of all why do you need cursors its very expensive Let me know your requirement and i may help you without using cursors Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
Buduguuu Hero Username: Buduguuu Post Number: 10685 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
meeru atleast mee code replica pettina bane undedi(changing table/column names etc). evo snippets pedutunnaru. teliyatledu. hmm... sachina lanti ekasperts ee seppali | ||
Megastar Username: Twitter Post Number: 24811 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
anthenantaara sir choodham inkasepu peekkoni padukoni migathadhi repoddhuna peekutha ..thx for your inputs. | ||
Buduguuu Hero Username: Buduguuu Post Number: 10682 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
ala aite em problem kanapadatledu sir. meeru declaration lo edo mistake chesaru. aa error meaning ade mari | ||
Megastar Username: Twitter Post Number: 24810 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
sorry my bad, close ga undhani online lo dhorikina oka example esa ..yes your are right cus_row cmls%rowtype ane undhi naa code lo | ||
Buduguuu Hero Username: Buduguuu Post Number: 10681 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
amnd meeru asalucursor variable declare chesey pane led na exampke lo cheppinattu for i in cus_row ani proceed aipochu | ||
Buduguuu Hero Username: Buduguuu Post Number: 10680 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
sir, cus_row and customer table have same no of columns with same data type?? if not mee cursor variable declaration wrong. cus_row customers%rowtype; should be cus_row cml%rowtype; it is always best practice to declar cursor variables using cursor name directly | ||
Sachin Legend Username: Sachin Post Number: 33541 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
asalu error vasthunna line nuvvu comment cheseyyochu... http://sql-plsql.blogspot.com/2007/05/oracle-plsql-cursor-fo r-loops.html share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Megastar Username: Twitter Post Number: 24807 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
atu itu ga ittanti code anuko : declare cursor cml is select first, last, address, d_phone from customers; cus_row customers%rowtype; --ee line dhaggara error osthundhi Begin for cus_row in cml loop dbms_output.put_line(cus_row.first||' ' ||cus_row.last||' '||cus_row.address||' '||cus_row.d-phone) end loop; end; | ||
Buduguuu Hero Username: Buduguuu Post Number: 10679 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
meek oopika unte oka saari code sample ikkada raayandi. meerichina error definite ga declaration problem valla vachede. context clear aite better answer iyyachu ani na adi na idi | ||
Sachin Legend Username: Sachin Post Number: 33540 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
cursor defnition/usage lo edo mistake chesthunnatttunnav share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Sachin Legend Username: Sachin Post Number: 33539 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
TOAD is the best...nuvvu rasina code ikkada paste cheyi...error enduko chepthaa repu morning choosaka...time to sleep for now... sql developer also not bad share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Megastar Username: Twitter Post Number: 24806 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
ee code exception osthadhi endhukante dept_cur open cheyaka mundhi use chesadu.. kaani na code Declare dept_rec emp_cur%ROWTYPE where emp_cur is already present. screen shots ettakoodadhannai ..mammulni ila brathakanivvu | ||
Buduguuu Hero Username: Buduguuu Post Number: 10678 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
PLS-00320: the declaration of the type of this expression is incomplete or malformed ida error? In a declaration, the name of a variable or cursor is misspelled or the declaration makes a forward reference. Forward references are not allowed in PL/SQL. A variable or cursor must be declared before it is referenced it in other statements, including other declarative statements. For example, the following declaration of dept_rec raises this exception because it refers to a cursor not yet declared: DECLARE dept_rec dept_cur%ROWTYPE; CURSOR dept_cur IS SELECT ... . oopika unte oo paali screenshot ettandi annai mee code di | ||
Megastar Username: Twitter Post Number: 24805 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
ante konni formulas/filters applying chesi pampisthan annai oorake copy kadhu | ||
Megastar Username: Twitter Post Number: 24804 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
oh cool. try chesa already endhuko aa 00320 error vacchi sava kottings..may be indhaka cheppinattu editor issue ayyundocchu .. plsql development ki manchi tool cheppu other than SQL Developer and toad | ||
Buduguuu Hero Username: Buduguuu Post Number: 10676 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
and second cursor loki first cursr values ni maatram pampinchi em cheddam ani mee next plan? | ||
Buduguuu Hero Username: Buduguuu Post Number: 10675 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
a1 is the col1 from first cursor b1 is col2 from first cursor c1 is col3 from first cursor | ||
Buduguuu Hero Username: Buduguuu Post Number: 10674 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
already a1 b1 c1 ani amptunnam kada? inkenti? aa values direct ga edanna table loki insert cheyyala? | ||
Sachin Legend Username: Sachin Post Number: 33536 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
1000 is number of rows annai... lets say your main corsor sql has 10000 records and you defined limit of 1000...then you put ( FETCH) 1000 and put it into a plsql table (in this case s_array )...then ou open a loop for s_array and process those 1000 records..once done you go to next 1000 and so on... share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Megastar Username: Twitter Post Number: 24803 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
hmmm first cursor correcte kaani second dhantloki table3 data kadhu ampalsindhi first cursor data . | ||
Megastar Username: Twitter Post Number: 24802 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
c2 is a brand new empty cursor .
ee 1000 limit dheniki ? for entire array or just for a row ? idhi try chesa ivvala morning .. may be na IDE issue ayyundocchu I'm using SQL Developer aa angle lo try chestha . . thx for help. | ||
Buduguuu Hero Username: Buduguuu Post Number: 10673 Registered: 01-2012 Posted From: 24.107.4.53 Rating: N/A |
nenu chala simple ga ardam chesukunna anukunta. it may be more complex cursor first is select col1,col2,col3 from table1 a,table2 b where a.col4 = b.col4; cursor second(a1,b1,c1) is select col1,col2,col3 from table3 d,table4 e where d.col5= c.col5 and d.col6 = a1 and d.col6 = c.col6 and c.col7= b1 and d.col7 = c1; begin for i in first loop for j in second(i.col1,i/col2,i.col3) loop processing end loop; end loop; end; first is name of first cursor second is name of second cursor.. a1,b1,c1 are input variables to that cursor col1,col2 etc are column names in that tables table1,table2 etc are your table names | ||
Sachin Legend Username: Sachin Post Number: 33535 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
what is C2? share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Sachin Legend Username: Sachin Post Number: 33534 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
you can use a plsql table ... DECLARE CURSOR s_cur IS SELECT * FROM servers; TYPE fetch_array IS TABLE OF s_cur%ROWTYPE; s_array fetch_array; BEGIN OPEN s_cur; LOOP FETCH s_cur BULK COLLECT INTO s_array LIMIT 1000; FORALL i IN 1..s_array.COUNT INSERT INTO servers2 VALUES s_array(i); EXIT WHEN s_cur%NOTFOUND; END LOOP; CLOSE s_cur; COMMIT; END; share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Megastar Username: Twitter Post Number: 24801 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
 ee stmt ki em jaruguddho koddhiga seppei annai open cur1 for select * from table1; cur1 loki table one lo data velludhi ..dhaani na metta basha lo insert annanu alage ippudu cur1 open chesi cur2 loki data ampali adhi na req | ||
Megastar Username: Twitter Post Number: 24800 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
link icchinandhuku sanks kaani GT concept peddha brokka maaya oracle lo .. it writes to the disc ..i want some in memory avideas ..cursors kaakunda inkemanna unte padei | ||
Sachin Legend Username: Sachin Post Number: 33533 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
cursor loki data insert cheyam anai...cursor anedi kind of pointer... oka cursor lo inko cursor open cheskovachu...you can stil reference the upper cursor inside inner cursor... share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Emc2 Hero Username: Emc2 Post Number: 10390 Registered: 03-2008 Posted From: 71.246.229.243 Rating: N/A |
Concept ardham kaledu kani nuvvu emi try chesthunnavo koncham ardham ayindi. Idigo idi chudu emina paniki vasthundi emo http://stackoverflow.com/questions/3462131/create-a-temp-tab le-in-pl-sql cherapakura chedevu. | ||
Megastar Username: Twitter Post Number: 24798 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
oka cursor open chesi For loop lo inko new cursor loki konni rows insert cheyyali. first cursor direct ga open cur1 for select * from table ani open chesesa no issues kaani .. ippudu cur1 open chesi cur2 loki konni add cheyyali ..arthamaindha annai  | ||
Sachin Legend Username: Sachin Post Number: 33530 Registered: 04-2008 Posted From: 68.55.138.131 Rating: N/A |
ardham kaale annai share ki gross ki thedaa theliyakapothenemi...box office disco lo iragadeeyochu...excel, palakol, 292 ki ki ki... | ||
Megastar Username: Twitter Post Number: 24796 Registered: 10-2009 Posted From: 69.118.124.210 Rating: N/A |
oka refcursor A undhi oka 10 columns tho ..using that A i have to create 10 other ref cursors each with different conditions , i want to open cursor A may be using For loop and insert few columns of A into another cursor in that loop . na sp lo rec cursorA%rowtype ani declaring setthe 00320 error osthundhi .. sql server lo chakkaga temp tables etteskoni sukanga cheskunte vadni ..ikkada aa luxury ledhu so cursors is the only way to go ..cheppandi babu ela cheyyalo .. chala googling chesa kaani endhuko samasya jatilanga anipisthundhi |