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

differentiate between float and double. : Sql dba

1060

---

What language is oracle sql developer?

1022

---

What is difference sql and mysql?

992

---

How do you optimize a query?

1007

---

Difference between global and parameter variables?

1970

---

what are date and time functions in mysql? : Sql dba

980

---

Do stored procedures prevent sql injection?

971

---

Does access use sql?

1045

---

What are the key differences between SQL and PL SQL?

1217

---

what is the difference between truncate and drop statements? : Sql dba

1127

---

What is meant by user defined function?

1054

---

What is the command used to fetch the first 5 characters of a string?

1210

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1022

---

What are different types of indexes?

1012

---

how to shut down the server with 'mysqladmin'? : Sql dba

1014

---