tommy Posted July 25, 2013 Report Posted July 25, 2013 Bhayya evaraina detroit lo oracle developer unara who can give support...
Ka NTR i Posted July 25, 2013 Report Posted July 25, 2013 Support ante kastam gaani bhayya... help chetamante chetsthhaaa... m not frm detroit though
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 [quote name='Googlite' timestamp='1374715576' post='1304007084'] Support ante kastam gaani bhayya... help chetamante chetsthhaaa... m not frm detroit though [/quote] procedure rayali which i dont know...anduke support anna....
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 [quote name='Googlite' timestamp='1374715576' post='1304007084'] Support ante kastam gaani bhayya... help chetamante chetsthhaaa... m not frm detroit though [/quote] nenu oka table create chesa oracle database lo using toad wizard....ippude procedure rayali.....so table data kosam koncham query raasanu and danini table loki ekinchi aa table use chestha migatha procedure rayali....how to insert script...
faf Posted July 25, 2013 Report Posted July 25, 2013 [quote name='tommy' timestamp='1374716023' post='1304007103'] nenu oka table create chesa oracle database lo using toad wizard....ippude procedure rayali.....so table data kosam koncham query raasanu and danini table loki ekinchi aa table use chestha migatha procedure rayali....how to insert script... [/quote] ardam kaale,,, neeku table lo ki data insert cheyyadaaniki script kavala?? or aa table ni use chesi nuvvu rayaboye procedure ki code kavala?? procedure ki ayithe nee requirement emiti??
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 [quote name='faf' timestamp='1374717168' post='1304007138'] ardam kaale,,, neeku table lo ki data insert cheyyadaaniki script kavala?? or aa table ni use chesi nuvvu rayaboye procedure ki code kavala?? procedure ki ayithe nee requirement emiti?? [/quote] actual gamatter enti ante naaku requirement icchi procedure rayamanaru....nenu oka 10 feilds ki sql query ala ela help teesukoni raasanu inka 30 feilds unayi...so first toad lo aa 40 cloumns ki table create chesanu using toad create table wizard.....next 30 cloumns ki query rayali ante first nenu raasina query ni aa kaali table ki ekinchi aa table use cheyali... [size=5][color=#282828][font=helvetica, arial, sans-serif] want to make this SQL as stored procedure[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and then create remaining ones[/font][/color][/size]
ramu Posted July 25, 2013 Report Posted July 25, 2013 [quote name='tommy' timestamp='1374717993' post='1304007169'] actual gamatter enti ante naaku requirement icchi procedure rayamanaru....[size=5][color=#ff0000]nenu oka 10 feilds ki sql query ala ela help teesukoni raasanu[/color][/size] inka 30 feilds unayi...so first toad lo aa 40 cloumns ki table create chesanu using toad create table wizard.....next 30 cloumns ki query rayali ante first nenu raasina query ni aa kaali table ki ekinchi aa table use cheyali... [size=5][color=#282828][font=helvetica, arial, sans-serif]want to make this SQL as stored procedure[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and then create remaining ones[/font][/color][/size] [/quote] [color=#ff0000]fields ki sql query rayadam enti tommy... [/color] [color=#ff0000]You created one table with 40 columns, Do you need procedure to load data to that table ?[/color] [color=#ff0000]What is task that ur procedure has to accomplish??[/color]
Ka NTR i Posted July 25, 2013 Report Posted July 25, 2013 number of columns marichipo... chinna... requirement cheppu. Oka table lo data insert script rayalaa? source table(tables) ekkada vundho information vunadhaa? asalu table endhuku create chesaav? already table ledhaa? clarity ga cheppu
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 yaa procedure kavali...so that i can populate the table i created with data...
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 [quote name='Googlite' timestamp='1374719899' post='1304007201'] number of columns marichipo... chinna... requirement cheppu. Oka table lo data insert script rayalaa? source table(tables) ekkada vundho information vunadhaa? asalu table endhuku create chesaav? already table ledhaa? clarity ga cheppu [/quote] yaa source tables NTLRESULTS ANE SCHEMA LO UNAYI TABLE LEDU NENU KOTHA TABLE CREATE CHESA AND DANIKI PROCEDURE RAYALI...
ramu Posted July 25, 2013 Report Posted July 25, 2013 [quote name='tommy' timestamp='1374719924' post='1304007204'] yaa procedure kavali...so that i can populate the table i created with data... [/quote] ok .. Nuvvu load cheyyali anukune data ekkada.. i mean ee format lo available vundhi.... in other tables? external file? or any other?
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 [quote name='RockStarZ' timestamp='1374720131' post='1304007209'] ok .. Nuvvu load cheyyali anukune data ekkada.. i mean ee format lo available vundhi.... in other tables? external file? or any other? [/quote] nenu data ni pull cheyali from other tables and danitharuvatha some from my own table........
tommy Posted July 25, 2013 Author Report Posted July 25, 2013 BRD undhi mail id isthe pamputha so that i can explain..
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts