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

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

Explain difference between control flow and data flow?

0 Answers  

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

what type of indexes physically sort data?

3 Answers  

---

Explain the properties of subqueries in sql server?

0 Answers  

---

What is tempdb database? : SQL Server Architecture

0 Answers  

---

When cursors are useful?

0 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---