Total Pageviews

March 23, 2015

3/23/2015 09:06:00 PM



  • Click for Questions



  • 1)You must retrieve worker details from the work table and process them in a PL/SQL block.  Which variable type must be created in the PL/SQL block to retrieve all rows and columns using a single SELECT statement from the work table?
    ans)PL/SQL table of records.
    2)GROUP BY dept_no
    3)a SELECT divisionno, AVG(sal)
    FROM work
    WHERE divisionno IN(3,6)
    GROUP BY divisionno
    HAVING AVG (sal)>=3100;

    4)d.HAVING COUNT (*)>10
    5)Select inventory, NVL(TO=CHAR(shipdate) “Not
    NVL (To char(total), ‘not available’)Shipped”)
        FROM order.
    6)d Select last name, first name.
    FROM work
    WHERE LOWER(lastname)=(‘smith’);
    7)a.SELECT custid, orderdate, shipdate,
            ROUND(MONTHS-BETWEEN(shipdate,orderdate))
            “Time Taken”
        FROM ord;
    8)a.    The first name values in the database are in lower case.
    9)c.    An index is created for the purchase_no column.
    10)b.    Use the ALTER TABLE command with the ADD clause on the EMP table.


     
    Related Posts Plugin for WordPress, Blogger...