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
Why are aggregate functions called so?
What is a left join?
What is join view in sql?
Explain lock escalation? : Transact sql
How do I remove duplicates in two columns?
what is self-join? : Sql dba
Is vs as in pl sql?
What is the need of a partition key?
Explain the difference in execution of triggers and stored procedures?
Can sql developer connect to db2?
Why do we use joins?
Can you skip header records while loading? : aql loader
What is oracle sql developer?
Which is faster union or join?
What is sp_helptext?