Home > IT Answers > Microsoft Windows > Copy Table in SQLPLUS
VB and Access
5 pts.
 Copy Table in SQLPLUS
Access, Access Database, SQL tables, SQLPlus
How to copy a table from an access database using sqlplus

Software/Hardware used:
ASKED: November 6, 2010  2:18 AM
UPDATED: November 8, 2010  2:57 PM
RELATED QUESTIONS
Answer Wiki:
U may try out the below : 1. Open the SQL view window. 2. Type SELECT * and press Enter. This statement will select all the columns from the table you want to copy 3. Type INTO and the name you want to give the new table. NOTE : For eg, INTO NewTable. This statement will make sure that the copied columns are placed into the new table. 4. Now Press Enter 5. Type FROM & the name of the table you want to copy. NOTE: For eg., FROM anytable (Old one) Now run the query !
Last Wiki Answer Submitted:  November 8, 2010  4:35 am  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi “VB and Access”, Rechil provided a good answer on how to copy an Access table into another Access table, is that what you need ?

Since you mentioned “sqlplus”, one could think that an Oracle database is involved.

If the answer provided doesn’t help, please provide more details.

carlosdl
 63,535 pts.