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, 5365👍, 0💬

Popular Posts:

Can event’s have acc...

Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...

How do you handle ch...

How do you handle change request? Normally change request are handled by preparing an Impact analysi...

What Is URI...

What Is URI? URI (Uniform Resource Identifier) is a superset of URL. URI provides a simple and exten...

What is wrong with t...

What's wrong with this initialization? char *p = malloc(10); My compiler is complaining about an ``i...

What Are Named Param...

What Are Named Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Name...