Answer Posted / sujit.1551

constraint are nothing but a conditions,in other words
enforcing the business rules into the database.
types of constraits:
1)check constraint
2)unique constraint
3)primary key
4)foreign key
5)Not null
6)Default

How can you load microsoft excel data into oracle? : aql loader

1175

---

how can you see all indexes defined for a table? : Sql dba

1000

---

How many aggregate functions are available there in sql?

986

---

Does view contain data?

1039

---

Can we use view in stored procedure?

903

---

what are the differences between char and nchar? : Sql dba

1115

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1055

---

Describe sql comments?

1046

---

How do you go back in sql?

991

---

What is rename in sql?

978

---

What is Collation Sensitivity ? What are the various type ?

954

---

What do you mean by stored procedures? How do we use it?

996

---

What does sign mean sql?

1120

---

how to include numeric values in sql statements? : Sql dba

1103

---

What is dynamic query?

982

---