Answer / mathan r

It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn
object_value
level
user

List the different index configurations possible for a table?

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

---

What is a self join in sql server?

0 Answers  

---

Explain about system database?

0 Answers  

---

Explain some DBCC commands?

6 Answers  

---

Is sql server a database?

0 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

Why should we go for stored procedures? Why not direct queries?

0 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

What is an execution plan? When would you use it?

0 Answers  

---