Simple script to backup all SQL server database
Create a database table with the following fields:
Field name Data type
Ship_id Number -- This is the ID of a particular Ship
Date_expected Date --The date at which the goods are expected
to arrive
Qty_expected Number --The quantity that is supposed to arrive
Description Varchar2 --The description of the items
Color Varchar2 --The color of the items
Qty_hand Number –The quantity on hand for these items
Itemrate Number—Price of each item.
Write a PL/SQL program that uses implicit cursor to display the data expected,
quantity expected, item description, color and quantity on hand for any
particular Ship ID number.
Answers
Answered by
0
Answer:
Simple script to backup all SQL server database
Create a database table with the following fields:
Field name Data type
Ship_id Number -- This is the ID of a particular Ship
Date_expected Date --The date at which the goods are expected
to arrive
Qty_expected Number --The quantity that is supposed to arrive
Description Varchar2 --The description of the items
Color Varchar2 --The color of the items
Qty_hand Number –The quantity on hand for these items
Itemrate Number—Price of each item.
Write a PL/SQL program that uses implicit cursor to display the data expected,
quantity expected, item description, color and quantity on hand for any
particular Ship ID number.
Similar questions