Help::: Kwalling Oracle Knowledgerzz (Creating Sp)

[mtkr]

oracle lo stored procedure create cheyyadaniki basic steps enti???.
like sp for select * from mytable
Measures em em teesukovali???



note:: already google lo ethika ardam kaake ikkadiki ochina...

Help

[pavan_613]

[Chandrabhai5]

Select ki stored proc enduku vay


[img]http://www.andhrafriends.com/uploads/profile/photo-thumb-33993.jpg?_r=1353114808[/img][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-33993.jpg?_r=1353114808[/img]

[pavan_613]

http://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html

[peru_edaite_enti]

asal procedure enduku bey create chesukotam... mundala adi ccheppu

[mtkr]

[quote name='Chandrabhai5' timestamp='1354844321' post='1302909218']
Select ki stored proc enduku vay


[img]http://www.andhrafriends.com/uploads/profile/photo-thumb-33993.jpg?_r=1353114808[/img][img]http://www.andhrafriends.com/uploads/profile/photo-thumb-33993.jpg?_r=1353114808[/img]
[/quote]
nuv roju roju ki chinna poranivi aithunnav BHAI....

ex ga adigina daaniki aithe em raastham anii....


T-sqlla aithe


create procedure proc1
begin
select * from mytbl
end

atlaage plsql la etla rastam aniii...

[mtkr]

[quote name='CITI' timestamp='1354844331' post='1302909219']
[url="http://docs.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html"]http://docs.oracle.c...procedures.html[/url]
[/quote]
thnx cheetiii..... wil look it

[mtkr]

[quote name='CBZ' timestamp='1354844565' post='1302909236']
asal procedure enduku bey create chesukotam... mundala adi ccheppu
[/quote]

ne kotha mamaaa.... ssrs report kosam....
estraight ga cheppali ante t-sql code ni pl-sql ki change cheyyaliii.....

aaa code oka sp so danni plsql la create cheyyaliiii....

[peru_edaite_enti]

[quote name='mtkr' timestamp='1354848712' post='1302909422']
ne kotha mamaaa.... ssrs report kosam....
estraight ga cheppali ante t-sql code ni pl-sql ki change cheyyaliii.....

aaa code oka sp so danni plsql la create cheyyaliiii....
[/quote]

ne t-sql code mail cheyu, chusta dannni pl/sql ki change cheydaniki.. aina, room lo aa Aj pl/sql meeda ditta, vanni odilesi eeda adugutunnav endi?

[mtkr]

[quote name='CBZ' timestamp='1354848897' post='1302909433']
ne t-sql code mail cheyu, chusta dannni pl/sql ki change cheydaniki.. aina, room lo aa Aj pl/sql meeda ditta, vanni odilesi eeda adugutunnav endi?
[/quote]


ippude vndr prty ki poyi ochinammm..... eeekk end kursobedthaaa..

[peru_edaite_enti]

[quote name='mtkr' timestamp='1354849843' post='1302909491']


ippude vndr prty ki poyi ochinammm..... eeekk end kursobedthaaa..
[/quote]

aa pani cheyyi