Answer / kiran r

SYSDATE;

What is union, minus and interact commands?

1 Answers  

---

What is pl sql script?

1 Answers  

---

how do you know if your mysql server is alive? : Sql dba

1 Answers  

---

How do I save a sql query?

1 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

Which table is left in left join?

1 Answers  

---

Which command is used to call a stored procedure?

1 Answers  

---

how to convert character strings to numeric values? : Sql dba

1 Answers  

---

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

---

What is right join in sql?

1 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---