SQL


27 Requested Topics

SQL CURSOR Cursor is used in databases to manipulate individualy the rows returned by a querie. The rows are processed sequentially, allowing read the data and take some action prior to read next value. requested by Ricardo Pontual 1,973 3 comments
Three Valued Logic (3VL) Explanation with examples of 3VL used by SQL requested by Cristian Abelleira 272 4 comments
Transaction Management Using Logical Units of Work and the COMMIT and ROLLBACK commands requested by Bernard Dy 1,701 1 comment
Constraints Constraints are the rules enforced on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database. Constraints could be column level or table level. Column level constraints are applied only to one column, whereas table level constraints are applied to the whole table. requested by Adrian 2,700 3 comments
View more

6 Need Improvement

DELETE missing detail
GROUP BY missing detail
Create a New Table not helpful, unclear
Sequence missing detail
View more

0 Proposed Changes

No proposed changes.

Changes which need review will be displayed here.