Answer Posted / mallikarjun

select max(sal) from emp
where sal < select max (sal)from emp






Mallikarjun

How to work with data objects interactively?

632

---

How is it different from a normal table?

653

---

Point out the difference between user tables and data dictionary?

619

---

What are triggers in oracle?

659

---

How to call a stored function with parameters?

637

---

---

What is an oracle recycle bin?

636

---

Can we call procedure inside function in oracle?

685

---

Describe varray?

684

---

How to add another datafile to a tablespace?

656

---

What are the roles of dba?

702

---

How to specify default values in insert statement using oracle?

671

---

How to sort the query output in oracle?

707

---

How to resolve name conflicts between variables and columns?

658

---

what is the difference between data migration and production migration.

1904

---

What is a snapshot log?

648

---