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

How exception is different from error?

533

---

Enlist some predefined exceptions?

570

---

What is scope of pl sql developer in future?

582

---

How do I remove duplicates in two columns?

500

---

Explain constraints in sql?

563

---

---

How can you fetch first 5 characters of the string?

540

---

What is primary key in db?

511

---

How to Declare Fixed Length String Value In PL SQL

655

---

Why do we need view in sql?

540

---

How do I run a sql query in pgadmin 4?

534

---

Is hadoop a nosql?

566

---

What is sql and also describe types of sql statements?

553

---

What is a dynamic query?

563

---

Can we create index on primary key?

515

---

What are the differences between in and exists clause?

556

---