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 requirement of self-join?

1202

---

How is a PL/SQL code compiled?

1279

---

What are the types of sql commands?

1151

---

What is data type in sql?

997

---

How do you select unique values in sql?

1040

---

List different type of expressions with the example.

965

---

What are the sql commands?

1222

---

difference between anonymous blocks and sub-programs.

1185

---

When can we use the where clause and the having clause?

1076

---

What are sql ddl commands?

1135

---

what are enums used for in mysql? : Sql dba

1226

---

How to execute a stored procedure?

1149

---

Can sql developer connect to db2?

1100

---

How to revise and re-run the last sql command?

1212

---

What is a primary key called that is made up of more than one field?

1392

---