Question

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.

Answer 1

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.