Answer / Rajnish Kumar Srivatsav

When comparing values with NULL in SQL, the following rules apply:n
1. NULL is neither greater than nor less than any other value.
2. NULL equals NULL only.
3. All other values are neither equal nor unequal to NULL.

Does inner join remove duplicates?

1 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

What are all ddl commands?

1 Answers  

---

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

What is the maximum number of rows in sql table?

1 Answers  

---

What is %s in sql?

1 Answers  

---

what are the different functions in sorting an array? : Sql dba

1 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

What are the different operators available in sql?

1 Answers  

---

Does sql backup shrink transaction log?

1 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

1 Answers   INDUS,

---

Types of optimization?

6 Answers   Microsoft,

---