What are the pre requisites?
Answer / 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 |
What is the use of triggers?
How do you optimize a stored procedure query?
What is pls integer?
What is an Integrity Constraint?
How to disable a trigger name update_salary?
What will you get by the cursor attribute sql%rowcount?
Store procedure will return a value?
Does postgresql run on the cloud?
What is a subquery in sql?
What is a native sql query?
Why primary key is required?
How do you explain an index number?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)