Answer / neel armstrong

Julian date is the number of days from 01-Jan-4712 BC

Answer / ajay

days since 31 Dec 4713

How many types of sql are there?

0 Answers  

---

How do I partition in sql?

0 Answers  

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

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,

---

---

Where the sql database files are stored?

0 Answers  

---

What is sql basics?

0 Answers  

---

what is a foreign key ? : Sql dba

0 Answers  

---

What happens when a trigger is associated to a view?

0 Answers  

---

how to escape special characters in sql statements? : Sql dba

0 Answers  

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

What is trigger and types?

0 Answers  

---