USER CONSTRAINTS
We can use describe command to view logical structure of the table. It displays table structure including column name, data type, size & not null constant. It does not provide information aboutRead More…
We can use describe command to view logical structure of the table. It displays table structure including column name, data type, size & not null constant. It does not provide information aboutRead More…
In our post “I/O Constraint” and “Business Constraints” we had seen how we can add constraints at the time of table creation using Create table command. If you have not read ourRead More…
Business constraint defines business rules or business policy. Each organization have their specific rules about the data store. Check constraint can be used to define business rules. Check Constraint When constraint cannotRead More…
I/O Constraints Constrains that control data insertion and data retrieval speed are known as I/O (Input-Output) constraints. It includes the following constraints. Primary Key Foreign Key Unique Key Not Null Primary KeyRead More…
Sometimes we need to provide some restriction on the data for security and data integrity reason. We must ensure that only valid and complete data should be stored into the database. OracleRead More…