oracle constraints?

Constraints are used to prevent invalid data entry into tables.
There are 5 types
1) NOT NULL
2) UNIQUE
3) PRIMARY KEY
4) FOREIGN KEY
5) CHECK

NOT NULL: Does not allow null values.That means, you can't  enter a row into the table without providing a value for the NOT NULL column.

UNIQUE: Does now allow duplicates. That means, you can't enter duplicate values into UNIQUE column but you can enter null values.

PRIMARY KEY: It works with features of  NOT NULL + UNIQUE.

FOREIGN KEY: Used to create a Parent-Child or Master-Detail relation ship between two tables. Having define foreign key on Child table, you cant enter a record into child table with out having related value in Parent Table:

CHECK: With this, one can define a range on column and we can enter values into the column only within the defined range

Cognos Report Studio: Prompt Expressions between Relational and Dimensional Packages..

Prompt expressions use the following syntax, where p represents the parameter name.

You can also use these expressions to create parameterized data items.

Relational: Detail Filter	Dimensional: slicer expression or filter expressions
[data item] = ?p? for single-select prompts	[level or hierarchy]->?p? For single-select member prompts and master detail relationships
[data item] in ?p? for multi-select prompts	set([level or hierarchy]->?p?) For multi-select member prompts