Answer Posted / satish reddy

Each table can have only one primary key; however, that key may consist of more than one column.

SQL> create table EMP(EMPNO Number(5),EMPNAME Varchar2(10),ADDRESS Varchar2(10),Constraint Multi_Constr
aint Primary Key(EMPNO,EMPNAME));

After creating table try to insert null value into EMPNAME Column, it will throw an error "cannot insert NULL into ("SCOTT"."EMP"."EMPNAME")"

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1134

---

What is the difference between inner join and left join?

1038

---

What is the main reason behind using an index?

1059

---

Why are indexes and views important to an organization?

999

---

how to install mysql? : Sql dba

1161

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2552

---

how can we repair a mysql table? : Sql dba

1043

---

how many ways to get the current time? : Sql dba

1048

---

What is the sql*loader? : aql loader

1102

---

Can we use view in stored procedure?

955

---

how to calculate the difference between two dates? : Sql dba

1115

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

1039

---

What is sql in oracle?

1109

---

what is error ora-03113: end-of-file on communication channel?

1227

---

What is a relationship and what are they?

1228

---