Answer Posted / santosh kumar

declare
v_ddl_stat varchar2(200):='create table '||'&table_name'||'
('||'&column_names'||')'; --col_name like(eid number(5),name
varchar2(10))
begin
EXECUTE IMMEDIATE v_ddl_stat;
END;
/

In a distributed database system, can we execute two queries simultaneously?

750

---

What is an exception in PL/SQL? What are the two types of exceptions?

848

---

What is trigger in sql? Explain

698

---

Is left join and outer join same?

765

---

Which sorts rows in sql?

768

---

---

What is nvarchar max in sql?

748

---

What are tuples in sql?

773

---

How do you rank data in sql?

680

---

How delete all data from all tables in sql?

685

---

Is clustered index a primary key?

689

---

Can a commit statement be executed as part of a trigger?

797

---

How do you sort in sql?

774

---

What does := mean in pl sql?

754

---

What is a system versioned table?

700

---

What are triggers in sql?

749

---