can we create a table in oracle without using create statement?

Question

0.00/5 (No votes)

See more:

i faced this que in an interview

Posted 8-Feb-14 21:55pm

Comments

Kornfeld Eliyahu Peter 9-Feb-14 4:25am

And your answer was?

1 solution

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2014-02-09T00:59:00

In standard SQL there is no way to use a table without creating it. There is a shortcut to create table based on a select statement.

SQL

CREATE TABLE new_tbl SELECT * FROM old_tbl

However this also based on the CREATE TABLE command...

There is also an extension to do it without CREATE TABLE (originally from SyBase)

SQL

INSERT INTO new_tbl SELECT * FROM old_tbl

This is fit into the category in the question, and fortunately it's supported by Oracle's PL/SQL!!!

So the answer is yes...