Answer Posted / manoranjan sethy

Select LAST_DAY(Sysdate) From Dual;

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1047

---

Are sql database names case sensitive?

948

---

What are the types of keys?

942

---

What will you get by the cursor attribute sql%rowcount?

981

---

how to delete an existing column in a table? : Sql dba

962

---

what are the differences among rownum, rank and dense_rank? : Sql dba

999

---

Explain normalization and what are the advantages of it?

906

---

Can we use join in subquery?

1038

---

What is the difference between left and left outer join?

899

---

Enlist the data types that can be used in pl/sql?

1021

---

Which are the different types of indexes in sql?

1013

---

What is the use of & in pl sql?

997

---

Is sql pronounced sequel or sql?

1224

---

how to see the create table statement of an existing table? : Sql dba

957

---

Mention what is the use of function "module procedure" in pl/sql?

1018

---