Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Copying Data from one table into another

    @suresh.ramola
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 465
    Comment on it

    INSERT INTO SELECT statement:

    INSERT INTO SELECT statement is used to copy data from existing table into another table.

    Syntax-1:

    INSERT INTO tablename2 SELECT * FROM tablename1;

    Syntax-2 

    INSERT INTO tablename2 (columnname(s)) SELECT columnname(s) FROM tablename1;

    Example:

    INSERT INTO Employee (Name, City) SELECT StudentName, City FROM School;

    This query will insert studentname and his respective city into Employee table from School table.

    SQL Oracle
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: