Answer Posted / varun

select sal from emp where rownum=2 order by sal desc;

Is left join and outer join same?

1052

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1037

---

How to run sql commands in sql*plus?

1173

---

Difference between table function and pipelined function?

1015

---

Why we use stored procedure instead of query?

997

---

What is the use of pl/sql table?

1060

---

What is a rank in sql?

957

---

What is the difference between clustered and non-clustered indexes?

1085

---

How can a function retun more than one value in oracle with proper example?

1072

---

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

1003

---

what is the difference between char_length and length? : Sql dba

1037

---

What is full join in sql?

985

---

What are the various restrictions imposed on view in terms of dml?

961

---

What is sql lookup?

913

---

How many sectors are in a partition?

1074

---