When to Use SELECT INTO Statements

When to Use SELECT INTO Statements?

✍: fyicenter.com

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

2007-04-15, 5221👍, 0💬

Popular Posts:

Can one execute dyna...

Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL databas...

System.setOut() - Se...

How could Java classes direct program messages to the system console, but error messages, say to a f...

What Is a TD Tag/Ele...

What Is a TD Tag/Element? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells A "td" elemen...

How can JavaScript m...

How can JavaScript make a Web site easier to use? That is, are there certain JavaScript techniques t...

If XML does not have...

If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...