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

What is a recursive join sql?

597

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

605

---

What does the argument [or replace] do?

581

---

What is before and after trigger?

518

---

How to add new employee details in an employee_details table with the following details

650

---

---

how to write date and time literals? : Sql dba

533

---

Can we join tables without foreign key?

522

---

What is java sql package?

539

---

Describe sql comments?

564

---

How do I run a sql trace?

522

---

What is varchar sql?

620

---

When do we use triggers?

585

---

Why cross join is used?

637

---

How to execute a stored procedure?

565

---

What is %type in pl sql?

542

---