Interested to Buy Any Domain ? << Click Here >> for more details...
what is unique key?
- 14 Answers
- 27263 Views
- Amazon, Cap Gemini, Infosys, Wipro, I also Faced
- E-Mail Answers
Answer Posted / gyana ranjan behera
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use "out" parameter properly?
What is hot backup and logical backup?
Can we convert a date to char in oracle and if so, what would be the syntax?
How do I recompile a procedure in oracle?
ABOUT IDENTITY?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What privilege is needed for a user to query tables in another schema?
What are the uses of a database trigger?
Can a parameter be passed to a cursor?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the oracle built-in data types?
Give the various rollback segment states.
How to start your 10g xe server?
What do you mean by merge in oracle and how can you merge two tables?
> 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?
