1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

what is inline views in oracle?

Discussion in 'SQL PL/SQL' started by saravana572, Nov 17, 2012.

  1. saravana572

    saravana572 Guest

    any one tell what is inline view and examples?
     
  2. dariyoosh

    dariyoosh Forum Advisor

    Messages:
    118
    Likes Received:
    19
    Trophy Points:
    260
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Saravana,

    When you use SQL Subquery in From clause of the select statement it is called INLINE view.

    Example: -
    Code (Text):

    SELECT *
      FROM EMP E,
               (SELECT DEPTNO FROM DEPT)D
      WHERE E.DEPTNO = D.DEPTNO;