Answer Posted / sweta

select sequencename.currval,sequencename.nextval from dual;

What is sql character function?

1064

---

How to process query result in pl/sql?

1116

---

What is offset in sql query?

1100

---

explain the difference between delete , truncate and drop commands? : Sql dba

1079

---

What do we need to check in database testing?

1012

---

Does sqlite need a server?

1042

---

Can there be 2 primary keys in a table?

993

---

Differentiate between sga and pga.

1155

---

Why is sql*loader direct path so fast?

1099

---

What is a system versioned table?

975

---

What is the purpose of primary key?

1012

---

What is the difference between functions, procedures, and packages in pl/sql?

1037

---

What are the different dml commands in sql?

1164

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1114

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2138

---