Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Can we write create command in the plsql block?if possible
how?

Question Posted / aparna

Answers were Sorted based on User's Feedback



Can we write create command in the plsql block?if possible how?..

Answer / umadevi

yeah the above answer is correct..

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

Is This Answer Correct ?    11 Yes 0 No

Can we write create command in the plsql block?if possible how?..

Answer / sidh

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

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

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

What is server name sql?

0 Answers  

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

What is the difference between a procedure and a function?

0 Answers  

What is varchar sql?

0 Answers  

Can a key be both primary and foreign?

0 Answers  

What is trigger and types?

0 Answers  

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

How to use sql*plus built-in timers?

0 Answers  

How do rank () and dense_rank () differ?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories