Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210585 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / umapathy.r
The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null
| Is This Answer Correct ? | 1164 Yes | 121 No |
Post New Answer View All Answers
What is a nested table?
How to convert dates to characters in oracle?
What is meant by an index?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What do you understand by a database object? Can you list a few of them?
How do I limit the number of rows returned by an oracle query after ordering?
Can you tell me how to add new column in existing views?how?How is possible?
How many types of segments in Oracle?
How to get execution statistics reports on query statements?
How can windows applications connect to oracle servers?
Explain oracle left join with an example?
definition of cluster and non-clustered index?
How to rename an index in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is a nested table and how is it different from a normal table?
