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

What are the pre requisites?

Answer Posted / guest

I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?

To Modify the datatype of a column the column must be empty.

To add a column with NOT NULL constrain, the table must be
empty.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Advantages and disadvantages of stored procedure?

1165


Is vs as in pl sql?

1029


how mysql optimizes distinct? : Sql dba

1119


What is sql architecture?

1098


Why cross join is used?

1132


How do you create a unique index?

1091


how to include comments in sql statements? : Sql dba

995


Is sql a microsoft product?

990


What are the different dml commands in sql?

1241


Is a secondary key the same as a foreign key?

1110


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

1213


How can I see all tables in sql?

1139


What are local and global Indexes and where they are useful.

1490


Which version of sql do I have?

1105


Why do we use %rowtype & %type in plsql?

1092