Answer Posted / sri

For example,u have a table called student like below.

STUD-NAME SUBJECT
--------- ------
STUD1 A
STUD2 B
STUD2 A
STUD1 A

in this structure 1 row is duplicated in 4 th. so we can
fetch the student name using the below qry.

SELECT stud-name FROM STUDENT
GROUP BY stud-name,subject
HAVING COUNT > 1.

Explain polymorphism in pl/sql.

1171

---

how to convert numeric values to character strings? : Sql dba

1156

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1289

---

How many types of primary keys are there?

1078

---

Explain how to use transactions efficiently : transact sql

1017

---

Is t sql a programming language?

1112

---

what is the use of friend function? : Sql dba

1057

---

What is file based approach?

997

---

What is compilation error in pl sql?

1023

---

What is data modelling in sql?

1073

---

What is delimiter in pl sql?

1098

---

How many types of normalization are there?

1013

---

How many types of literals are available in pl sql?

1166

---

What is a sql statement?

1016

---

What is the advantage of nosql?

1113

---