Answer / Gauri Shankar Mishra

Table, Query, Form, Report, and Macro.

How to rename a table?

1 Answers  

---

How to download oracle sql developer?

1 Answers  

---

List out the acid properties and explain?

1 Answers  

---

What does select count (*) mean in sql?

1 Answers  

---

Explain autonomous transaction.

1 Answers  

---

How do rank () and dense_rank () differ?

1 Answers  

---

Is it possible to access the current value in a session before accessing next value?

1 Answers  

---

What are the usages of sql?

1 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Mention what pl/sql package consists of?

1 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---