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 the difference between union and union all? : Sql dba

1024

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2497

---

Can you join views in sql?

961

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1643

---

Why is pl sql needed?

956

---

What is graph sql?

996

---

What are different types of triggers?

1114

---

What is sql basics?

1046

---

What are the advantages of sql? Explain

1107

---

What are sql*plus environment variables?

1098

---

How do I view a sql database?

1023

---

What is error ora-01000: maximum open cursors exceeded

1150

---

How do you update a value in sql?

1047

---

What is relationship? How many types of relationship are there?

1188

---

Is id a reserved word in sql?

1151

---