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

Explain how exception handling is done in advance pl/sql?

754


Does sql full backup truncate logs?

787


How to add new employee details in an employee_details table with the following details

849


How do you know if a relationship is 2nf?

707


How do you exit in sql?

833


What are the set operators in sql?

800


Why is pl sql needed?

703


What is graph sql?

743


Is left join faster than inner join?

868


explain the delete statements in sql

764


What happens when a trigger is associated to a view?

698


What is pl sql block in dbms?

735


Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

767


What is parallel hint?

958


What is normalization in sql?

745