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!

Insert the values to the table by using select statement

Discussion in 'SQL PL/SQL' started by Puru, Oct 27, 2010.

  1. Puru

    Puru Forum Advisor

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Dear All,

    I have a table called EMPDEPT, it has 3 coloumns EMPNO, ENAME and SAL. How to insert values from EMP or both EMP and DEPT in a single shot.

    How to achive above query in both SQL and PLSQL
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Try with INSERT INTO .... SELECT ... FROM clause. find the link for more details.

    Insert Statement