Can you create a table by using pl/sql?if u so justify your answer;

This question is related to Oracle Interview

Questions by srinivasakumar.ch

Showing Answers 1 - 13 of 13 Answers

cd

  • Mar 28th, 2006
 

we cannot create a table using pl/sql

  Was this answer useful?  Yes

srinivas

  • Apr 3rd, 2006
 

it is a challenging question.

 i think many were afraid...come on do it

  Was this answer useful?  Yes

Praveen

  • Apr 4th, 2006
 

We can create a table using Dynamic SQL.Without using Dynamic SQL,we can't create.

i.e execute immediate 'create table ' etc.

  Was this answer useful?  Yes

Pawan Ahuja

  • May 15th, 2006
 

Hi,

We can create table by using pl/sql,by using dynamin sql

begin

execute immediate 'Create table hello(name varchar2(12),eno number));'

end;

PAWAN AHUJA

ch_1111111@yahoo.com

  • May 16th, 2006
 

  yes thats right answer..thanx and bye

  Was this answer useful?  Yes

dhinesh

  • Aug 29th, 2006
 

We can't create the table by using PL/SQL.
PL/SQL is for retriving more than one record in a table.

  Was this answer useful?  Yes

lokesh rustagi

  • Oct 17th, 2006
 

no we can not create table with pl/sql.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions