FOR LOOP in PLSQL | Oracle PLSQL tutorial in TAMIL

[@ajith.k5517]

Plsql la total aa 26 video tha irruku. please continue to we learn more about plsql

[@krishnanselvam786]

thank you so so so so so much .......................sama all videos are very clear expaination.

[@learncodetodaytamil]

Thank u.

[@cricket07only41]

Thank you sir

[@veeramani6029]

Bro next video podunga bro
Cursors
Functions
Triggers
Procedures

[@learncodetodaytamil]

Working on these... Will upload soon.

[@ajith.k5517]

Sir video continue pannunga please 🙏🏼

[@SachusCollections]

Hi Sir, When i expect the videos of Cursors, Triggers, Oracle performance tuning, Dynamic SQL, Bulk Data Processing etc.

[@learncodetodaytamil]

Cursors will be uploaded by next week... Then will start packages, triggers etc... Stay tuned..

[@SachusCollections]

@@learncodetodaytamil Sounds good Thank you !

[@krishnanselvam786]

bro GTT table video post podunga bro indetail ah please post video GTT.

[@yogalakshmi9882]

Hi, what if we want to increment the for loop variable by 2, how should we give that?

[@learncodetodaytamil]

Use mod function...
Ex:
begin
for i in 1 .. 100
loop
if mod (i, 2) = 0
then
dbms_output.put_line (i);
else
null;
end if;
end loop;
end;
/

[@yogalakshmi9882]

@@learncodetodaytamil thanks!!

[@yogalakshmi9882]

Hii sir, You videos are really useful. Thank you. Also, can u tell what are the questions they may ask in pl/SQL developer interview please?

[@learncodetodaytamil]

Thanks!. Every topic is important.... Focus on cursors, exceptions, pragma autonomous transactions, functions, control statement, triggers ....

[@yogalakshmi9882]

@@learncodetodaytamil Thank you sir!!

[@aneeshk4018]

hi... suppose i dont know the employee id (i.e 100 to 105). but i need to fetch the names from 100 to 125 approx..how to fetch the names using for loop..????

[@aneeshk4018]

can i fetch the records???

[@learncodetodaytamil]

In normal for loop we cannot achieve this. But using for loop cursor we can. In cursor we can mention the select statement directly.

[@aneeshk4018]

Ok...than k u ...