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
Explain how exception handling is done in advance pl/sql?
Does sql full backup truncate logs?
How to add new employee details in an employee_details table with the following details
How do you know if a relationship is 2nf?
How do you exit in sql?
What are the set operators in sql?
Why is pl sql needed?
What is graph sql?
Is left join faster than inner join?
explain the delete statements in sql
What happens when a trigger is associated to a view?
What is pl sql block in dbms?
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 ?
What is parallel hint?
What is normalization in sql?