Copy Table Fields in PL/SQL: Quick Guide

In PL/SQL, you can use the CREATE TABLE AS SELECT statement to copy all fields of a table. Here is an example:

CREATE TABLE new_table AS
SELECT * FROM old_table;

The statement above copies all data and structure of a table named old_table, and creates a new table called new_table. The new table will contain all the same fields and data as the old table.

It is important to note that when using the CREATE TABLE AS SELECT statement to copy a table, the new table will have the same fields as the old table, including field names, data types, and constraints.