Define the select into statement.



Define the select into statement...

Answer / Ankur Dixit

The SELECT INTO statement in SQL is used to create a new table and insert data from the result set of a SELECT query.nnExample:nSELECT column1, column2 FROM table_name INTO new_table;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

define join and explain different type of joins? : Sql dba

1 Answers  


Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  


how to decrement dates by 1 in mysql? : Sql dba

1 Answers  


What is the usage of distinct keyword?

1 Answers  


Can we rollback after truncate?

1 Answers  


What is sql*loader and what is it used for?

1 Answers  


What are sql indexes?

1 Answers  


What is the difference between having and a where in sql?

1 Answers  


What is a constraint?

1 Answers  


What is indexes?

1 Answers  


how can i read files from a pl/sq l program

3 Answers  


Explain the steps needed to create the scheduled job?

1 Answers  


Categories