why can't we assign not null constraint as table level
Answers were Sorted based on User's Feedback
Answer / lokanath
Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.
|Is This Answer Correct ?||10 Yes||12 No|
Answer / 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|
Answer / newton_dba
A NOT NULL CONSTRAINT IS USAUALLY APPLIED ON COLUMN LEVEL
BUT IT CAN BE APPLIED ON THE TABLE LEVEL BY USING ALTER
ALTER TABLE EMP
MODIFY (ENAME CONSTRAINT EMP_ENAME_NN NOT NULL);
|Is This Answer Correct ?||7 Yes||12 No|
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
What are Clusters ?
what is exact difference between drop and truncate table.
hai, when to use char and varchar2....?
What is materialized view in Oracle?
how many types of index?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Can a formula column referred to columns in higher group ?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?