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....'

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

What are the different types of sql commands?

0 Answers  

---

What is the difference between join and natural join?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

Does truncate release storage space?

0 Answers  

---

What is an ndf file?

0 Answers  

---

How do I create a sql database?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

how to start mysql server? : Sql dba

0 Answers  

---

What is sql basics?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

define different types of trigger. : Sql dba

1 Answers  

---