Answer Posted / chandu

select ename,sal from emp where sal=(select max(sal) from emp);

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1026

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2150

---

how to check server status with 'mysqladmin'? : Sql dba

1053

---

Is it possible to update views?

946

---

What is the file extension for sql database?

982

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

960

---

What is output spooling in sql*plus?

1020

---

What is sql and its types?

1156

---

What is scalar function in sql?

1020

---

Why is pl sql needed?

919

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

923

---

What is the reports view in oracle sql developer?

957

---

What are records give examples?

990

---

Do stored procedures prevent sql injection?

953

---

Can we use rowid as primary key?

965

---