Answer Posted / senthil

select max(sal) from emp where sal <(select max(sal) from emp)

How to select 10 records from a table?

1157

---

Does sql view stored data?

960

---

Explain the savepoint statement.

1099

---

What is a system versioned table?

987

---

What is dense_rank in sql?

986

---

What is dense_rank?

935

---

Can we use ddl statements in stored procedure?

1154

---

What does the acronym acid stand for in database management?

1032

---

Explain the uses of database trigger.

1115

---

What is loop in pl sql?

1039

---

Can you have more than one trigger on a table?

1003

---

what is a constraint? Tell me about its various levels. : Sql dba

988

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

972

---

How do temporal tables work?

961

---

Why is sql*loader direct path so fast?

1104

---