not null constraint applied on table level constraint but table must be emp

why can't we assign not null constraint as table level
constraint

Question Posted / senthil

Answer Posted / senthil

not null constraint applied on table level constraint but table must be empty otherwise not possible .

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2294

How to drop a tablespace?

1048

Where are the settings stored for each instance in oracle?

1105

What language does oracle use?

1107

What happens if you use a wrong connect identifier?

1069

How to update values in a table in oracle?

1026

How to use subqueries with the in operator using oracle?

1091

How to check the oracle tns settings?

1047

What is the relationship among database, tablespace and data file?

989

what is meant by magic query

2188

What are the different types of partitions in oracle?

979

How to display row numbers with the records?

1081

What are the parameters that we can pass through a stored procedure?

1067

Is oracle a programming language?

993

What types of joins are used in writing subqueries?

985