Answer Posted / 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

How to create a dynamic cursor with the dynamic option?

1047

---

How to stop log file growing too big?

1014

---

can a database be shrunk with users active? : Sql server administration

1011

---

What is partition in sql server?

1038

---

How do I debug a stored procedure in sql server?

1109

---

What is the syntax to execute the sys.dm_db_missing_index_details?

1028

---

What is nonclustered index on computed columns?

960

---

How to test subquery results with the exists operator?

1107

---

What does this statement do @@rowcount?

971

---

What is sql server used for?

1052

---

Why is sql server log file full?

1039

---

how to determine the service pack currently installed on sql server? : Sql server database administration

971

---

What is a rownum?

978

---

What is a unique index?

934

---

What do you mean by an execution plan? How would you view it?

914

---