Answer Posted / murali

select level,max(sal) from emp where level=&levelno connect by prior sal>sal group by level;

What is difference between left and right outer join?

983

---

what tools available for managing mysql server? : Sql dba

1078

---

What is the maximum size of sqlite database?

1103

---

How is debugging done?

972

---

What is PL/SQL Records?

1185

---

what are the security recommendations while using mysql? : Sql dba

1114

---

How many types of primary keys are there?

1036

---

Does sql support programming?

1064

---

What is union?

1163

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1636

---

What is an example of translating a date into julian format?

1116

---

What is the difference between delete, truncate and drop command?

1149

---

What is normalization in a database?

1152

---

Is full outer join same as cross join?

968

---

How many commands are there in sql?

1026

---