Answer Posted / pradeep kolakala

Select max(sal) from ithpharma.UserRole where version
not in (select max(sal) from ithpharma.UserRole)

How many anonymous blocks can be defined?

1182

---

Explain the different normalization forms?

1084

---

How remove data files before opening a database?

1066

---

What happens to the data files if a tablespace is dropped?

1059

---

What is the difference between postgresql and oracle?

1044

---

Please explain joins in oracle?

1059

---

What are the benefits of ordbms?

1083

---

Is it possible to split the print reviewer into more than one region ?

2280

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2016

---

Explain the blob datatype?

1071

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2256

---

What are internal user account in oracle?

1004

---

How to create a table index?

1143

---

What is SQL access advisor in Oracle?

1185

---

What are ddl statements in oracle?

1075

---