what is the different between now() and current_date()? : Sql dba

0 Answers  

---

What are the different operators available in sql?

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

---

What is primary and foreign key?

0 Answers  

---

What is the difference between row level and statement level trigger?

0 Answers  

---

What are the main features of cursor?

0 Answers  

---

What do you understand by pl/sql records?

0 Answers  

---

What will you get by the cursor attribute sql%found?

0 Answers  

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

How do I find duplicates in a single column in sql?

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,

---