date- 23 feb

pl-sql Update statement UPDATE table-Name [[AS] correlation-Name] SET column-Name = Value [ , column-Name = Value} ]* [WHERE clause] |here "=" is used instead of " := " in PL_SQL and SQL both In FOR LOOP ,for var_name in lower_val .. high_valLOOP<statement>End Loop;here we dont increment the "var_name" in the loop unlikely of while loopdelete from sales where ORDER_ID=p_ORDER_ID;

master tablecreate table master_sheet(id number not null,item_name varchar2(50),Unit_price number,quantity number,total_amount number,primary key(id));