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

What is pl sql variable?

512

---

What is acid property in a database?

586

---

Is hadoop a nosql?

577

---

How can the performance of a trigger be improved?

592

---

What is mdf ldf and ndf?

563

---

---

What is audit logout in sql profiler?

591

---

Explain constraints in sql?

575

---

What is meant by user defined function?

583

---

what is isam? : Sql dba

575

---

Explain what is a column in a table?

573

---

What is pl/sql table? Why is it used?

561

---

How to check if a column is nullable before setting to nullable?

585

---

Why join is faster than subquery?

602

---

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

500

---

How many unique keys can a table have?

559

---