If I've got a table like:

CREATE TABLE FRED
(
recordId number(18) primary key,
firstName varchar2(50)
);

Can there be a good way to clone it's structure (not it's data) into another table of the given title. Essentially I wish to create table with the identical structure, but another title, to ensure that I'm able to carry out some functionality onto it. I do in code clearly. Java ideally, but many other languages ought to be similar.

If you are searching a method to discover the exact DDL to recreate the table, such as the storage clause, you should use

select dbms_metadata.get_ddl('TABLE', 'TABLE_NAME', 'SCHEMA_NAME') from dual

as referred to here.

CREATE TABLE tablename AS Choose * FROM orginaltable WHERE 1=2

Edit: The WHERE clause forbids any rows from being approved.