what command is used to create a table by copying the
structure of another table including constraints ?
Answer Posted / selvaraj v , anna univ coe
To Use same database :
======================
CREATE TABLE NEW_TBLNAME AS SELECT * FROM OLD_TBLNAME WHERE
1=2;
EXAMPLE :
---------
CREATE Emp_tbl2 AS SELECT * FROM Employee_Tbl1 WHERE 1=2;
Table creation From One USER To Another USER :
======================================================
COPY FROM coeot1a2/coeot1a2@coeau TO scott/tiger@server1
CREATE s11 USING SELECT * FROM major_List;
coeot1a2 ----> USER NAME
coeot1a2 ----> PASSWORD
coeau -------> SERVER NAME
scott -------> Another USER NAME
tiger -------> Another User PASSWORD
server1 -----> Another SERVER NAME
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is normalization? How many normalization forms are there?
How do you write an inner join query?
What is sql lookup?
How do I run sql profiler?
How does sql store data?
Is a view faster than a stored procedure?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What type of join is sql join?
how to select first 5 records from a table? : Sql dba
Why do we use view in sql?
Why do you partition data?
What is a function in oracle pl sql?
What is the difference between instead of trigger and after trigger?
What is dba in sql? : SQL DBA
What is trigger and types?