what is the difference between join and union? : Sql dba

0 Answers  

---

Difference between truncate, delete and drop commands?

0 Answers  

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

what is sub-query? : Transact sql

0 Answers  

---

How can a pl sql block be executed?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

What is difference between joins and union?

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---

How many types of primary keys are there?

0 Answers  

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---