what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

What are the most important ddl statements in sql?

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

What is trigger in sql?

0 Answers  

---

What is the maximum rows in csv?

0 Answers  

---

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What is using in sql?

0 Answers  

---

What are the commands used in sql?

0 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

What is the mutating table and constraining table?

0 Answers  

---

Where is all the data on the internet stored?

0 Answers  

---