What is sql and its types?

0 Answers  

---

Which operator is used in query for pattern matching?

0 Answers  

---

What are indexes, and what are the different types?

3 Answers  

---

What are user defined stored procedures ?

3 Answers   BirlaSoft,

---

How can we schedule the procedure to run automatically ?

3 Answers  

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---

what is Complex index. how to create it?

2 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---