Answer Posted / gourav

select * from employees
where employee_id=100
union
select* from employees
where employee_id=206;


Example

first coulumn_ id(100)
last column _id(206)

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1208

---

What is the difference between local and global temporary table?

1025

---

What is a column in a table?

1106

---

How many aggregate functions are available there in sql?

968

---

What will you get by the cursor attribute sql%notfound?

1040

---

What is auto increment in sql?

1098

---

What is file based approach?

924

---

Mention what does plv msg allows you to do?

1096

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1051

---

What are the types of index in sql?

1050

---

How to use sql*plus built-in timers?

1170

---

what is a foreign key ? : Sql dba

1065

---

What is pl sql record in oracle?

1011

---

what are all types of user defined functions? : Sql dba

1029

---

What are all ddl commands?

1065

---