DEVFYI - Developer Resource - FYI

The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records.

PL/SQL Interview Questions and Answers


(Continued from previous question...)

The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records.

SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source
SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source WHERE column_name operator value

(Continued on next question...)

Other Interview Questions