Interested to Buy Any Domain ? << Click Here >> for more details...
what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 16419 Views
- CMC, eicc, I also Faced
- E-Mail Answers
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 does plv msg allows you to do?
What is a unique key and primary key and foreign key?
Explain raise_application_error.
What is a join?
What are the advantages of sql? Explain
How would you reference column values before and after you have inserted and deleted triggers?
What is the order of sql select?
what are rollup and cube in t-sql? : Transact sql
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is pl sql code?
What are the different types of functions in sql?
What is program debugging?
Name three sql operations that perform a sort.
Inline the values in PL/SQL, what does it mean.?
How can we implement rollback or commit statement in a trigger?
