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

Can a foreign key have a different name?

733


Why do we need cursor in pl sql?

870


What is db journal file?

723


What are character functions in sql?

709


What is sql and how does it work?

787


what is denormalization. : Sql dba

820


explain the options of myisamchk to improve the performance of a table. : Sql dba

758


Which is faster count (*) or count 1?

793


What are properties of the transaction?

773


Explain the difference between triggers and constraints?

747


What is trigger in pl sql with examples?

788


Is sql similar to python?

748


What is row_number () in sql?

776


can a stored procedure call itself or recursive stored procedure? : Sql dba

785


what are properties of a transaction? : Sql dba

801