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")"

Why is the cursor important?

1046

---

What is set transaction?

1040

---

What if we write return in procedure?

1431

---

Is sql an operating system?

1021

---

Can we insert data into materialized view?

947

---

is mysql query is case sensitive? : Sql dba

1105

---

discuss about myisam key cache. : Sql dba

1024

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

How do you exit in sql?

1113

---

What is clause?

1156

---

what are the type of locks ? : Sql dba

966

---

What is the difference between python and sql?

1008

---

How do I run a sql query in pgadmin 4?

964

---

Explain two easy sql optimizations.

1016

---

How much does sqlite cost?

1044

---