Answer Posted / guest

select max(sal) from tab_name;
or
select * from tab_name where sal=(select max(sal) from
tab_name) and rownum<=1;

Explain the purpose of %type and %rowtype data types?

873

---

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

1073

---

What is partition by in sql?

1000

---

How is a process of pl/sql compiled?

1080

---

How to make a copy values from one column to another in sql?

978

---

What are operators available in sql?

977

---

What is sql query optimization?

1018

---

How to read/write files from pl/sql?

990

---

What is a dirty read sql?

1027

---

What is secondary key?

880

---

How many row comparison operators are used while working with a subquery?

972

---

List out the acid properties and explain?

902

---

How do I add a primary key to a table?

969

---

What is materialized view. What are different methods of refresh?

1327

---

How do I view a view in sql?

887

---