Answer Posted / prem

SQL> select salary from(select salary,rownum a from(select salary from employee order by salary desc))where a=2;

What is analyze command used for?

1078

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2181

---

How data locks are respected in oracle?

1072

---

How many types of database triggers exist?

1136

---

Will you be able to store pictures in the database?explain.

995

---

What is max rowid in oracle?

1025

---

How to drop a tablespace?

1048

---

How many categories of data types?

997

---

Can group functions be mixed with non-group selection fields?

1021

---

How to load data from external tables to regular tables?

1062

---

How to convert raw data type into text in oracle? Explain

993

---

How to resolve name conflicts between variables and columns?

1031

---

Is oracle an operator?

929

---

What is a cursor in oracle?

1177

---

Is insert autocommit in oracle?

1070

---