date- 23 feb

Página 1

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_val

LOOP

<statement>

End Loop;

here we dont increment the "var_name" in the loop unlikely of while loop

delete from sales where ORDER_ID=p_ORDER_ID;

Página 2

master table

create table master_sheet(id number not null,

item_name varchar2(50),

Unit_price number,

quantity number,

total_amount number,

primary key(id));