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
What is the use of desc in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Can dml statements be used in pl/sql?
What is a procedure in pl sql?
How do I tune a sql query?
What are local and global variables and their differences?
what is recursive stored procedure? : Sql dba
Is it possible to update views?
what is the difference between where clause and having clause? : Sql dba
how do you control the max size of a heap table? : Sql dba
How does sql profiler work?
How do I run sql?
What are hotfixes and patches?
what is a field in a database ? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?