Posts

Assignment in SQL for Using trigger

Assignment:-                Assign. Name:-Using Trigger CLASS:-T.Y.B.Sc(Computer)           ************************************************************* Triggers:-  SQL> select * from purchase  PO_NO   PO_DATE     ITEM_NO    QTY  --------  ---------            ----------    ---------  11          12-MAY-03      101        100  12          17-JUN-03       102        75  13          21-APR-03       103        150  14          14-JAN-04  ...

Assignment in SQL for use of set operator

Assignment:-                Assign. Name:- In SQL Use of SET Operator. CLASS:-T.Y.B.Sc(Computer)           ************************************************************* Use of SET Operator: - UNION - INTERSECT - IN - NOT IN SQL>select * from borrower;  CUST_NAME                 LOAN_NO ---------------------    ------------- Samir                            1 Mahesh                         2 Smita                            3 Vrushali           ...