Answer / sohail

Constraint is a restriction on table.There are two types of
constraints 1.ananymous constraint and 2.named
constraint.under named and ananymous constraints there are
1.primary key constraint
2.foreign key constraint
3. not null constraint
4. check constraint
5. unique constraint.

Answer / pavani

Constraint means it is rule which you want to apply on the
table. There are two types of constraints.
1. Column Constraints: Applicable for that column only.
2. Table Constraints: Applicable for more than one column.

Column Constraints:
a. unique b. not null c. primary key d. foreign key
e.default f. check

Table constraints:
a. unique b. primary key c. foreign key d. check

Answer / 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

Answer / samuvel

Constraint is a restriction on table

Types:

1)Column Constraints:applicable for column level
i)unique ii) not null

2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check

Answer / ravi

constraints are two types
1.Rule based constraint
2.cost based constraint

What is sql*loader and what is it used for?

0 Answers  

---

Main diff between varray and nested tablea

3 Answers   Polaris, TCS,

---

What are the various levels of constraints?

0 Answers  

---

How do you update a value in sql?

0 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

---

What is sql used for?

0 Answers  

---

what are string data types? : Sql dba

0 Answers  

---

what is union, minus and interact commands? : Sql dba

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

What is pivot query?

0 Answers  

---

How do sql triggers work?

0 Answers  

---