Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How do I do a Select Into

How do I do a Select Into

From: Shawn Francis <shawn.francis_at_kp.org>
Date: 1997/04/16
Message-ID: <01bc4aa7$9c79c0b0$7cf010ac@sfrancisnt>#1/1

Very simple question. How do select data out of one table and put the results into another table.

Example:

Select MedicalRecordNumber, count(*) into newTableName From existingTableName

According to the manuals I have I can only do this into variables. Is this true? Received on Wed Apr 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US