Answer / Bhupender Prajapati

There are four main types of joins in SQL: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. An INNER JOIN returns only the common rows between two tables; a LEFT OUTER JOIN displays all rows from the left table and matching rows from the right table; a RIGHT OUTER JOIN shows all rows from the right table and matching rows from the left table; a FULL OUTER JOIN displays all rows when there is a match in either the left or right table.

What are the uses of sysdate and user keywords?

1 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

What is clustered and nonclustered index in sql?

1 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Which is the correct statement about truncate and delete?

1 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

What are % type and % rowtype?

1 Answers  

---

What is pl sql package?

1 Answers  

---

Can there be 2 primary keys in a table?

1 Answers  

---

What is count * in sql?

1 Answers  

---

How to rename a column in the output of sql query?

1 Answers  

---

What do you understand by pl/sql cursors?

1 Answers  

---