Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get a CREATE Statement for an Existing Table
How To Get a CREATE Statement for an Existing Table? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
You have an existing table and want to get a CREATE statement for that table, you can use the SQL tab in the object view. The following tutorial steps show you how to use SQL Developer to generate a CREATE statement on an existing table:
In a moment, you will get the following CREATE statements:
REM HR JOBS CREATE TABLE "HR"."JOBS" ( "ID" VARCHAR2(10 BYTE), "TITLE" VARCHAR2(35 BYTE) CONSTRAINT "TITLE_NN" NOT NULL ENABLE, "MIN_SALARY" NUMBER(6,0), "MAX_SALARY" NUMBER(6,0), CONSTRAINT "ID_PK" PRIMARY KEY ("ID") ENABLE ) ; REM HR ID_PK CREATE UNIQUE INDEX "HR"."ID_PK" ON "HR"."JOBS" ("ID") ;
2007-04-27, 4849👍, 0💬
Popular Posts:
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...
What does AddressOf operator do in background ? The AddressOf operator creates a delegate object to ...
How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...
Can you explain the fundamentals of “GetGlobalResourceObject ”and “GetLocalResourceObject” function...
How To Truncate an Array? - PHP Script Tips - PHP Built-in Functions for Arrays If you want to remov...