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

GeekInterview.com > Placement Papers > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 30 of 32

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

Total Answers and Comments: 8

Last Update: June 14, 2008 Asked by: srinivasakumar.ch

Sponsored Links

Best Rated Answer

—

Submitted by: Pawan Ahuja

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

Above answer was rated as good by the following members:
Bhoomika sharma

March 28, 2006 04:32:52

RE: can you create a table by using pl/sql?if u ...

we cannot create a table using pl/sql

Is this answer useful? Yes | No

April 03, 2006 06:57:14

srinivas

RE: can you create a table by using pl/sql?if u ...

it is a challenging question.

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

Is this answer useful? Yes | No

April 04, 2006 01:27:15

Praveen

RE: can you create a table by using pl/sql?if u ...

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

i.e execute immediate 'create table ' etc.

Is this answer useful? Yes | No

May 15, 2006 11:07:34

Pawan Ahuja

RE: can you create a table by using pl/sql?if u ...

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 16, 2006 02:33:21

ch_1111111@yahoo.com

RE: can you create a table by using pl/sql?if u ...

yes thats right answer..thanx and bye

Is this answer useful? Yes | No

August 29, 2006 02:16:51

dhinesh

RE: can you create a table by using pl/sql?if u ...

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

Is this answer useful? Yes | No

October 17, 2006 05:38:39

lokesh rustagi

RE: can you create a table by using pl/sql?if u ...

no we can not create table with pl/sql.

Is this answer useful? Yes | No

June 14, 2008 05:59:57

ravi.8311

Member Since: June 2008 Contribution: 7

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

yes we can create table by using pl/sql progarm.ravi

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank