When we insert new values into the table using loops. Is it going to be auto commit or do we need to commit manually?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Mar 19th, 2009

All the DML statement requires manual commit where as DDL statements are autocommitted.

Answer Question  Select Best Answer

How will you stop an infinite loop without closing the program?

muraligrandhi

 Profile Answers by muraligrandhi Questions by muraligrandhi

• Jun 7th, 2010

For terminating the INFINITE LOOP we can use EXIT statement.Example: LOOP     monthly_sales:=daily_sales*31;     EXIT when monthly_sales > 3000; END LOOP;  

joe0082

 Profile Answers by joe0082 Questions by joe0082

• Apr 13th, 2009

Use the EXIT statementThis will stop the looping and proceed to the next executable statement.or EXIT WHEN condition

Answer Question  Select Best Answer