Answer Posted / krish

select * from(select * from emp order by rowid desc)where
rownum=5;

what is bdb (berkeleydb)? : Sql dba

673

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1727

---

What are its different types of dbms?

624

---

Can we perform dml on view?

645

---

What can you do with pl sql?

659

---

---

what is an alias command? : Sql dba

633

---

How do I order columns in sql?

619

---

how to see the create table statement of an existing table? : Sql dba

621

---

How many sql statements are used? Define them.

676

---

what is bcp? When is it used?

671

---

Which function is used to return remainder in a division operator in sql?

690

---

What is dbo in sql?

618

---

What is dense_rank in sql?

629

---

What is sql comments?

735

---

Is left join same as inner join?

636

---