Answer Posted / anish kumar anand

create table emp
(empno varchar2(10) constraint empnopk primary key,
e_id varchar2(10) constraint eiduk unique not null);

How do you use a while loop in pl sql?

553

---

Is ms sql traffic encrypted?

515

---

What is the plv (pl/vision) package offers?

629

---

What are different types of keys?

538

---

What is the default isolation level in sql server? : Transact sql

582

---

---

What is delete command in sql?

569

---

Explain what is table in a database?

595

---

How many joins in sql?

574

---

Can we join two tables without common column?

526

---

what is the difference between char_length and length? : Sql dba

588

---

How many disk partitions should I have?

565

---

Is null operator in sql?

623

---

Can ddl statements be used in pl/sql?

606

---

What are the different set operators available in sql?

575

---

List the ways to get the count of records in a table?

522

---