Answer Posted / manoj

see cautiously the major difference b/w unique and
distinct

UNIQUE :Allways take part on DATA INSERTION (In brief)
DINTINCT:Allways concern on data retrival (In brief)

Now we will take following case
when

case 1: UNIQUE KEY is defined (may b 4 one or more column)

It means this constraint will not allow us to
INSERT duplicate record/column_value(s)(i.e. exactly
same record/column_value(s) again for specified key column
(s)only)


NOW if u use DISTINCT clause in query
(select DISTINCT.from.)the will b same as simple query
(select....from...)

Bcoz data are already not repeated (bcoz of constraint)


case 2:if UNIQUE not defined

data may b repeated and DISTINCT will now useful


Have eye on Major difference

(and we never use UNIQUE CONS.. in select.....)

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

974

---

What is forward declaration in pl sql?

1005

---

How to run sql functions in pl/sql?

987

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

955

---

Which is faster union or join?

898

---

What is set serveroutput on in pl sql?

1192

---

What is embedded sql what are its advantages?

958

---

What does closing a cursor do?

1240

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4093

---

what are different types of collation sensitivity? : Sql dba

1021

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

967

---

Explain how can you save or place your msg in a table?

979

---

which types of join is used in sql widely? : Sql dba

928

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

964

---

Why use stored procedures?

1016

---