boring Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361864#msg2361864 date=1305617090]got it so we need not repeat the entire command... we can just give the procedure name... tats it ryt[/quote]yes, for now. once you understand more internals of SQLs, it can have loops/ifs etc in stored procs.
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=Jambhalheart link=topic=193762.msg2361869#msg2361869 date=1305617277]actually edi oka subquery mama, in sql server..here we used, alias names, table names ...edi enduke cheppanu ante, neeku koncham idea vasthundi sub queries medha...[/quote]alias idea vundi baa... as am new to it. .wil try catching it up soon.. thankyou for all ur help CITI_$D# and boring thankyou
Jambhalheart Posted May 17, 2011 Report Posted May 17, 2011 @boring,,,do we have rowid automatically for every table in oracle ????
boring Posted May 17, 2011 Report Posted May 17, 2011 [quote author=Jambhalheart link=topic=193762.msg2361876#msg2361876 date=1305617632]@boring,,,do we have rowid automatically for every table in oracle ???? [/quote]ya its part of table metadata and can be queried. for ex. select rowid, ename from emp
boring Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361872#msg2361872 date=1305617420]alias idea vundi baa... as am new to it. .wil try catching it up soon.. thankyou for all ur help CITI_$D# and boring thankyou[/quote]alias ante maaru peru antheee. table ki maaru peru ivvadam aa query loo.
Jambhalheart Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361872#msg2361872 date=1305617420]alias idea vundi baa... as am new to it. .wil try catching it up soon.. thankyou for all ur help CITI_$D# and boring thankyou[/quote]no worries bro... keep practicising ... if u practise well, u can master sql + plsql with deadlocks and shit within 2 weeks.... sure.
Jack Sparrow Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361872#msg2361872 date=1305617420]alias idea vundi baa... as am new to it. .wil try catching it up soon.. thankyou for all ur help CITI_$D# and boring thankyou[/quote]deni meeda try sethunav job sCo_^Y sCo_^Y
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 thankyou thankyou[quote author=Jambhalheart link=topic=193762.msg2361892#msg2361892 date=1305618290]no worries bro... keep practicising ... if u practise well, u can master sql + plsql with deadlocks and shit within 2 weeks.... sure.[/quote]yep 2 weeks lo i wanna be good with this shitQL @3$% @3$%[quote author=Jack Sparrow link=topic=193762.msg2361893#msg2361893 date=1305618355]deni meeda try sethunav job sCo_^Y sCo_^Y[/quote]theddu motham sadivi deni meeda antaavu endi ^G#W
Jack Sparrow Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361895#msg2361895 date=1305618697] thankyou thankyouyep 2 weeks lo i wanna be good with this shitQL @3$% @3$%theddu motham sadivi deni meeda antaavu endi ^G#W[/quote]sql developer aaa @3$% @3$% @3$% ante koni tools ki sql knowledge undali kada andukani doubt vachindi... s%H# s%H#gud luck mama J@#D J@#D H&*() H&*()
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 thankyou thankyou[quote author=Jack Sparrow link=topic=193762.msg2361897#msg2361897 date=1305618833]sql developer aaa @3$% @3$% @3$% ante koni tools ki sql knowledge undali kada andukani doubt vachindi... s%H# s%H#gud luck mama J@#D J@#D H&*() H&*()[/quote]nuvu working oo kaadoo telavadu F@!n assalu us e na sSa_j@il
Jack Sparrow Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361900#msg2361900 date=1305618963] thankyou thankyounuvu working oo kaadoo telavadu F@!n assalu us e na sSa_j@il[/quote]monne job vachindi ani thrd vesthe thankyou kuda cheppinav *7*^ *7*^iffudu chicago lo unna, next week joinin J@#D J@#D
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=Jack Sparrow link=topic=193762.msg2361903#msg2361903 date=1305619094]monne job vachindi ani thrd vesthe thankyou kuda cheppinav *7*^ *7*^iffudu chicago lo unna, next week joinin J@#D J@#D[/quote] F@!n F@!n nuvu id lu maristhe emi sethaa seffu @3$% F@!naa tech meeda vachindi ba ~"!
Jack Sparrow Posted May 17, 2011 Report Posted May 17, 2011 [quote author=KINDAL link=topic=193762.msg2361905#msg2361905 date=1305619188] F@!n F@!n nuvu id lu maristhe emi sethaa seffu @3$% F@!naa tech meeda vachindi ba ~"![/quote] @3$% @3$% @3$% SAP Business Objects F%G_@ F%G_@
chowdary10 Posted May 17, 2011 Author Report Posted May 17, 2011 [quote author=Jack Sparrow link=topic=193762.msg2361907#msg2361907 date=1305619229] @3$% @3$% @3$% SAP Business Objects F%G_@ F%G_@[/quote]nenu sap hr lo vundalisina vadini @3$% @3$%india poye baddakam esi edi nerchukookunda vachaa baa cry@fl cry@fl
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts