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

6 Answers   CMC, eicc,

---

What is the difference between partition and index?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

What is an ndf file?

0 Answers  

---

Why is %isopen always false for an implicit cursor?

0 Answers  

---

How many types of literals are available in pl sql?

0 Answers  

---

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

---

Define commit?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

How do I create a memory optimized filegroup?

0 Answers  

---