Answer / umadevi

yeah the above answer is correct..

begin
execute immediate 'create table tablename(column_name
coloumn_type(coloumn_length))';
end;

Answer / sidh

Yes We can write a create command in a PL/SQL block using
dynamic SQL

eg Execute immediate 'create table tab_name....'

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

---

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

---

what is the difference between blob and text? : Sql dba

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

---

What is t-sql? : Transact sql

0 Answers  

---

What is a .db file?

0 Answers  

---

What does (+) mean in sql joins?

0 Answers  

---

What is use of term?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---